Table for PPM

[former_member613562]

Hi,

I need to find out the table where these field data is stored

1) Item Name (PROJ_DESCRIPTION) in Portfolio Item

2) Portfolio Name in Proftolio

3) Bucket Name in Bucket

4) Decision Point Name in Decision Point

I have checked /RPM/Item_D, /RPM/Bucket_D, /RPM/DECISION and /RPM/PORTFOLIO_D but couldnt find the field values

Thanks and Regards

Simon

[former_member301510]

Hi Simon,

Presently, I do not have system access but I noted down previously in my project.

Use below logic to find Bucket description. It was initiative in my case.

Enter initiative number/id in "INM_INITIATIVE - External ID" to get ITEM_GUID.
Enter ITEM_GUID in table (/RPM/ITEM_D - GUID) to get PARENT_GUID.
Now, when we execute CGPL_TEXT (output without conversion) without any inputs; find/search the PARENT_GUID in output screen.
e.g.
Initiative - 200000000000000000642019
ITEM_GUID - 0050569B3EF71EE9B39759A250D7F819
PARENT_GUID - 0050569B3EF71EE9AB86660B1A4BACF1
TEXT1 - Delivery

Similarly, try for Portfolio, Item and Decision point description.

In worst case, use program "DPR_GUID_ANALYZE" or "DPR_GET_TREE" in SE38 to get all relevant tables in reference to a GUID.

Regards,

Sandeep

[nikolay_lumpov]

Hi.

Look at the table CGPL_TEXT.

You can also examine tables using the program DPR_GUID_ANALIZE (Tcode SA38).

If you enter a guid, you will get all tables where it is used.

With respect, Nikolay.