on 03-22-2011 12:19 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.