Table Dependencies for FBV0 document posting

[Former Member]

Hi Gurus,

I would like to ask if anyone of you would be familiar with what tables are being updated once a customer/vendor/GL document is posted using the transaction code FBV0 (aside from BKPF, BSEG, BSIS/BSAS, BSIK/BSAK, BSID/BSAD, FAGLFLEXA and FAGLFLEXT tables)

Kindly advise as we will be doing a table update for the field GSBER.

We know this is not advisable, but this is the only solution we have right now

Thanks and best regards

Edited by: pinoy sap on Nov 25, 2009 4:45 AM

[former_member221515 · Accepted solution]

In case of Vendor Invoice, if withholding tax is involved, table WITH_ITEM is also updated.

[iklovski]

Hi,

The best way to know what tables are updated upon certain transaction is to go to Menu - System - Utilities - Performance Trace. Activate a trace, perform your transaction, and the go to the same path and deactivate the trace and display it. You will see all the SQL processes that the system executes.

Regards,

Eli

[Former Member]

Go to SE11, fill GSBER in data type, then click where-used list button, you can see all tables using this element.

And I think you may also consider tables about CO.