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]

Hello @vigneshvalluvan1989 

Thank you for your feedback and follow-up. My apologies for the delay.

Use the Enterprise Projects artifacts that carry your Project ID (ProjectExternalID) and then join on the internal key:

• Resolve your Project ID → internal key with I_EnterpriseProject fields include ProjectExternalID, ProjectUUID / Project.
• Join that key to the data you need, such as work packages, costs, and activities via the corresponding link. CDS/API I_EnterpriseProjectElement for work packages, or module-specific released CDS). If you’re calling APIs, first hit API_ENTERPRISE_PROJECT_SRV to get the internal key by ProjectExternalID, then use it with downstream APIs.

Check: SAP KBA 3587487 (use I_EnterpriseProject / I_EnterpriseProjectElement in Public Cloud), and API Hub API_ENTERPRISE_PROJECT_SRV (query projects by external ID, retrieve UUID/key). SAP Support Portal-3587487 - Requiring CDS View for Project and WBS element for Cloud Development

With kind regards

Chuma

[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