topic Re: database tables in Application Development and Automation Discussions

database tables

Former Member — Sat, 13 Jan 2007 10:20:21 GMT

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

Re: database tables

Former Member — Sat, 13 Jan 2007 10:46:49 GMT

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

Re: database tables

Former Member — Sat, 13 Jan 2007 11:10:44 GMT

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

Re: database tables

Clemenss — Sat, 13 Jan 2007 12:41:34 GMT

Hi,

everything in DFKKOP.

Regards,

Clemens

Re: database tables

Former Member — Sun, 14 Jan 2007 10:03:39 GMT

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

Re: database tables

Manohar2u — Sun, 14 Jan 2007 10:36:40 GMT

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

Re: database tables

Former Member — Mon, 15 Jan 2007 01:56:25 GMT

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

Re: database tables

Clemenss — Mon, 15 Jan 2007 07:20:33 GMT

Hi,

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

Regards,

Clemens.