CRM Table for finding Partner Function for a Sales Order

[Former Member]

Hello everyone,

I am trying to retrieve Ship-to-Party Customer Number for a particular Transaction (Sales Order) from a SAP CRM table.

In SAP SD we have a table VBPA for the same.

I would like to retrieve the same either from a single table if available or multiple linked tables in SAP CRM.

I tried to link CRMD_ORDERADM_H & CRDM_PARTNER to retrieve the data .. But it dint work.

I am new to CRM .. so Gurus, please share ur insight.

Thanks

Vin

[Former Member · Accepted solution]

Hi,

Select GUID_SET in table CRMD_LINK where GUID_HI = CRMD_ORDERAMD_H-GUID.

Use the GUID_SET to select data in table CRMD_PARTNER.

Best regards,

Caíque Escaler

[former_member205707 · Accepted solution]

Hi,

I was following this above option, but it dint work.

Instead try using the CRMV_LINKPARTNER --> OBJECT_GUID--> CRMD_ORDERADM_H

Cheers

MMM

[Former Member]

Hi, Vin

Read this thread:

Denis.