/RPM/DECISION

[former_member233411]

Hi,

How do I determine the status of a decision point in /RPM/DECISION and /RPM/ITEM_D.

I am not a PPM consultant but was tasked to help with an error on BI. The relevant status should appear on BI for a specific decision point.

I am trying to understand the GUID relationships between the two tables.

Annelize

[priyatham_kasu2 · Accepted solution]

Hi Annelize,

You can get the current status of the decision point from table /RPM/DECISION using the field STATUS.

Field ITEM_GUID in table /RPM/DECISION is the field GUID in /RPM/ITEM_D table.

Field ACTIVE = 'X' in /RPM/DECISION implies that it is the current active decision point for that item.

Hope this helps.

Regards,

Priyatham

[former_member233411 · Accepted solution]

Hi, Priyatham,

Spot on !! Thanks you !!

Annelize

[former_member233411]

Morning,

I looked at table CRM_JEST in PPM, dev, qa and prd ... This table is empty?

Annelize

[sammar81]

Hi Annelize,

You can get the item status from CRM_JEST table by passing the GUID from the table RPM/ITEM_D.

Hope it helps.

Regards

Sammar

[former_member233411]

Hi Sammar,

Table CRM_JEST is a table used for CRM on ERP? The GUID is for a PPM item created on the portal.

Annelize

[priyatham_kasu2]

Hi Annelize,

PPM also uses CRM_JEST for keeping track of the status changes to its objects.

Regards,

Priyatham

[sammar81]

It stores the status data for PPM obejcts as well