Report Initiative - Documents

[Former Member]

Good day!

I need a report Initiative - Documents.

How can I link the tables and DPR_DOCUMENT_T INM_INITIATIVE?

Regards,

Nikita

[rabikiran_sahu · Accepted solution]

Hi Nikita ,

Please can you elaborate  more what is your requirement.

Thanks,

Rabi

[Former Member · Accepted solution]

Hi Rabi!

I need a report:

INM_INITIATIVE-EXTERNAL_ID --------- DPR_DOCUMENT_T-DOCUMENT_TEXT

AAAA ---------          DocNameForAAAA

BBBB ---------          DocNameForBBBB

How can I connect these tables?

Regards,

Nikita

[rabikiran_sahu · Accepted solution]

Hi Nikita,

Most of the PPM we have to use GUID concept to find the relationship,

hope the below may be useful to your requirement.

From the table INM_INITIATIVE fetch the DPR_GUID , Pass these to the table DPR_DOCUMENT-ENTITY_GUID-  Now , fetch the DPR_DOCUMENT-GUID , and pass the DPR_DOCUMENT-GUID to DPR_DOCUMENT_T-GUID, may be you will have your result.

select ALL DPR_GUID FROM INM_INITIATIVE TO IT_INIT.

SELECT ALL GUID AND ENTITY_GUID FROM DPR_DOCUMENT WHERE

                                                                          ENTITY_GUID = INM_INITIATIVE-ENTITY_GUID.

SELECT ALL DOCUMENT_TEXT FROM DPR_DOCUMENT_T WHERE

                                                                 GUID = DPR_DOCUMENT-GUID

Or try to work around with GUID's you will have a solution.