cancel
Showing results for 
Search instead for 
Did you mean: 

ODATA API - Condition Record for Pricing in Sales

Anna_Rafter
Participant
0 Kudos

Hello,

We have activated the following communication scenario "SAP_COM_0294" (Pricing Data Integration) in a new communication arrangement.

Our intention is to use ODATA as a source in Excel to access to the following data regarding Condition Records in Sales Pricing: 

  • Condition Type
  • Sales Organization
  • Distributon Channel
  • Customer
  • Material
  • Price
  • However, the service URL's facilitate by SAP for this communication arrangement to access this information do not include the "customer" field. 

    The only way to access the información regarding material prices is to filter data by condition record.

    Does anyone know if it is possible to generate a document in which we can filter material prices by customer instead of filtering material prices by condition record?

    Thank you in advance,

    Regards,

    Anna

    Accepted Solutions (1)

    Accepted Solutions (1)

    pascalrenet
    Product and Topic Expert
    Product and Topic Expert
    0 Kudos

    hello Anna.

    Have you tried using the Odata $filter property and passing the information (eg: the sold to party) in the calling URL?

    Anna_Rafter
    Participant
    0 Kudos

    Hello Pascal,

    Thank you for your quick reply.

    We have tried to use the OData $filter property. However, we are getting this error:

    "System query options '$expand,$filter,$orderby,$skip,$top,$skiptoken,$inlinecount,$select' are not allowed in the requested URI"

    Furthermore, I am afraid that the field "Sold-To-Party" is not included in the CDS used by SAP for this communication arrangement, so the $filter property will not be able to help us in this case...

    pascalrenet
    Product and Topic Expert
    Product and Topic Expert
    0 Kudos

    Hello

    What is the URI that you polling?

    try something like this --> hit at the record validity entity not the condition record -->A_SlsPrcgCndnRecdValidity and as below state --> $filter=Customer eq '15100001'

    https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPr... eq '15100001'&%24expand=to_SlsPrcgConditionRecord

    Use 'Customer' as the filter.

    Anna_Rafter
    Participant
    0 Kudos

    Hello Pascal,

    Thank you for the information provided, we were not indicating the filtering criteria as mentioned.

    It seems to be working fine.

    Thanks again for your help.

    Kind Regards,

    Anna

    Answers (0)