Need CDS view for customer Project Actual cost and Billed & Unbilled information in SAP Public cloud

[vigneshvalluvan1989]

Hi,

I'm creating a CDS view for the customer project overview.

I need CDS view information to link the fields mentioned below. Some of these fields are available in the CUBE-related CDS view, but I couldn't use them in the "Custom CDS View" app.

Field Name
1. Actual Effort (Hours)
2. Actual Cost
3. Billed
4. Unbilled
5. Billing Method

Thanks & Regards,
Vignesh T

[vigneshvalluvan1989]

Hi Chuma, Thanks for your feedbacks and suggestions I missed to say that , I'm using "Project ID" as a prime field suggested CDS views dnt have the "Project ID" field, Is there any other ways to get the information with "project ID" field??

[Chuma]

Dear @vigneshvalluvan1989 

Thank you for your message.

To support your CDS view development for the customer project overview in SAP S/4HANA Cloud, please find below the recommended standard CDS views that include the fields you mentioned:

Field Name	Standard CDS View
Actual Effort (Hours)	I_TimeSheetRecord
Actual Cost	I_ActualCostLineItem
Billed	I_BillingDocumentItem
Unbilled	I_ProjectBillingElement
Billing Method	I_CustomerProject

Please note:

• Some CDS views may have restricted access in the Custom CDS Views app.
• In such cases, you can use the Custom Analytical Queries app for reporting purposes.
• If the fields remain unavailable, I recommend raising a support incident or requesting access via SAP Extensibility options.

 Here are two useful references for your configuration:

SAP Help Portal – Custom CDS Views

SAP Learning – CDS Views in S/4HANA Cloud

Should you need further assistance, feel free to reach out.

Best regards,

Chuma

[vigneshvalluvan1989]

Hi Chuma,

Thank you for your feedback and suggestions.

I forgot to mention that I'm using "Project ID" as the primary field.

The suggested CDS views don't have the "Project ID" field. Is there any other way to retrieve the information using the "Project ID" field?

Thanks & Regards,
Vignesh T