Looking for CRM document link table

[former_member566830]

Hi All.

Is there a table within CRM which contains all documents linked to other documents? For example, sales order linked to an opportunity. For those of you familiar with ECC, I'm looking for the CRM equivalent of the VBFA table.

Thanks in advance.

[Former Member · Accepted solution]

The two table that is directly related to document flow is SRRELROLES and CRMD_BINREL. However, the selection is not as straight forward. It involves back and forth selection of the tables.

First, Lets say you start with a transaction key (usually a GUID), select from the SRRELROLES with OBJKEYS equal to the GUID. Get the list of ROLEIDs.

Second, Use the ROLEIDs, select the from the CRMD_BINREL with ROLE_A equal to the ROLEIDs. Get all the ROLE_Bs. Use the ROLE_Bs to do the selection again in SRRELROLES with ROLEID equal to the CRMD_BINREL-ROLE_B and you will get a list of the OBJKEYs.

And from the new set of OBJKEYs, repeat the cycle.

The best way is to use some of the function modules to read it, both CRM_ORDER_READ and CRM_DOC_FLOW_READ_DB can do the job.

[rene_markytan]

Hi,

you can use the report crm_order_read (se38) , and check the structure ET_DOC_FLOW to get the reference GUIDs. This might also be helpful.

Regards

Rene

Edited by: Rene Markytan on Jun 3, 2011 12:32 PM