PROJECTBILLINGREQUESTITEM

55 Fields

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

Fields (55)

KeyField CDS FieldsUsed in Views
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItemUUID 4
_ProjectBillingRequest _ProjectBillingRequest 7
AccountingDocument AccountingDocument 3
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 3
BillingControlCategory BillingControlCategory 3
BillingPlanServiceEndDate BillingPlanServiceEndDate 2
BillingPlanServiceStartDate BillingPlanServiceStartDate 2
BusinessPartnerUUID BusinessPartnerUUID 3
CompanyCode CompanyCode 3
CostCtrActivityTypeDesc CostCtrActivityTypeDesc 4
DocumentCurrency DocumentCurrency 4
DueBillingDate DueBillingDate 2
FiscalYear FiscalYear 2
GlobalCurrency GlobalCurrency 3
Ledger Ledger 3
LedgerGLLineItem LedgerGLLineItem 3
ManualBillgSelForPrjBlgReqItem ManualBillgSelForPrjBlgReqItem 3
Material Material 3
NetPriceQuantityUnit NetPriceQuantityUnit 4
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency 3
OpenAmountInProjectCurrency OpenAmountInProjectCurrency 3
OpenAmountInTransCrcy OpenAmountInTransCrcy 3
OpenQuantity OpenQuantity 3
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy 3
ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 3
ProjBillgReqItmCrtedAtDteTme ProjBillgReqItmCrtedAtDteTme 3
ProjBillgReqItmCrtedByUser ProjBillgReqItmCrtedByUser 3
ProjBillgReqItmLastChgdBy ProjBillgReqItmLastChgdBy 3
ProjBillgReqItmLastChgdDteTme ProjBillgReqItmLastChgdDteTme 3
ProjBillgReqItmSourceType ProjBillgReqItmSourceType 3
ProjBillingRequestItemLongText ProjBillingRequestItemLongText 3
ProjectBillingElementUUID ProjectBillingElementUUID 3
ProjectBillingRequestItemDesc ProjectBillingRequestItemDesc 3
ProjectBillingRequestUUID ProjectBillingRequestUUID 4
ProjectCurrency ProjectCurrency 3
QuantityUnit QuantityUnit 3
SalesDocument SalesDocument 3
SalesDocumentItem SalesDocumentItem 3
SalesOrderItemConcatenatedID SalesOrderItemConcatenatedID 3
ServicesRenderedDate ServicesRenderedDate 3
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 3
ToBeBilledAmtInGlobCurrency ToBeBilledAmtInGlobCurrency 3
ToBeBilledAmtInProjCurrency ToBeBilledAmtInProjCurrency 3
ToBeBilledAmtInTransCrcy ToBeBilledAmtInTransCrcy 3
ToBeBilledQuantity ToBeBilledQuantity 3
ToBePostponedAmtInGlobalCrcy ToBePostponedAmtInGlobalCrcy 3
ToBePostponedAmtInProjectCrcy ToBePostponedAmtInProjectCrcy 3
ToBePostponedAmtInTransacCrcy ToBePostponedAmtInTransacCrcy 3
ToBePostponedQuantity ToBePostponedQuantity 3
ToBeWrittenOffAmtInGlobalCrcy ToBeWrittenOffAmtInGlobalCrcy 3
ToBeWrittenOffAmtInProjectCrcy ToBeWrittenOffAmtInProjectCrcy 3
ToBeWrittenOffAmtInTransCrcy ToBeWrittenOffAmtInTransCrcy 3
ToBeWrittenOffQuantity ToBeWrittenOffQuantity 3
TransactionCurrency TransactionCurrency 3
WorkItem WorkItem 4

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,
    BILLINGPLANSERVICEENDDATE,
    BILLINGPLANSERVICESTARTDATE,
    BUSINESSPARTNERUUID,
    COMPANYCODE,
    COSTCTRACTIVITYTYPEDESC,
    DOCUMENTCURRENCY,
    DUEBILLINGDATE,
    FISCALYEAR,
    GLOBALCURRENCY,
    LEDGER,
    LEDGERGLLINEITEM,
    MANUALBILLGSELFORPRJBLGREQITEM,
    MATERIAL,
    NETPRICEQUANTITYUNIT,
    OPENAMOUNTINGLOBALCURRENCY,
    OPENAMOUNTINPROJECTCURRENCY,
    OPENAMOUNTINTRANSCRCY,
    OPENQUANTITY,
    OPENREVENUEAMTINDOCCRCY,
    PROJBILLGELMNTENTRITMUUID,
    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)
);

Learn More