Page 1 of 1

Automation of SAP transaction analysis

Posted: Tue Sep 15, 2009 11:55 pm
by mainoffender
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.

Re: Automation of SAP transaction analysis

Posted: Wed Sep 16, 2009 3:53 am
by Rich
Have you looked at SE11->Database Table->Graphic for table relations, or had a look at transaction SE36 ?


Rich

Re: Automation of SAP transaction analysis

Posted: Fri Sep 18, 2009 12:48 am
by mainoffender
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!

Re: Automation of SAP transaction analysis

Posted: Sun Sep 20, 2009 10:35 pm
by Rich
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.

Re: Automation of SAP transaction analysis

Posted: Thu Sep 24, 2009 11:20 am
by new2sapfans
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.