database tables

[Former Member]

i need to know the underlying table(s) that store the amounts that are displayed in account display in tcode fpl9

[Former Member]

Just run hte Sql trace <b>Tcode ST05 </b> and capture the tables that are being updated with the transaction .

By this u can see the underlying tables for your transaction.

regards,

vijay

[Former Member]

Hello,

Start the SQL trace thro Tc ST05 and call the Tc fp19. And stop the trace and click list.

It will list all the table which are all used to display the data for the transaction.

From that u can filter out the latest dates.

If useful reward.

Vasanth

[Clemenss]

Hi,

everything in DFKKOP.

Regards,

Clemens

[Former Member]

but if i delete a record in DFKKOP and i go to account display i can still see the amount belonging to the document that i deleted but the text of transaction wont be there. i need to delete the amount that is being displayed in account display

[Manohar2u]

DFKKOP* ...try in DFKKOPK...its all depends on the type of document...it it has reverse...if is is cleared...then sits in different tables...try also checking DFKK* tables

[Former Member]

HI,

I do not find any FP19 tcode in our system. Another way to find the system tables is by executing SM12 -> Display and Delete Locks in a separate session.

Execute your standard SAP in another session and check the tables that get locked in another screen by executing SM12.

Regards

Subramanian

[Clemenss]

Hi,

not FP19, FPL9 is the account display in component Contract Accounting, AKA RM-CA or FI-CA.

Regards,

Clemens.