CDS View or API of purchasing price condition data (Table A160/A161 in ECC)

[Roy18]

Hello experts,

I am currently trying to find a CDS view for the purchasing condition table A160 and A161 to create a report to show the data of these 2 tables in S4 hana public cloud system. The data is created by <MEK1: Create condition records: Purchasing for configurable materials>, the data structure in table A160/A161 is similar to the purchasing info record data in table A017/A018. But I just couldn't find any AXXX table of price condition in S4 hana public cloud.

And we also tried to use Odata API <Technical name: API_PURGPRCGCONDITIONRECORD_SRV>, but we did not see how to get condition record data based on <Supplier/ plant/ purchase organization/ purchasing info record category/ material/ variant condition>.

here is the API reference link: Condition Record for Pricing in Purchasing | SAP Help Portal

Could you guys help if you know of any CDS view or API that i can use to achieve this requirement. 

Thanks in advance.

[Jesus_av]

Hi Roy18. We have same issue in our project. Are you able to find a solution?

Thanks in advance!

[abhijitbolakhe]

Hello

Check this CDS view for purchasing price condition Record.

https://api.sap.com/cdsviews/I_PURGPRCGCONDITIONRECORD

[Roy18]

Hello Expert,

Thanks for your suggestion，I checked this CDS view before，I think this one is only for table KONH & KONP,  which is the detailed information of condition record, but no material, supplier, purchase organization, plant information. For example, for in ECC we have table A160, we can get the Condition record number based on <material, supplier, purchase organization, plant, variant> from table A160, then we can get the detailed information of condition record based on Condition record number from table KONH/KONP.

Best regards,
Roy.