on 12-11-2013 2:26 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
C
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.