TABLES IN SAP TRANSACTION

[Former Member]

IS THERE ANY WAY TO KNOW FOR WHICH TRANSACTION CODE WHICH

DATABASE TABLE UPDATE????????

EXAMPLE LIKE.

FOR

VA01 T-CODE WHICH DATABASE TABLE UPDATE.

<b>FOR SD,MM,FI MODULES</b>

[Former Member]

tran. <b>se49</b>. or<b> st05</b>

[Former Member]

Set the SQL trace ON in transaction ST05 and execute the transaction. Switch off the trace and view the log. All the tables used in the transaction will be available in the log.

[Former Member]

Hi Nehal,

If you Run SQL Trace on a Transaction and see the analysis, you will see which are the Table being updated.

Hope this Helps.

Manish

[Former Member]

If urs is 4.6c & 4.7 means goto transaction SE49 & give the transaction there to list the affected tables

[Former Member]

Hi,

Goto transaction --> determine the program name. --> Goto TOP module in program name --> There TABLES clause you can find what tables are using.

Regards

Bhupal Reddy

[Former Member]

Hi Neha

Please try with FM: <b>RS_PROGRAM_TABLES</b>

Object type: <b>TRAN</b> and Object Name: Transaction for which you need to check.

Kind Regards

Eswar

Thanks to Uwe.