I_PROJECTBILLINGELEMENTENTRY

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);