01-28-2008 3:35 PM
Hello,
I am trying to find the table that stores the cost center plan information that is entered in transaction KP06. The help says that it is in RKPLN but SAP says that the the table does not exist.
Thanks for helping.
Eric
01-28-2008 4:40 PM
Hi Eric,
The table name you mentioned is a structure and definitely there is no table with that name exist.
As i do not have the real time data and fields mentioned which you are looking for its difficult for me to tell you the exact table name.
Still you can find out yourself by following the below steps, if you have test data with you -
1) Go to transaction ST05 (SQL Trace).
2) Click on the button Activate Trace.
3) Open transaction KP06 in another Session/window.
4) Enter the Test data.
5) Once you see all the required data populated on the screen, go to the other screen ST05 opened.
6) Click on deactivate trace.
7) Then Click on Display trace.
😎 It will give you another Pop-Up, just click Ok.
9) It will display all the table and details of select query performed on the various table to populate the transaction.
10) You can check for the various tables which fetched data and get the table you are looking for.
If you are only looking for fetching the cost then its stored in COSS and COSP.
Hope this helps and works too!
Edited by: Priyabrata Samanta on Jan 28, 2008 10:20 PM
01-28-2008 4:40 PM
Hi Eric,
The table name you mentioned is a structure and definitely there is no table with that name exist.
As i do not have the real time data and fields mentioned which you are looking for its difficult for me to tell you the exact table name.
Still you can find out yourself by following the below steps, if you have test data with you -
1) Go to transaction ST05 (SQL Trace).
2) Click on the button Activate Trace.
3) Open transaction KP06 in another Session/window.
4) Enter the Test data.
5) Once you see all the required data populated on the screen, go to the other screen ST05 opened.
6) Click on deactivate trace.
7) Then Click on Display trace.
😎 It will give you another Pop-Up, just click Ok.
9) It will display all the table and details of select query performed on the various table to populate the transaction.
10) You can check for the various tables which fetched data and get the table you are looking for.
If you are only looking for fetching the cost then its stored in COSS and COSP.
Hope this helps and works too!
Edited by: Priyabrata Samanta on Jan 28, 2008 10:20 PM
01-28-2008 4:47 PM