Find where the data is stored in SAP
http://it.toolbox.com/wiki/index.php/Find_where_the_data_is_stored_in_SAPIntroduction
This HOWTO will give the steps you need to find where the data isstored in SAP when you want to create an ABAP query or ABAP report usingfields that you can find on transaction screens.
Steps
[*]The first step is always to find out the table and field name ofthe screen field.With the cursor in the field you want, press F1 orclick on the "?".
[*]The initial help screen will give you descriptions andinformation about the field.
[*]From there press F9 or click on .
[*]Here you can get names of the table, field and the dataelement.
[*]If you are lucky the system gives you a transparent table name.If you're not lucky you'll get a structure name.
[*]Doubleclick on the data element and search via the where usedof the dictionary.
[*]Failing above you can set up the TCODE or a portion of it justbefore screen where the field exists and then switch on SQL Trace, runthe screen, turn off SQL trace and then list the Trace Log followingwhich tables/views were hit.Obviously it is best to turn on and offthe trace in the smallest time-window possible to lessen the number ofTrace Log entries you have to look through.
[*]Another thing to try is : run program RSSDOCTB. This gives you alist with info about the table such as fields, check tables ....
[*]Or try Transaction SE84 (Repository Info System)- Select in thetree ABAP Dictionary -> Fields -> Table Fields - Insert in theSelect-Option "Field name" the name of the files (E.g. CARRID andCONNID) and execute it - now you will get a list of all tables whichhave one or both of this fields - it's easy to identify the tables whichcontain both fields in the list.
[*]Or start an sql trace and look at the tables that are read
[*]Last resort, find the program name (click on the triangle iconat botton right to expand information and click on the icon right ofclient number) and look the ABAP code with TCODE SE38
[*]Run SE30 against your transaction.When you've done what youneeded to do and returned, Hit analyze.Click the hits list.You getall of the modules, tables, forms, FMs,... that were called.Look forinteresting names. (EG. Read_structure_name )
All of these solutions will fail you from time to time.At thispoint, keep on digging:
[*]Look for other screens that contain the same data.If youchange it in screen A and the change is duplicated in screen B then youhave found another data location to apply the above steps in.
[*]Look for the data point in canned reports and apply the abovesteps.Also note that it is much harder for the access mode to behidden when you are doing reporting.
页:
[1]