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 56 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_IntcoProjectBillingElement view_entity inner BASIC Intercompany Project Billing Element
I_PrjBlgElmBllbleRevnAmt view_entity from COMPOSITE Billable Rev Amt for Proj Billg Elmnt
I_ProjectBillingElementEntryTP view_entity from TRANSACTIONAL Entry Details of Billing Element
I_WrittenOffPrjBlgElmEntrDets view_entity inner COMPOSITE Details for Written off items
P_EngmntProjBillgDetails view_entity inner COMPOSITE Unbilled Revenue
P_EngmntProjExpBillgDetails view from COMPOSITE Unbilled required fields for Expense without special case
P_EProjBillgElmntEntrLink view inner COMPOSITE Get Engagement Project billing entry items
P_EvtBsdRevnRecgnProjWIPBeeFlw view_entity from COMPOSITE WIP (2) - Pbe+PbeFlw (OrigRev+BillReq/BilledRev/WrittOff)
P_PrjBlgElmBillingReqRevnAmt view_entity inner COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmntToBillAmtSrvcDte view_entity from COMPOSITE ToBill Amt for Prj.Bil.Elmnt by Srvc.Dte
P_PrjBlgElmntToBillAmtSrvcDte2 view_entity from COMPOSITE Project Billing Element ToBill Amount
P_ProjBillingElementEntrFlw00 view inner COMPOSITE P-View Proj Billing Element Flow
R_ProjectBillingElementEntryTP view_entity from TRANSACTIONAL Project Billing Element Entry TP

Fields (56)

KeyField CDS FieldsUsed in Views
KEY DocumentCurrency DocumentCurrency 6
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 5
KEY ProjectBillingElementUUID ProjectBillingElementUUID 9
_Material _Material 2
_ProjectBillingElement _ProjectBillingElement 1
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 2
GlobalCurrency GlobalCurrency 2
ManualNetPriceAmtInDocCrcy ManualNetPriceAmtInDocCrcy 2
Material Material 5
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 4
OriginalAmountInGlobalCurrency OriginalAmountInGlobalCurrency 2
OriginalAmountInProjectCrcy OriginalAmountInProjectCrcy 2
OriginalAmountInTransacCrcy OriginalAmountInTransacCrcy 2
OriginalRevenueAmtInDocCrcy OriginalRevenueAmtInDocCrcy 4
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
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 3
WBSElementInternalID WBSElementInternalID 5

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 (
    DOCUMENTCURRENCY,
    PROJBILLGELMNTENTRITMUUID,
    PROJECTBILLINGELEMENTUUID,
    _MATERIAL,
    _PROJECTBILLINGELEMENT,
    BILLABLEREVENUEAMTINDOCCRCY,
    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,
    PROJECTCURRENCY,
    QUANTITYUNIT,
    SERVICESRENDEREDDATE,
    TOBEBILLEDAMTINGLOBCURRENCY,
    TOBEBILLEDAMTINPROJCURRENCY,
    TOBEBILLEDAMTINTRANSCRCY,
    TOBEBILLEDQUANTITY,
    TOBEPOSTPONEDAMTINGLOBALCRCY,
    TOBEPOSTPONEDAMTINPROJECTCRCY,
    TOBEPOSTPONEDAMTINTRANSACCRCY,
    TOBEPOSTPONEDQUANTITY,
    TOBEWRITTENOFFAMTINGLOBALCRCY,
    TOBEWRITTENOFFAMTINPROJECTCRCY,
    TOBEWRITTENOFFAMTINTRANSCRCY,
    TOBEWRITTENOFFQUANTITY,
    TRANSACTIONCURRENCY,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (DOCUMENTCURRENCY, PROJBILLGELMNTENTRITMUUID, PROJECTBILLINGELEMENTUUID)
);