Project name in SAP PPM

[former_member185537]

Hello experts,

I found that the data created in the portfolios are stored in the table using the GUID, but I am not able to find any table information for the project name. Can anyone help me get to that. Help would be appreciated

[silvia_kreuzhuber · Accepted solution]

Hi,

if I correctly understood your query, then you are looking for a table storing the name of an item (project) for example. With the item (project) GUID you can check the name/text in table CGPL_TEXT.

Regards,
Silvia

[francesco_pezzoli · Accepted solution]

Hi,

Silvia has already replied to your question, but I have an additional recommendation. In case you do not already know this program, you should try using program DPR_GUID_ANALYZE, which is very useful to understand the relationship between the different PPM tables and see all tables in which a GUID is used. This is a standard program which you can execute in transaciton SE38, the selection field is the GUID of any PPM object.

Regards

Francesco

[former_member185537 · Accepted solution]

Hello Pezzoli,

Thanks for your reply as well.

I tried to get the one form the ITEM as below

I tried using the GUID in the table that Silvia has mentioned. I am not able to get the details. Which GUID should we use in here. Correct me if am wrong here.

Thanks for your reply.

[silvia_kreuzhuber · Accepted solution]

Hi,

you should use the first GUID field (below 'CLIENT') instead of the PARENT GUID.

Regards,

Silvia

[francesco_pezzoli · Accepted solution]

Hello Pras,

The item GUID (field /RPM/ITEM_D-GUID) does indeed correspond to the value in CGPL_TEXT-GUID. The problem is that certain tables do not work properly when trying to select with a GUID value in SE16 (they will react as if you had left the selection GUID empty). This is one of the reasons why program DPR_GUID_ANALYZE is useful: you can run this program for your item GUID, then click on the entry for table CGPL_TEXT in the program result, and will see the relevant entries from table CGPL_TEXT.

In case you are developing your own coding, then I can confirm that you need to select in table CGPL_TEXT with field "GUID", using the value from /RPM/ITEM_D-GUID. What you have observed is just an SE16 issue/restriction.

Regards

Francesco

[former_member185537 · Accepted solution]

Thanks for your reply Silvia. The se16n behaves different like what Francesco mentioned in this case.

[former_member185537 · Accepted solution]

Hello Francesco,

The PR id seems to be useful in this case and is getting the details from the table in the se16n.