Manage Price | API | CDS

[Expert]

Hi SAP Folks,  I am looking a way to download data "Manage Prices - Sales" data from condition type PCP0 . I used below API but it only gives price against condition record but i dont found any linkage with project or how to link.  https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPr...  Is there any other API or CDS which i can use to extract relevant data ?  Thanks and Regard  Vivek SIngh

[Expert · Accepted solution]

Hi Singh,

You can try this by adding $filter and $expand:

API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPrcgCndnRecdValidity?$filter=ConditionType eq 'PCP0'&$expand=to_SlsPrcgConditionRecord

Tips: from the road map, excel download and upload is there in Q3 2020.

https://roadmaps.sap.com/board?q=spreadsheet&range=FIRST-LAST#Q3%202020;INNO=6EAE8B28C5D91ED9A4D507A...

BRs,

Archer

[Expert]

This is a re-posted Q&A of an earlier question on this community