I_PROJECTBILLINGELEMENTENTRY
Entries for Project Billing Element
I_PROJECTBILLINGELEMENTENTRY is a CDS View in S/4HANA. Entries for Project Billing Element. It contains 55 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProjBillingReqDetsForWrkflw | view_entity | inner | CONSUMPTION | Aggregation for PBRI details |
| I_ProjectBillingElementEntryTP | view_entity | from | TRANSACTIONAL | Entry Details of Billing Element |
| I_WrittenOffPrjBlgElmEntrDets | view | inner | COMPOSITE | Details for Written off items |
| P_EvtBsdRevnRecgnProjWIPBeeFlw | view | from | COMPOSITE | |
| P_PrjBlgElmBillingReqRevnAmt | view | inner | COMPOSITE | Billing Requested Amt for Billing Elmnt |
| P_PrjBlgElmntToBillAmtSrvcDte | view_entity | from | COMPOSITE | ToBill Amt for Prj.Bil.Elmnt by Srvc.Dte |
| P_ProjBillingElementEntrFlw00 | view | inner | COMPOSITE | |
| R_ProjectBillingElementEntryTP | view_entity | from | TRANSACTIONAL | Project Billing Element Entry TP |
Fields (55)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjBillgElmntEntrItmUUID | ProjBillgElmntEntrItmUUID | 2 |
| _Material | _Material | 2 | |
| BillableRevenueAmtInDocCrcy | BillableRevenueAmtInDocCrcy | 2 | |
| DocumentCurrency | DocumentCurrency | 3 | |
| GlobalCurrency | GlobalCurrency | 2 | |
| ManualNetPriceAmtInDocCrcy | ManualNetPriceAmtInDocCrcy | 2 | |
| Material | Material | 2 | |
| NetPriceAmountInDocCrcy | NetPriceAmountInDocCrcy | 2 | |
| NetPriceAmountIsManual | NetPriceAmountIsManual | 2 | |
| NetPriceQuantity | NetPriceQuantity | 1 | |
| NetPriceQuantityUnit | NetPriceQuantityUnit | 1 | |
| OpenAmountInGlobalCurrency | OpenAmountInGlobalCurrency | 2 | |
| OpenAmountInProjectCurrency | OpenAmountInProjectCurrency | 2 | |
| OpenAmountInTransCrcy | OpenAmountInTransCrcy | 2 | |
| OpenQuantity | OpenQuantity | 2 | |
| OpenRevenueAmtInDocCrcy | OpenRevenueAmtInDocCrcy | 2 | |
| OriginalAmountInGlobalCurrency | OriginalAmountInGlobalCurrency | 2 | |
| OriginalAmountInProjectCrcy | OriginalAmountInProjectCrcy | 2 | |
| OriginalAmountInTransacCrcy | OriginalAmountInTransacCrcy | 2 | |
| OriginalRevenueAmtInDocCrcy | OriginalRevenueAmtInDocCrcy | 2 | |
| OriginalTotalQuantity | OriginalTotalQuantity | 2 | |
| PostingDate | PostingDate | 1 | |
| PricingDate | PricingDate | 2 | |
| PrjBlgElmEntrCanclnSrceCode | PrjBlgElmEntrCanclnSrceCode | 2 | |
| PrjBlgElmEntrCreatedAtDteTme | PrjBlgElmEntrCreatedAtDteTme | 2 | |
| PrjBlgElmEntrCreatedByUser | PrjBlgElmEntrCreatedByUser | 2 | |
| PrjBlgElmEntrLastChgdAtDteTme | PrjBlgElmEntrLastChgdAtDteTme | 2 | |
| PrjBlgElmEntrLastChgdByUser | PrjBlgElmEntrLastChgdByUser | 2 | |
| PrjBlgElmEntryLongText | PrjBlgElmEntryLongText | 2 | |
| ProjBillgElementEntryObject | ProjBillgElementEntryObject | 1 | |
| ProjBillgElmntEntrIsCancelled | ProjBillgElmntEntrIsCancelled | 2 | |
| ProjBillgElmntEntrIsReversal | ProjBillgElmntEntrIsReversal | 2 | |
| ProjBillgElmntEntrIsReversed | ProjBillgElmntEntrIsReversed | 2 | |
| ProjBillgElmntEntrSourceType | ProjBillgElmntEntrSourceType | 2 | |
| ProjBillgItmValIsNotActualCost | ProjBillgItmValIsNotActualCost | 2 | |
| ProjBillgTransfCostQtyCode | ProjBillgTransfCostQtyCode | 2 | |
| ProjectBillingElementEntryDesc | ProjectBillingElementEntryDesc | 1 | |
| ProjectBillingElementUUID | ProjectBillingElementUUID | 3 | |
| ProjectCurrency | ProjectCurrency | 2 | |
| QuantityUnit | QuantityUnit | 2 | |
| ServicesRenderedDate | ServicesRenderedDate | 3 | |
| ToBeBilledAmtInGlobCurrency | ToBeBilledAmtInGlobCurrency | 2 | |
| ToBeBilledAmtInProjCurrency | ToBeBilledAmtInProjCurrency | 2 | |
| ToBeBilledAmtInTransCrcy | ToBeBilledAmtInTransCrcy | 2 | |
| ToBeBilledQuantity | ToBeBilledQuantity | 2 | |
| ToBePostponedAmtInGlobalCrcy | ToBePostponedAmtInGlobalCrcy | 2 | |
| ToBePostponedAmtInProjectCrcy | ToBePostponedAmtInProjectCrcy | 2 | |
| ToBePostponedAmtInTransacCrcy | ToBePostponedAmtInTransacCrcy | 2 | |
| ToBePostponedQuantity | ToBePostponedQuantity | 2 | |
| ToBeWrittenOffAmtInGlobalCrcy | ToBeWrittenOffAmtInGlobalCrcy | 2 | |
| ToBeWrittenOffAmtInProjectCrcy | ToBeWrittenOffAmtInProjectCrcy | 2 | |
| ToBeWrittenOffAmtInTransCrcy | ToBeWrittenOffAmtInTransCrcy | 2 | |
| ToBeWrittenOffQuantity | ToBeWrittenOffQuantity | 2 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| WBSElementInternalID | WBSElementInternalID | 2 |
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.
-- Entries for Project Billing Element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTBILLINGELEMENTENTRY (
PROJBILLGELMNTENTRITMUUID,
_MATERIAL,
BILLABLEREVENUEAMTINDOCCRCY,
DOCUMENTCURRENCY,
GLOBALCURRENCY,
MANUALNETPRICEAMTINDOCCRCY,
MATERIAL,
NETPRICEAMOUNTINDOCCRCY,
NETPRICEAMOUNTISMANUAL,
NETPRICEQUANTITY,
NETPRICEQUANTITYUNIT,
OPENAMOUNTINGLOBALCURRENCY,
OPENAMOUNTINPROJECTCURRENCY,
OPENAMOUNTINTRANSCRCY,
OPENQUANTITY,
OPENREVENUEAMTINDOCCRCY,
ORIGINALAMOUNTINGLOBALCURRENCY,
ORIGINALAMOUNTINPROJECTCRCY,
ORIGINALAMOUNTINTRANSACCRCY,
ORIGINALREVENUEAMTINDOCCRCY,
ORIGINALTOTALQUANTITY,
POSTINGDATE,
PRICINGDATE,
PRJBLGELMENTRCANCLNSRCECODE,
PRJBLGELMENTRCREATEDATDTETME,
PRJBLGELMENTRCREATEDBYUSER,
PRJBLGELMENTRLASTCHGDATDTETME,
PRJBLGELMENTRLASTCHGDBYUSER,
PRJBLGELMENTRYLONGTEXT,
PROJBILLGELEMENTENTRYOBJECT,
PROJBILLGELMNTENTRISCANCELLED,
PROJBILLGELMNTENTRISREVERSAL,
PROJBILLGELMNTENTRISREVERSED,
PROJBILLGELMNTENTRSOURCETYPE,
PROJBILLGITMVALISNOTACTUALCOST,
PROJBILLGTRANSFCOSTQTYCODE,
PROJECTBILLINGELEMENTENTRYDESC,
PROJECTBILLINGELEMENTUUID,
PROJECTCURRENCY,
QUANTITYUNIT,
SERVICESRENDEREDDATE,
TOBEBILLEDAMTINGLOBCURRENCY,
TOBEBILLEDAMTINPROJCURRENCY,
TOBEBILLEDAMTINTRANSCRCY,
TOBEBILLEDQUANTITY,
TOBEPOSTPONEDAMTINGLOBALCRCY,
TOBEPOSTPONEDAMTINPROJECTCRCY,
TOBEPOSTPONEDAMTINTRANSACCRCY,
TOBEPOSTPONEDQUANTITY,
TOBEWRITTENOFFAMTINGLOBALCRCY,
TOBEWRITTENOFFAMTINPROJECTCRCY,
TOBEWRITTENOFFAMTINTRANSCRCY,
TOBEWRITTENOFFQUANTITY,
TRANSACTIONCURRENCY,
WBSELEMENTINTERNALID,
PRIMARY KEY (PROJBILLGELMNTENTRITMUUID)
);
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