My requirement: Currently i need to fetch condition records data at item level for a sales order (transaction: CRMD_ORDER).
Do anyone knows on how to get Conditions Record data in SAP CRM(in R3, this data is stored in A016 and KONP tables). More specifically, which table or function module is used to retrive data.
Thanks & Regards,
You can download the conditions from R/3 usning the Adaptor object DNL_COND_<AXXX>, In your case it should be DNL_COND_A016. Reffer to the best practice guide C03 for more details.
<b>reward points if it helps!!</b>
The condition records for an order in CRM are stored in table 'PRCD_COND'.
The way you can go to PRCD_COND records for an order is as follows
1. Get the order guid from CRMD_ORDERADM_H
2. Get all item guids from CRMD_ORDERADM_I giving Order GUID
3. Take the order guid and map it to GUID_HI field in CRMD_LINK table and filter by OBJTYPE_HI = 05 and OBJTYPE_SET = 18. Get the value of field GUID_SET
4. Look up PRCD_COND table as KMUNV = GUID_SET from pervious step. This returns conditions records by item. If you need conditions for an item, then lookup the table using where KPOSN = Item GUID.
<b>Please reward points if it helps.</b>
Hi Haseeb & Vikash,
Thanks for the info. But this doesn't ended up my problem.
Here is an detail info:
for a sales order (trans crmd_order) and for a particular item, i've found , say the following condition types in conditions tab.
Ctype Description Amount Unit Per CUnit Val Doc. Curr)
ZVEN Vendor Price Listing 27.95 USD 1 EA 55.90 USD
Gross Value1 27.95 USD 1 EA 55.90 USD
ZFRT Shipping & Handling 9.00 USD 0 9 USD
Discount & Surcharge 9.50 USD 1 EA 19.00 USD
Sum shipping & Fuel 4.50 USD 1 EA 9.00 USD
NetValue 1 37.45 USD 1 EA 74.90 USD
NetValue 2 37.45 USD 1 EA 74.90 USD
Suppose i need to fetch details for a condition type ZFRT and for fields 'Sum shipping & Fuel' (amnt:4.50) and for NetValue 1(amount 37.45) to populate some arithmetic calculation. The table PRCD_COND has details for condition types for the item number. I would like to know where can i get these details. Are they stored in any table, or any FM to get these details or they are populated dynamically based on some arithmatic logic.
Requesting to please provide an early update if any.
Thanks & Regards,
I am not clear what you mean by 'details for a condition type'. What kind of details do you need?
There are other pricing tables <b>CNCCRMPRCUS<condition number></b>. So for example if your ZFRT condition type is in a condition table 516, CRM online stores the price details in <b>CNCCRMPRCUS516</b>.
Hope this helps.