2006 Apr 25 6:20 PM
Hello Guru's,
I have been thinking about a report where the users enters the field name as input parameter and he gets a list of transactions which can updates that field. Did some looking around thought about using the where used list for field and TSTC table but was not able to think about a logic which would give a complete list.
Was wondering if any of you have thought about the similar program or if you can think of a way using which I can code it ?
Thanks
Saket....
Hello Guru's,
I have been thinking about a report where the users enters the field name as input parameter and he gets a list of transactions which can updates that field. Did some looking around thought about using the where used list for field and TSTC table but was not able to think about a logic which would give a complete list.
Was wondering if any of you have thought about the similar program or if you can think of a way using which I can code it ?
Thanks
Saket....
2006 Apr 25 6:24 PM
Hi,
I don't think it will be that straight forward, as the SAP standard program that actually update the field will have lot of nesting and cannot found at the transaction level.
Regards,
Ravi
Note : Please mark all the helpful answers
2006 Apr 25 6:27 PM
2006 Apr 25 6:30 PM
I will take table... can you think of a logic using which I can do the same ?
2006 Apr 25 6:33 PM
Hi Saket,
At Table level,there is a transaction called <b>SARA</b> where you can see the tables used for the different transactions.Though the tcode is for archiving,it can be used to view the details...
2006 Apr 25 6:36 PM
I don't think it is possible. At least you cannot garantee that your list would be complete as you virtually cannot count dynamic usage of table.
2006 Apr 25 6:38 PM
Can you give me an example..tried looking at SARA tcode but don't understand how it can be used for same ?
2006 Apr 25 6:42 PM
I agree with Sergei, even if you are able to find the tables, there can be no gaurantee that those are the only tables being updated by a specific transaction / that these tables are being updated by only that transaction.
For example - EKKO table, you would expect that it would be updated by ME21n and that is what you will find in the SARA transaction because you are archiving only the PO's. Now this table will be updated by the MIRO / MIGO transactions as well for the Invoices / GR transactions.
Regards,
Ravi
Note : Please mark the helpful answers