I_PROJECTBILLINGREQUESTITEM

CDS View
47 Fields 9 CDS Views

Items for Project Billing Request

I_PROJECTBILLINGREQUESTITEM is a CDS View in S/4HANA. Items for Project Billing Request. It contains 47 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ProjBillgRequestItemWithErr view from CONSUMPTION PBR excluded posting items
C_ProjBillingReqDetsForWrkflw view_entity from CONSUMPTION Aggregation for PBRI details
I_ProjectBillingRequestItemTP view_entity from TRANSACTIONAL Item Details of Project Billing Request
P_PrjBlgElmBillingReqRevnAmt view from COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmBillingReqRevnAmt view union_all COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmntEntrMnlSeldToBill view_entity inner COMPOSITE PrjBlgElmntEntr manually sel. for Billg
P_ProjBillgReqDetails view_entity inner TRANSACTIONAL P view for Proj Billing Request details
P_ProjBillingInProcessDetails view_entity inner TRANSACTIONAL P view for Billing in Process details
R_ProjectBillingRequestItemTP view_entity from TRANSACTIONAL Project Billing Request Item TP

Fields (47)

KeyField CDS FieldsUsed in Views
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 3
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItemUUID 2
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID 3
_Material _Material 1
_ProjectBillingRequest _ProjectBillingRequest 3
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 2
BillingPlan BillingPlan 1
BillingPlanItem BillingPlanItem 1
DocumentCurrency DocumentCurrency 6
GlobalCurrency GlobalCurrency 3
ManualBillgSelForPrjBlgReqItem ManualBillgSelForPrjBlgReqItem 3
Material Material 2
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy 2
NetPriceQuantity NetPriceQuantity 1
NetPriceQuantityUnit NetPriceQuantityUnit 1
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency 2
OpenAmountInProjectCurrency OpenAmountInProjectCurrency 2
OpenAmountInTransCrcy OpenAmountInTransCrcy 2
OpenQuantity OpenQuantity 2
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy 2
ProjBillgItmValIsNotActualCost ProjBillgItmValIsNotActualCost 2
ProjBillgReqItmCrtedAtDteTme ProjBillgReqItmCrtedAtDteTme 2
ProjBillgReqItmCrtedByUser ProjBillgReqItmCrtedByUser 2
ProjBillgReqItmLastChgdBy ProjBillgReqItmLastChgdBy 2
ProjBillgReqItmLastChgdDteTme ProjBillgReqItmLastChgdDteTme 2
ProjBillgReqItmSourceType ProjBillgReqItmSourceType 1
ProjBillgTransfCostQtyCode ProjBillgTransfCostQtyCode 2
ProjBillingRequestItemLongText ProjBillingRequestItemLongText 2
ProjectBillingElementUUID ProjectBillingElementUUID 3
ProjectBillingRequestItemDesc ProjectBillingRequestItemDesc 1
ProjectCurrency ProjectCurrency 3
QuantityUnit QuantityUnit 2
SalesDocumentItem SalesDocumentItem 2
ServicesRenderedDate ServicesRenderedDate 2
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

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.

-- Items for Project Billing Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTBILLINGREQUESTITEM (
    PROJBILLGELMNTENTRITMUUID,
    PROJECTBILLINGREQUESTITEMUUID,
    PROJECTBILLINGREQUESTUUID,
    _MATERIAL,
    _PROJECTBILLINGREQUEST,
    BILLABLEREVENUEAMTINDOCCRCY,
    BILLINGPLAN,
    BILLINGPLANITEM,
    DOCUMENTCURRENCY,
    GLOBALCURRENCY,
    MANUALBILLGSELFORPRJBLGREQITEM,
    MATERIAL,
    NETPRICEAMOUNTINDOCCRCY,
    NETPRICEQUANTITY,
    NETPRICEQUANTITYUNIT,
    OPENAMOUNTINGLOBALCURRENCY,
    OPENAMOUNTINPROJECTCURRENCY,
    OPENAMOUNTINTRANSCRCY,
    OPENQUANTITY,
    OPENREVENUEAMTINDOCCRCY,
    PROJBILLGITMVALISNOTACTUALCOST,
    PROJBILLGREQITMCRTEDATDTETME,
    PROJBILLGREQITMCRTEDBYUSER,
    PROJBILLGREQITMLASTCHGDBY,
    PROJBILLGREQITMLASTCHGDDTETME,
    PROJBILLGREQITMSOURCETYPE,
    PROJBILLGTRANSFCOSTQTYCODE,
    PROJBILLINGREQUESTITEMLONGTEXT,
    PROJECTBILLINGELEMENTUUID,
    PROJECTBILLINGREQUESTITEMDESC,
    PROJECTCURRENCY,
    QUANTITYUNIT,
    SALESDOCUMENTITEM,
    SERVICESRENDEREDDATE,
    TOBEBILLEDAMTINGLOBCURRENCY,
    TOBEBILLEDAMTINPROJCURRENCY,
    TOBEBILLEDAMTINTRANSCRCY,
    TOBEBILLEDQUANTITY,
    TOBEPOSTPONEDAMTINGLOBALCRCY,
    TOBEPOSTPONEDAMTINPROJECTCRCY,
    TOBEPOSTPONEDAMTINTRANSACCRCY,
    TOBEPOSTPONEDQUANTITY,
    TOBEWRITTENOFFAMTINGLOBALCRCY,
    TOBEWRITTENOFFAMTINPROJECTCRCY,
    TOBEWRITTENOFFAMTINTRANSCRCY,
    TOBEWRITTENOFFQUANTITY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PROJBILLGELMNTENTRITMUUID, PROJECTBILLINGREQUESTITEMUUID, PROJECTBILLINGREQUESTUUID)
);

Learn More