I_PROJECTBILLINGELEMENT

CDS View

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)

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

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