Report incl. planned revenue, planned cost, actual cost and billed revenue

[epeet]

Dear Community,

I am looking for a report that combines planned revenue, planned cost, actual cost, and billed revenue. I would like to have the roles (incl. resources) and expenses on the rows. If possible per year. Is this possible with standard CDS views? Like the below report, but then extended with the previously mentioned elements.

Thank you for your help.

Regards,

Esmee

[Monisha_Sivaram · Accepted solution]

Hi Esmee,

You can create custom CDS view in which you can add fields from multiple data sources based on cardinality as mention by sunil.yadavnagarro

Please refer to the below link for SAP help documentation for more details,

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/e30de6eae4d24d70b65996ac...

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/b0000072fe994d7b9d5e015a...

For the fields planned revenue, planned cost, actual cost, billed revenue ,roles (incl. resources) and expenses.

You can use the below CDS views

C_EngmtProjMargAnlysQuery

I_EngagementProjectResource

I_RSHProjectAssignmentHrs

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/95ec2158bbf01f60e1000000...

Thanks,

Monisha

[IMSYadav]

Hello esmee

this report will be prepared by multiple CDS views by taking cardinality in consideration. if you choose wrong cardinality while joining then report will show wrong quantity or amount.

you can try to create one by one line first create cost and revenue CDS and then join another in custom CDS.

thanks

SYADAV

[former_member132363]

Here are some SAP resources you may review based on your topic "expenses | cost | actual cost | standard cds views | community"

Analyzing Sales Commissions using KPI Design in S/4HANA Cloud

Nov 21, 2018 ... There is no lone CDS view in standard solution that can provide the details of sales commission with its corresponding sale employee entered?...

https://blogs.sap.com/?p=544

Best Practices for SAP S/4HANA Cloud

Reduce cost of operations by using standardized processes; Manage multiple ... Actual Costing - This scope item enables actual costing for material inventory ... Period-End Closing - Plant - This process ensures that all costs incurred ... This scope item provides procurement-related CDS views to leverage extensibility and?...

https://support.sap.com/en/product/best-practices-s4hana-cloud.html