sales order details

[sivakrishna_boddapati]

Hi Experts,

I am very new to CRM,my requirement is importing parameter is BPGUID ,now i want fetch all sales order details for this BPGUID.

I found CRMD_ORDER_H is header,CRMD_ORDER_I , is item table . can explain anyone what is the flow

Thanks & Regards

Siva Krishna

[robert_kunstelj · Accepted solution]

The link table between order header (CRMD_ORDERADM_H) and partner guid is CRMD_PARTNER table. But between this 2 tables there is also a link table called CRMD_LINK. So you need to link:

- BPGUID with CRMD_PARTNER-PARTNER_NO.

- CRMD_LINK-GUID_SET with CRMD_PARTNER-GUID

- CRMD_LINK-GUID_HI with CRMD_ORDERADM_H-GUID

Regards.