I_PROJECTBILLINGREQUESTITEM

CDS View
57 Fields 10 CDS Views

Items for Project Billing Request

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
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_entity from COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmBillingReqRevnAmt view_entity 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_ProjBillgRequestItemDueDate view_entity from COMPOSITE Project Billing Request Item Billing Date
P_ProjBillgRequestItemWithErr view_entity from CONSUMPTION P-View for excluded posting item
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 (57)

KeyField CDS FieldsUsed in Views
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 4
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItemUUID 4
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID 4
_DocumentCurrency _DocumentCurrency 1
_DocumentCurrencyText _DocumentCurrencyText 1
_GlobalCurrency _GlobalCurrency 1
_GlobalCurrencyText _GlobalCurrencyText 1
_Material _Material 1
_ProjBillgReqItmSrceType _ProjBillgReqItmSrceType 1
_ProjBillgReqItmSrceTypeText _ProjBillgReqItmSrceTypeText 1
_ProjectBillingRequest _ProjectBillingRequest 3
_ProjectCurrency _ProjectCurrency 1
_ProjectCurrencyText _ProjectCurrencyText 1
_TransactionCurrency _TransactionCurrency 1
_TransactionCurrencyText _TransactionCurrencyText 1
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 3
BillingPlan BillingPlan 1
BillingPlanItem BillingPlanItem 1
DocumentCurrency DocumentCurrency 7
GlobalCurrency GlobalCurrency 4
ManualBillgSelForPrjBlgReqItem ManualBillgSelForPrjBlgReqItem 3
Material Material 3
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy 3
NetPriceQuantity NetPriceQuantity 1
NetPriceQuantityUnit NetPriceQuantityUnit 1
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency 2
OpenAmountInProjectCurrency OpenAmountInProjectCurrency 2
OpenAmountInTransCrcy OpenAmountInTransCrcy 3
OpenQuantity OpenQuantity 3
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 4
ProjectBillingRequestItemDesc ProjectBillingRequestItemDesc 1
ProjectCurrency ProjectCurrency 4
QuantityUnit QuantityUnit 3
SalesDocumentItem SalesDocumentItem 2
ServicesRenderedDate ServicesRenderedDate 2
ToBeBilledAmtInGlobCurrency ToBeBilledAmtInGlobCurrency 2
ToBeBilledAmtInProjCurrency ToBeBilledAmtInProjCurrency 2
ToBeBilledAmtInTransCrcy ToBeBilledAmtInTransCrcy 3
ToBeBilledQuantity ToBeBilledQuantity 3
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,
    _DOCUMENTCURRENCY,
    _DOCUMENTCURRENCYTEXT,
    _GLOBALCURRENCY,
    _GLOBALCURRENCYTEXT,
    _MATERIAL,
    _PROJBILLGREQITMSRCETYPE,
    _PROJBILLGREQITMSRCETYPETEXT,
    _PROJECTBILLINGREQUEST,
    _PROJECTCURRENCY,
    _PROJECTCURRENCYTEXT,
    _TRANSACTIONCURRENCY,
    _TRANSACTIONCURRENCYTEXT,
    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