on 05-13-2019 5:37 AM
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:
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
hello Anna.
Have you tried using the Odata $filter property and passing the information (eg: the sold to party) in the calling URL?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
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.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.