Question about report for Sales in SAP S/4HANA Public Cloud Edition - Out of the box reports or CDS

[Brinda911]

Hi All,

There is a requirement from customer for Sales LOB reports that they wanted to have a report that shows the product cost price which is maintained on the material master level and also the sales price of a material. I tried to look up out of the box reports given by SAP S/4HANA Public Cloud for Sales, couldn't actually find one and also tried to look for the standard CDS Views but couldn't find one specific to what client ASK is.

Experts out there please provide some guidance on the above.

SAP S/4HANA Public Cloud SD (Sales and Distribution) SAP S/4HANA SAP S/4HANA Cloud for Sales 

Thanks!

[AngelaDai · Accepted solution]

hi,

It is recommended to create custom reports based on cds views.

Kindly check if cds views below could fulfill your requirements:

I_SalesDocItemPricingElement (https://api.sap.com/cdsviews/I_SALESDOCITEMPRICINGELEMENT)

I_InventoryPriceByKeyDate(https://api.sap.com/cdsviews/I_INVENTORYPRICEBYKEYDATE)

Also cds views for Sales for your reference:

https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/87fae757dc3bf032e1000000...

Best regards,

Angela

[Andrew]

This might also be a useful reference for you:

https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/protect-and-control-sales-ord...

More about custom logic but as a part of it, they demonstrate identifying and utilizing the profit margin which will use the components you're looking for.