Possible Revenue In Planning Stage

[elif100212]

The planned revenue information stored in the project header becomes active from the moment the project is created.

However, the CDS that holds this information is only associated with invoicing. I can pull this information individually from fields such as 'resources,' 'additional resources,' and 'expense.' The system is performing a calculation here, but we are unable to see this calculation.

However, there isn't a single CDS that consolidates these details, which is essential for me. My goal here is to design a report related to the planned revenue within the project.

I need a CDS that captures this information during the planning stage of the project. Does anyone have any thoughts or suggestions regarding this matter?

[brucehubs]

There is a related Influence opportunity on providing more robust data for list views. A CDS view would need to be created to show the same. You may want to vote and comment here Improvement Request Details - Customer Influence (sap.com)

[OwenLiu]

Removed irrelevant tag.

[Hardeep_Tulsi · Accepted solution]

Hello ELİF Toklucu. Engagement Project Margin Analysis Query C_EngmtProjMargAnlysQuery provides details on total planned revenue of the project, This is based on the "Sales Margin in Engagement Project "I_EngmntProjSalesMarginCube" view. Engagement Project Margin Analysis View will provide information on Planned and actual cost ,Planned and actual revenue and Margin (in amount and percentage)

You can learn more with documentaion https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/1473afc105a34881827a1a0c...

SAP Provide specific CDS Views and Cube design to provide details on the specific area . However you can design Custom CDS View to meet your requirements.

(https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/e30de6eae4d24d70b65996ac8ff88848.html?q=Custom%20CDS%20View&version=2308.500) to meet your reporting requirements with Planned Revenue and other measures & attributes from additional CDS Views ex. I_EngagementProject .

In addition you can review plan and actual values for KPIs with I_ActualPlanLineItemSemTag to view details for journal entries, such as G/L accounts, company code, cost center, or profit center.

I_ProjDmndExpenseDistribution retrieves data of a demand for expense that is related to the distribution of the planned cost or revenue over time.

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/745fb83656644cb081e73039...

Resource Request Distribution for Resource Demand I_ProjDmndRsceReqDistribution can be useful to have resource request data related to the distribution of the required resource quantity over time

You can learn more about the logic using ABAP environment ex. Eclipse based IDE (ABAP Development Tools) https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/533228e1e854433ab16d013f...

Developer extensibility will help you customize per your requirements and understanding the logic behind the CDS views. https://help.sap.com/docs/SAP_S4HANA_CLOUD/6aa39f1ac05441e5a23f484f31e477e7/54dd7126d5b74efeb7a21f6b...

Hope this helps with your query.

Thanks

[elif100212 · Accepted solution]

Hello,

Thank you for the detailed information. I researched this in CDS within Eclipse and conducted a thorough investigation. However, I observed that it only allows the use of analytical queries for creating reports and unfortunately doesn't support much beyond that. My intention was to add an additional field here and perform some calculations. It seems I can't find a way to do that within CDS or in any other supported CDS. Do you have any other solution recommendations?

Thank you for your response and time