I_ProjectBillingRequest
Project Billing Request
I_ProjectBillingRequest (Basic)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Project Billing Request · R&D Engineering
I_ProjectBillingRequest is a Basic CDS View that provides data about "Project Billing Request" in SAP S/4HANA. It reads from 1 data source (projbillgreq) and exposes 18 fields with key field ProjectBillingRequestUUID. It has 6 associations to related views.
SAP Help Documentation
| Category | CDS Views for Project Billing |
|---|---|
| Status | Project billing request approval status |
Purpose
This CDS view contains details for the project billing request. A project billing request is a document that is generated when preparing billing for one or more billing elements. It is an intermediary document based on which billing document requests are generated. A project billing request captures amounts that are: To be billed to the customer Written off Postponed to the next billing cycle A billing document request only captures amounts that get billed to a customer. It is eventually used to create a billing document that goes out to your customer. This CDS view provides the data to answer the following business questions: What is the unique number for the project billing request? What is the current status of the project billing request? What is the billing profile category of the project billing request? The billing profile category can have the following values: Value Description PSBL — Professional Services Billing If the billing profile category is PSBL, the project billing request belongs to normal billing and is/was created in the Manage Project Billing app. The project billing request status reflects its lifecycle status and can mainly have the following values: Project Billing Request Status Description C — Created The project billing request is in status Created when it is created/processed in the Manage Project Billing app. Project billing requests in this status are only seen in the Manage Project Billing app. They have a temporary ID starting with S*. In any other status, project billing requests have a permanent ID. The header identification number of the project billing request doesn’t change. P — In Process The project billing request is in workflow process. It was sent for approval, or it was approved, but the billing document request was not created for some reason. R — Billing Rejected The billing document request was rejected for the corresponding project billing request. D — Rejected The project billing request was rejected from the workflow approval process. B — Billing Requested A billing document request was created for the corresponding project billing request. I — Invoiced An invoice was posted for the corresponding project billing request. The project billing request approval status describes its workflow approval status: Project Billing Request Approval Status Description Initial approval status The project billing request is not relevant for approval, and the billing document request will be created when the project billing request is submitted in the Manage Project Billing app. P — In approval The project billing request is still in approval. A — Released The project billing request was approved. R — Rejected The project billing request was rejected. Please note the following: For temporary project billing requests (lifecycle status Created ) and their items, the data in the CDS views might change as the billing specialist can still work with them at any time. The main difference between the lifecycle status values of project billing requests is that: Project billing requests in status Created can be changed/deleted. They are only seen in the Manage Project Billing app. Project billing requests with other statuses cannot be changed. They can be viewed in the Manage Project Billing Requests app. Some figures that are available in apps are not available in CDS views because they are calculated on the fly, but not stored in the database. Project billing requests that are in approval are not reflected in the Entry Flow for Project Billing Element CDS view ( I_ProjectBillingElementEntrFlw ), though they’re displayed as billing in process in the Manage Project Billing app. Only open and billable revenues are available for project billing request items in the Items for Project Billing Request CDS view ( I_ProjectBillingRequestItem ). Written-off revenue is available in the Entry Flow for Project Billing Element CDS view ( I_ProjectBillingElementEntrFlw ) only after submission of the project b
This CDS view contains details for the project billing request. A project billing request is a document that is generated when preparing billing for one or more billing elements. It is an intermediary document based on which billing document requests are generated. A project billing request captures amounts that are: To be billed to the customer Written off Postponed to the next billing cycle A billing document request only captures amounts that get billed to a customer. It is eventually used to create a billing document that goes out to your customer. This CDS view provides the data to answer the following business questions: What is the unique number for the project billing request? What is the current status of the project billing request? What is the billing profile category of the project billing request? The billing profile category can have the following values: Value Description PSBL — Professional Services Billing If the billing profile category is PSBL, the project billing request belongs to normal billing and is/was created in the Manage Project Billing app. The project billing request status reflects its lifecycle status and can mainly have the following values: Project Billing Request Status Description C — Created The project billing request is in status Created when it is created/processed in the Manage Project Billing app. Project billing requests in this status are only seen in the Manage Project Billing app. They have a temporary ID starting with S*. In any other status, project billing requests have a permanent ID. The header identification number of the project billing request doesn’t change. P — In Process The project billing request is in workflow process. It was sent for approval, or it was approved, but the billing document request was not created for some reason. R — Billing Rejected The billing document request was rejected for the corresponding project billing request. D — Rejected The project billing request was rejected from the workflow approval process. B — Billing Requested A billing document request was created for the corresponding project billing request. I — Invoiced An invoice was posted for the corresponding project billing request. The project billing request approval status describes its workflow approval status: Project Billing Request Approval Status Description Initial approval status The project billing request is not relevant for approval, and the billing document request will be created when the project billing request is submitted in the Manage Project Billing app. P — In approval The project billing request is still in approval. A — Released The project billing request was approved. R — Rejected The project billing request was rejected. Please note the following: For temporary project billing requests (lifecycle status Created ) and their items, the data in the CDS views might change as the billing specialist can still work with them at any time. The main difference between the lifecycle status values of project billing requests is that: Project billing requests in status Created can be changed/deleted. They are only seen in the Manage Project Billing app. Project billing requests with other statuses cannot be changed. They can be viewed in the Manage Project Billing Requests app. Some figures that are available in apps are not available in CDS views because they are calculated on the fly, but not stored in the database. Project billing requests that are in approval are not reflected in the Entry Flow for Project Billing Element CDS view ( I_ProjectBillingElementEntrFlw ), though they’re displayed as billing in process in the Manage Project Billing app. Only open and billable revenues are available for project billing request items in the Items for Project Billing Request CDS view ( I_ProjectBillingRequestItem ). Written-off revenue is available in the Entry Flow for Project Billing Element CDS view ( I_ProjectBillingElementEntrFlw ) only after submission of the project b
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | R&D Engineering |
| Application Component | PPM-SCL-BIL |
| Capabilities | Data Source for Defining CDS Entities, Data Source in SQL Select, Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Data Extraction |
| Package | R&D Engineering for SAP S/4HANA Cloud Private Edition |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| projbillgreq | projbillgreq | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_ProjectBillingRequestItem | _ProjectBillingRequestItem | $projection.ProjectBillingRequestUUID = _ProjectBillingRequestItem.ProjectBillingRequestUUID |
| [0..1] | I_ProjectBillingRequestStatus | _ProjectBillingRequestStatus | $projection.ProjectBillingRequestStatus = _ProjectBillingRequestStatus.ProjectBillingRequestStatus |
| [0..1] | I_ProjBillgReqApprovalStatus | _ProjBillgReqApprovalStatus | $projection.ProjBillgReqApprovalStatus = _ProjBillgReqApprovalStatus.ProjBillgReqApprovalStatus |
| [0..1] | I_ProjectBillingCategory | _ProjectBillingCategory | $projection.ProjectBillingCategory = _ProjectBillingCategory.ProjectBillingCategory |
| [0..1] | I_SalesDocument | _SalesDocument | $projection.SalesDocument = _SalesDocument.SalesDocument |
| [1..1] | I_EnterpriseProject | _EnterpriseProject | $projection.ProjectInternalID = _EnterpriseProject.ProjectInternalID |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| EndUserText.label | Project Billing Request | view | |
| VDM.viewType | #BASIC | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| Analytics.dataExtraction.enabled | true | view | |
| Analytics.dataExtraction.delta.changeDataCapture.automatic | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.representativeKey | ProjectBillingRequestUUID | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.sapObjectNodeType.name | ProjectBillingRequest | view |
Fields (18)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectBillingRequestUUID | projectbillingrequestuuid | Project Billing Request UUID | |
| ProjectBillingRequest | projectbillingrequest | Project Billing Request | ||
| ProjectBillingRequestStatus | projectbillingrequeststatus | Project Billing Request Status | ||
| ProjBillgReqApprovalStatus | projbillgreqapprovalstatus | Project Billing Request Approval Status | ||
| ProjectBillingRequestType | projectbillingrequesttype | Project Billing Request Document Type | ||
| SalesDocument | salesdocument | Sales and Distribution Document Number | ||
| ProjectBillingCategory | projectbillingcategory | Billing Profile Category | ||
| ProjBillgReqLastChgdBy | projbillgreqlastchgdby | Project Billing Request Changed By | ||
| ProjBillgReqLastChgdAtDteTme | projbillgreqlastchgdatdtetme | Project Billing Request Changed On | ||
| ProjBillgReqCreatedBy | projbillgreqcreatedby | Project Billing Request Created By | ||
| ProjBillgReqCreatedAtDteTme | projbillgreqcreatedatdtetme | Project Billing Request Created On | ||
| ProjectInternalID | projectinternalid | Project (internal) | ||
| _ProjectBillingRequestItem | _ProjectBillingRequestItem | |||
| _ProjectBillingRequestStatus | _ProjectBillingRequestStatus | |||
| _ProjBillgReqApprovalStatus | _ProjBillgReqApprovalStatus | |||
| _ProjectBillingCategory | _ProjectBillingCategory | |||
| _SalesDocument | _SalesDocument | |||
| _EnterpriseProject | _EnterpriseProject |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_ProjectBillingRequest.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW I_ProjectBillingRequest AS
SELECT
ProjectBillingRequestUUID,
ProjectBillingRequest,
ProjectBillingRequestStatus,
ProjBillgReqApprovalStatus,
ProjectBillingRequestType,
SalesDocument,
ProjectBillingCategory,
ProjBillgReqLastChgdBy,
ProjBillgReqLastChgdAtDteTme,
ProjBillgReqCreatedBy,
ProjBillgReqCreatedAtDteTme,
ProjectInternalID
FROM projbillgreq
LEFT OUTER JOIN I_ProjectBillingRequestItem AS _ProjectBillingRequestItem ON ProjectBillingRequestUUID = _ProjectBillingRequestItem.ProjectBillingRequestUUID -- association [0..*]
LEFT OUTER JOIN I_ProjectBillingRequestStatus AS _ProjectBillingRequestStatus ON ProjectBillingRequestStatus = _ProjectBillingRequestStatus.ProjectBillingRequestStatus -- association [0..1]
LEFT OUTER JOIN I_ProjBillgReqApprovalStatus AS _ProjBillgReqApprovalStatus ON ProjBillgReqApprovalStatus = _ProjBillgReqApprovalStatus.ProjBillgReqApprovalStatus -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingCategory AS _ProjectBillingCategory ON ProjectBillingCategory = _ProjectBillingCategory.ProjectBillingCategory -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProject AS _EnterpriseProject ON ProjectInternalID = _EnterpriseProject.ProjectInternalID -- association [1..1]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA