PROJECTBILLINGREQUESTITEM

PROJECTBILLINGREQUESTITEM is an SAP database table in S/4HANA. It contains 55 fields.

Fields (55)

KeyField CDS FieldsUsed in Views
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItemUUID 2
_ProjectBillingRequest _ProjectBillingRequest 4
AccountingDocument AccountingDocument 2
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 2
BillingControlCategory BillingControlCategory 2
BusinessPartnerUUID BusinessPartnerUUID 2
CostCtrActivityTypeDesc CostCtrActivityTypeDesc 2
DocumentCurrency DocumentCurrency 2
DueBillingDate DueBillingDate 2
FiscalYear FiscalYear 2
GlobalCurrency GlobalCurrency 2
Ledger Ledger 2
LedgerGLLineItem LedgerGLLineItem 2
ManualBillgSelForPrjBlgReqItem ManualBillgSelForPrjBlgReqItem 2
Material Material 2
MaterialGroup MaterialGroup 2
NetPriceQuantityUnit NetPriceQuantityUnit 2
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency 2
OpenAmountInProjectCurrency OpenAmountInProjectCurrency 2
OpenAmountInTransCrcy OpenAmountInTransCrcy 2
OpenQuantity OpenQuantity 2
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy 2
PersonFullName PersonFullName 2
ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 2
ProjBillgElmntEntrSourceType ProjBillgElmntEntrSourceType 2
ProjBillgReqItmCrtedAtDteTme ProjBillgReqItmCrtedAtDteTme 2
ProjBillgReqItmCrtedByUser ProjBillgReqItmCrtedByUser 2
ProjBillgReqItmLastChgdBy ProjBillgReqItmLastChgdBy 2
ProjBillgReqItmLastChgdDteTme ProjBillgReqItmLastChgdDteTme 2
ProjBillgReqItmSourceType ProjBillgReqItmSourceType 2
ProjBillingRequestItemLongText ProjBillingRequestItemLongText 2
ProjectBillingElementUUID ProjectBillingElementUUID 2
ProjectBillingRequestItemDesc ProjectBillingRequestItemDesc 2
ProjectBillingRequestUUID ProjectBillingRequestUUID 2
ProjectCurrency ProjectCurrency 2
QuantityUnit QuantityUnit 2
SalesDocument SalesDocument 2
SalesDocumentItem SalesDocumentItem 2
SalesOrderItemConcatenatedID SalesOrderItemConcatenatedID 2
ServicesRenderedDate ServicesRenderedDate 2
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 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
WorkItem WorkItem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJECTBILLINGREQUESTITEM (
    PROJECTBILLINGREQUESTITEMUUID,
    _PROJECTBILLINGREQUEST,
    ACCOUNTINGDOCUMENT,
    BILLABLEREVENUEAMTINDOCCRCY,
    BILLINGCONTROLCATEGORY,
    BUSINESSPARTNERUUID,
    COSTCTRACTIVITYTYPEDESC,
    DOCUMENTCURRENCY,
    DUEBILLINGDATE,
    FISCALYEAR,
    GLOBALCURRENCY,
    LEDGER,
    LEDGERGLLINEITEM,
    MANUALBILLGSELFORPRJBLGREQITEM,
    MATERIAL,
    MATERIALGROUP,
    NETPRICEQUANTITYUNIT,
    OPENAMOUNTINGLOBALCURRENCY,
    OPENAMOUNTINPROJECTCURRENCY,
    OPENAMOUNTINTRANSCRCY,
    OPENQUANTITY,
    OPENREVENUEAMTINDOCCRCY,
    PERSONFULLNAME,
    PROJBILLGELMNTENTRITMUUID,
    PROJBILLGELMNTENTRSOURCETYPE,
    PROJBILLGREQITMCRTEDATDTETME,
    PROJBILLGREQITMCRTEDBYUSER,
    PROJBILLGREQITMLASTCHGDBY,
    PROJBILLGREQITMLASTCHGDDTETME,
    PROJBILLGREQITMSOURCETYPE,
    PROJBILLINGREQUESTITEMLONGTEXT,
    PROJECTBILLINGELEMENTUUID,
    PROJECTBILLINGREQUESTITEMDESC,
    PROJECTBILLINGREQUESTUUID,
    PROJECTCURRENCY,
    QUANTITYUNIT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDERITEMCONCATENATEDID,
    SERVICESRENDEREDDATE,
    TIMESHEETOVERTIMECATEGORY,
    TOBEBILLEDAMTINGLOBCURRENCY,
    TOBEBILLEDAMTINPROJCURRENCY,
    TOBEBILLEDAMTINTRANSCRCY,
    TOBEBILLEDQUANTITY,
    TOBEPOSTPONEDAMTINGLOBALCRCY,
    TOBEPOSTPONEDAMTINPROJECTCRCY,
    TOBEPOSTPONEDAMTINTRANSACCRCY,
    TOBEPOSTPONEDQUANTITY,
    TOBEWRITTENOFFAMTINGLOBALCRCY,
    TOBEWRITTENOFFAMTINPROJECTCRCY,
    TOBEWRITTENOFFAMTINTRANSCRCY,
    TOBEWRITTENOFFQUANTITY,
    TRANSACTIONCURRENCY,
    WORKITEM,
    PRIMARY KEY (PROJECTBILLINGREQUESTITEMUUID)
);