‎2007 Aug 14 8:38 PM
Hi,
I have 20 fields, which are contained in 3 different structures.
How do I find out where the data is being taken from? If anyone knows where these fields data comes from, such would be appreciated as well.
The following are the fields and tables:
Field.........................Table
I_PARNR..................STRUCTURE - DIIHPA
NAME_LIST..............STRUCTURE - DIIHPA
TXTCDOT..................STRUCTURE - RIWO00
TXTCDFE..................STRUCTURE - RIWO00
BAUTX......................STRUCTURE - RIWO00
VORNR.....................STRUCTURE - RIWO00
VORKTEXT...............STRUCTURE - RIWO00
TXTCDUR..................STRUCTURE - RIWO00
TXTCDSM.................STRUCTURE - RIWO00
SMSTTXT..................STRUCTURE - RIWO00
SMASTXT..................STRUCTURE - RIWO00
TXTCDMA..................STRUCTURE - RIWO00
FERTVORN...............STRUCTURE - RQM00
FEHLBEWC..............STRUCTURE - RQM00
MERKTEXT...............STRUCTURE - RQM00
ARBPLFE.................STRUCTURE - RQM00
ARBPLFET...............STRUCTURE - RQM00
PARNR_VERA..........STRUCTURE - RQM02
NAME_VER..............STRUCTURE - RQM02
NAME_QM................STRUCTURE - RQM02
All help will be greatly appreciated and usefull answers will be rewards.
Thanks,
John
‎2007 Aug 14 8:47 PM
Before executing program or transaction which populates this structures, activate SQL trace (transaction ST05). Do your action and deactivate, then in the log you'll have read / written tables.
This is most common method.
If you want to know at field label, you can navigate to related data element, and then search for dictionary objects using that data element. In some cases the tables are few and you find out that way.
Regards.
Message was edited by:
Alejandro Bindi
‎2007 Aug 14 8:54 PM
The problem with the data element solution is that none of these are included in tables. I will try the ST05 option, and will keep you posted.
‎2007 Aug 14 9:00 PM
Check out also <a href="http://www.itp-consulting.com/findit.pdf">this file</a>, it's very useful and explains the SQL trace among other options for finding out sources of data.
Regards.
‎2007 Aug 14 8:48 PM
Hi,
Can you try with ST05 , and search thru the list of traces.
aRs