I_PROJECTBILLINGELEMENT
Project Billing Element
I_PROJECTBILLINGELEMENT is a CDS View in S/4HANA. Project Billing Element. It contains 20 fields. 23 CDS views read from this table.
CDS Views using this table (23)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_EnPrjPfSrvsBillingPlanItem | view_entity | inner | CONSUMPTION | Provides billing plan details |
| C_ProjBillgReqWrkPckgWrkItmVH | view_entity | inner | CONSUMPTION | Work Item Work Package |
| I_EntProjBillgElmntDet | view_entity | from | COMPOSITE | Billing Elements Details for Enterprise Projects |
| I_EntProjProfnlSrvcBillgElmnt | view_entity | inner | COMPOSITE | Billing Elements of Projects |
| I_IntcoProjectBillingElement | view_entity | inner | BASIC | Intercompany Project Billing Element |
| I_ProjectBillingElementTP | view_entity | from | TRANSACTIONAL | Details of Billing Element |
| I_ProjectBillingElmntDueDate | view_entity | from | COMPOSITE | Billing Due Date of Billing Element |
| P_EngmntProjBillgDetails | view_entity | from | COMPOSITE | Unbilled Revenue |
| P_EvtBsdRevnRecgnProjWipJrnAmt | view_entity | from | COMPOSITE | WIP (2) - JournEntr Amounts T&M + PBE |
| P_PrjBlgElmBllbleRevnAmt | view_entity | from | COMPOSITE | Billable Revenue Amt for Billing Elmnt |
| P_PrjBlgElmRevnAmount | view_entity | from | CONSUMPTION | Calculated Amounts for Billing Element |
| P_PRJBLGELMSALESDOCITM | view_entity | from | TRANSACTIONAL | P view for Project Billing Element Sales Document |
| P_ProjBillgElmntBillgPlanItem | view_entity | from | COMPOSITE | Project Billing Open Billing Plan Items |
| P_ProjBillgElmntForPrjBlgReq | view_entity | inner | CONSUMPTION | Additional information in PBR |
| P_ProjBillgElmntSalesDets2 | view_entity | from | COMPOSITE | Project Billing Elements |
| P_ProjBillgElmntTEBillgDate | view_entity | from | COMPOSITE | Project Billing Date for T&E element |
| P_ProjBillingElementEntrFlw00 | view | inner | COMPOSITE | P-View Proj Billing Element Flow |
| P_ProjBillingElmntAllBillDate | view_entity | from | COMPOSITE | Project Billing Element Date = 99991231 |
| P_ProjBillingElmntAllBillDate2 | view_entity | from | COMPOSITE | Proj. Billg Element Date = 99991231 (2) |
| P_ProjBillingElmntBillngDate | view_entity | from | COMPOSITE | Billing due date replacing P_ProjBillingElmntBillgDate |
| P_ProjBillingElmntMaxBillDate3 | view_entity | from | COMPOSITE | Project Billing Element (max, past)) Due Billing Date |
| P_ProjBillngPlanDates | view_entity | inner | COMPOSITE | All open billing due dates |
| R_ProjectBillingElementTP | view_entity | from | TRANSACTIONAL | Details of Billing Element |
Fields (20)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingWBSElementInternalID | BillingWBSElementInternalID,WBSElementInternalID | 9 |
| KEY | ProjectBillingElementUUID | ProjectBillingElementUUID | 16 |
| _EnterpriseProjectElement | _EnterpriseProjectElement | 1 | |
| _ProjBillgElmObjectLink | _ProjBillgElmObjectLink | 2 | |
| _ProjectBillingElementEntry | _ProjectBillingElementEntry | 1 | |
| _WBSElement | _WBSElement | 3 | |
| BilledRevenueAmtInDocCrcy | BilledRevenueAmtInDocCrcy | 4 | |
| BillingPlan | BillingPlan,ProjBillgSlsOrdBillingPlan | 2 | |
| DocumentCurrency | DocumentCurrency | 6 | |
| ProjBillgElmntCreatedAtDteTme | ProjBillgElmntCreatedAtDteTme | 2 | |
| ProjBillgElmntCreatedByUser | ProjBillgElmntCreatedByUser | 2 | |
| ProjBillgElmntLastChgdAtDteTme | ProjBillgElmntLastChgdAtDteTme | 2 | |
| ProjBillgElmntLastChgdByUser | ProjBillgElmntLastChgdByUser | 2 | |
| ProjBillingProfile | ProjBillingProfile | 2 | |
| ProjectBillingCategory | ProjectBillingCategory | 3 | |
| ProjectElementUUID | ProjectElementUUID | 2 | |
| ProjectUUID | ProjectUUID | 2 | |
| SalesDocument | SalesDocument,SalesOrder | 4 | |
| SalesDocumentItem | SalesDocumentItem,SalesOrderItem | 4 | |
| WrittenOffRevenueAmtInDocCrcy | WrittenOffRevenueAmtInDocCrcy | 3 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Project Billing Element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTBILLINGELEMENT (
BILLINGWBSELEMENTINTERNALID,
PROJECTBILLINGELEMENTUUID,
_ENTERPRISEPROJECTELEMENT,
_PROJBILLGELMOBJECTLINK,
_PROJECTBILLINGELEMENTENTRY,
_WBSELEMENT,
BILLEDREVENUEAMTINDOCCRCY,
BILLINGPLAN,
DOCUMENTCURRENCY,
PROJBILLGELMNTCREATEDATDTETME,
PROJBILLGELMNTCREATEDBYUSER,
PROJBILLGELMNTLASTCHGDATDTETME,
PROJBILLGELMNTLASTCHGDBYUSER,
PROJBILLINGPROFILE,
PROJECTBILLINGCATEGORY,
PROJECTELEMENTUUID,
PROJECTUUID,
SALESDOCUMENT,
SALESDOCUMENTITEM,
WRITTENOFFREVENUEAMTINDOCCRCY,
PRIMARY KEY (BILLINGWBSELEMENTINTERNALID, PROJECTBILLINGELEMENTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA