Retrieve all sales prices for a customer using Sales Price - Retrieve (A2X)

[crwtcg002]

I would like to extract all sales prices that are associated with a specific customer.  I have used API - Sales Price - Retrieve (A2X) but this only allows the identification of price for one product at a time.

Does anyone know of a way to extract all sales pricing for a single sold-to party?

[Jerry_Lowery · Accepted solution]

Hi crwtcg002

I tried the API and indeed the product field is required.

One idea would be to try and make a master list of all the items the customer has ordered (maybe from sales orders) and then call recursively, or looks like the POST method is a batch so might be able to call a lot of them in one call.

You probably noticed you get a lot of pricing procedures for even one product/customer combination.

So another option would be to look at the Pricing Condition APIs to see if one of those helps (SAP_COM_294).

Another idea would be to create a Custom CDS View with the fields you want and expose that as an OData API.

Let me know if that helps or you find a solution

thank you

Jerry

[crwtcg002 · Accepted solution]

Thanks for the info Jerry