Question on Documents tab of CRMD_ORDER

[Former Member]

Hi Experts,

I want to find the DB table where the details for the "attached" document, under the Documents tab from CRMD_ORDER are maintained.

For a particular Transaction Number for an Assignment Agreement, how do i fetch the attached document details?

Please suggest a FM also if there is one.

Regards,

Somil

[Former Member · Accepted solution]

Hi Somil,

The datailed information of attached document is stored on CRMORDERPHF (file name, file size, mime type).

You should chase the link from order to this table as follow.

1.Get GUID from CRM_ORDERADM_H (or CRM_ORDERADM_I).

2.Get INSTID_B from SKWG_BREL with above GUID as INSTID_A.

3.Get PHIO_ID from CRMORDERPHIO with above INSTID_B (without the information before '/') as LOIO_ID.

4.Get the document information from CRMORDERPHF with above PHIO_ID as PHIO_ID.

You can easily get the above information via FM:CRM_KW_DOC_GET_DOCUMENT,

There is three fields on IO and enter the value from the field above INSTID_B.

ex) INSID_B : L/CRM_L_ORD/FFB5050AC6F8E130E1000000D0G2FF3E

IO-OBJTYPE: L

IO-CLASS: CRM_L_ORD

IO-OBJID: FFB5050AC6F8E130E1000000D0G2FF3E

Regards,

Masayuki