I_PROJECTBILLINGELEMENT
Project Billing Element
I_PROJECTBILLINGELEMENT is a CDS View in S/4HANA. Project Billing Element. It contains 13 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProjBillgReqWrkPckgWrkItmVH | view_entity | inner | CONSUMPTION | Work Item Work Package |
| I_EntProjProfnlSrvcBillgElmnt | view_entity | inner | COMPOSITE | Billing Elements of Projects |
| I_ProjectBillingElementTP | view_entity | from | TRANSACTIONAL | Details of Billing Element |
| I_ProjectBillingElmntDueDate | view_entity | from | COMPOSITE | Billing Due Date of Billing Element |
| P_EvtBsdRevnRecgnProjWipJrnAmt | view | from | COMPOSITE | |
| P_PrjBlgElmBllbleRevnAmt | view_entity | from | COMPOSITE | Billable Revenue Amt for Billing Elmnt |
| P_PrjBlgElmRevnAmount | view_entity | from | CONSUMPTION | Calculated Amounts for Billing Element |
| P_ProjBillgElmntForPrjBlgReq | view_entity | inner | CONSUMPTION | Additional information in PBR |
| P_ProjBillgElmntSalesDets2 | view_entity | from | COMPOSITE | Project Billing Elements |
| P_ProjBillingElementEntrFlw00 | view | inner | COMPOSITE | |
| 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 | |
| R_ProjectBillingElementTP | view_entity | from | TRANSACTIONAL | Details of Billing Element |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjectBillingElementUUID | ProjectBillingElementUUID | 11 |
| _ProjectBillingElementEntry | _ProjectBillingElementEntry | 1 | |
| _WBSElement | _WBSElement | 2 | |
| BilledRevenueAmtInDocCrcy | BilledRevenueAmtInDocCrcy | 3 | |
| BillingWBSElementInternalID | BillingWBSElementInternalID,WBSElementInternalID | 5 | |
| DocumentCurrency | DocumentCurrency | 5 | |
| ProjBillgElmntCreatedAtDteTme | ProjBillgElmntCreatedAtDteTme | 2 | |
| ProjBillgElmntCreatedByUser | ProjBillgElmntCreatedByUser | 2 | |
| ProjBillgElmntLastChgdAtDteTme | ProjBillgElmntLastChgdAtDteTme | 2 | |
| ProjBillgElmntLastChgdByUser | ProjBillgElmntLastChgdByUser | 2 | |
| ProjBillingProfile | ProjBillingProfile | 1 | |
| ProjectBillingCategory | ProjectBillingCategory | 1 | |
| 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 (
PROJECTBILLINGELEMENTUUID,
_PROJECTBILLINGELEMENTENTRY,
_WBSELEMENT,
BILLEDREVENUEAMTINDOCCRCY,
BILLINGWBSELEMENTINTERNALID,
DOCUMENTCURRENCY,
PROJBILLGELMNTCREATEDATDTETME,
PROJBILLGELMNTCREATEDBYUSER,
PROJBILLGELMNTLASTCHGDATDTETME,
PROJBILLGELMNTLASTCHGDBYUSER,
PROJBILLINGPROFILE,
PROJECTBILLINGCATEGORY,
WRITTENOFFREVENUEAMTINDOCCRCY,
PRIMARY KEY (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