Question Re: Link between Review and Item / Initiative in Product Lifecycle Management Q&A

Link between Review and Item / Initiative

Former Member — Wed, 11 Dec 2013 14:26:30 GMT

Hi,

Need your help:

At table level can anyone provide the link between Review and Item. we need to develop a report to display all the Items or initiatives for a review.

Even if we get a FM it would be good.

Please let me know if any additional information needed.

Re: Link between Review and Item / Initiative

Former Member — Thu, 12 Dec 2013 04:54:32 GMT

Hello Ian

Not a complete answer, but try the following:

1. Get the GUID of the Review in table /RPM/REVIEW_D

2. Run se38 --> DPR_GUID_ANALYZE and find the relation between this GUID and any associated objects. You will see that in this case there is no direct relationship betwen Review and Initiative/Item - you will have to work via the relation_d table

Have a go and let me know if you need additional help

Regards

Re: Link between Review and Item / Initiative

Former Member — Thu, 12 Dec 2013 07:28:42 GMT

Hi Ian

Following on from my previous response...

This is the table link but am sure you can get this via FM as well, here goes:

GUID of REVIEW links to GUID1 of /RPM/RELATION_D

Note relation types RRN (Initiative) and RRI (Item). Get the GUID 2 value for each of the relation types

The GUID 2 value for RRI (Item) links to the PORTFL_ITEM_GUID in table /rpm/item/d. Filter where VERSION_ITEM = '' to get the current Item or 'X'to get the versions, or leave blank to get everything

The GUID 2 value for RRN (Initiative) links to INITIATIVE_GUID in table /rpm/item_d AND to GUID of table INM_INITIATIVE

There will be an easier way I am sure to get this via FM but just wanted to provide you with the table relationship as per your request

Regards

Chatsworth

Re: Link between Review and Item / Initiative

Former Member — Thu, 12 Dec 2013 11:53:37 GMT

Hi,

Thanks lot for the below info, can you share any FM details if you have for the same link.

Re: Link between Review and Item / Initiative

Former Member — Thu, 12 Dec 2013 12:30:19 GMT

thanks Chatsworth - the logic worked