5 Replies Latest reply: Nov 7, 2006 6:32 PM by Haseeb Junaid RSS

Condition Types in SAP CRM

Santosh Verma
Currently Being Moderated

Hi Ppl,

 

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.

 

Help appriciated.

 

Thanks & Regards,

Santosh.

  • Re: Condition Types in SAP CRM
    Vikash Krishna
    Currently Being Moderated

    Hi Santosh,

     

    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.

     

    http://help.sap.com/bp_crmv250/CRM_DE/BBLibrary/html/C03_EN_DE.htm

     

    <b>reward points if it helps!!</b>

     

    Best regards,

    Vikash.

  • Re: Condition Types in SAP CRM
    Haseeb Junaid
    Currently Being Moderated

    Hi Santosh,

     

    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>

     

    Thanks

    Haseeb

    • Re: Condition Types in SAP CRM
      Santosh Verma
      Currently Being Moderated

      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.

      (Read as

      Ctype Description   Amount Unit Per CUnit Val Doc. Curr)

      for:

      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,

      Santosh.

  • Re: Condition Types in SAP CRM
    Santosh Verma
    Currently Being Moderated

    Guys, any updates. I need this info ASAP.

     

    Thanks,

    Santosh.

    • Re: Condition Types in SAP CRM
      Haseeb Junaid
      Currently Being Moderated

      Hi Santosh,

       

      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.

       

      Regards

      Haseeb

Actions