cancel
Showing results for 
Search instead for 
Did you mean: 

sales order details

sivakrishna_boddapati
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

robert_kunstelj
Active Contributor
0 Kudos

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.

Answers (1)

Answers (1)

sivakrishna_boddapati
Participant
0 Kudos

thank you for reply

now i am getting order number and also i am getting ITEM details from table CRMD_ORDERADM_I,

now I want to know values of net value , order status ,discount ,shipping charges ,payment method for that order(transaction number) .

if is there any FM to find all these details ,Please suggest those FM

Thanks In advance

Siva

robert_kunstelj
Active Contributor
0 Kudos

You can get all with CRM_ORDER_READ function. there are also separate functions like.

CRM_STATUS_READ_OW

CRM_SALES_READ_OW

CRM_SHIPPING_READ_OW

...

Regards.