Automation of SAP transaction analysis

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
mainoffender
Posts: 2
Joined: Tue Sep 15, 2009 5:47 am

Automation of SAP transaction analysis

Post by mainoffender » Tue Sep 15, 2009 11:55 pm

Hi everyone!
My name is Max and I’ve been an ABAP programmer for 6 years now. Since my work is closely connected with SAP I have to face the very same annoying problem pretty often. The thing is, sometimes it is vital important to know the base data model and an internal structure of SAP transactions which are typically very complex and are always developed in a messy manner. So even for a professional it is hard and so time-consuming to find lead essences act in transaction, its relations and key fields, enhancement and integration points etc.
So I start wondering if there is any kind of program, utility or application that might automate the process, completely or partially, and finally lighten things up.
Any ideas? Thanks in advance.
Sincerely, Max.

Rich
Posts: 7116
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool
Contact:

Re: Automation of SAP transaction analysis

Post by Rich » Wed Sep 16, 2009 3:53 am

Have you looked at SE11->Database Table->Graphic for table relations, or had a look at transaction SE36 ?


Rich
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com

mainoffender
Posts: 2
Joined: Tue Sep 15, 2009 5:47 am

Re: Automation of SAP transaction analysis

Post by mainoffender » Fri Sep 18, 2009 12:48 am

Rich wrote:Have you looked at SE11->Database Table->Graphic for table relations, or had a look at transaction SE36 ?


Rich
well, of course I did, the question is how much it takes to find all those relations, cos it could sometimes take up to a week or two!

Rich
Posts: 7116
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool
Contact:

Re: Automation of SAP transaction analysis

Post by Rich » Sun Sep 20, 2009 10:35 pm

mainoffender wrote:
Rich wrote:Have you looked at SE11->Database Table->Graphic for table relations, or had a look at transaction SE36 ?


Rich
well, of course I did, the question is how much it takes to find all those relations, cos it could sometimes take up to a week or two!
Did you select (In the graphic program), Utilities->Get->Check Tables and Utilities->Get->Foreign Keys ?

There is one other problem. If a table is related to some other table, but it has not been referenced as a check or lookup table then this method will not find it.
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com

new2sapfans
Posts: 71
Joined: Thu Jan 01, 2009 11:01 am

Re: Automation of SAP transaction analysis

Post by new2sapfans » Thu Sep 24, 2009 11:20 am

Are you asking for a way to find out "tables/data model used by any given transaction"?
For e.g. given VA01, find a way to enlist all tables accessed by it?
I guess only ST05 / SE30 would give such a table listing.

Post Reply