PROJECTBILLINGREQUESTITEM
PROJECTBILLINGREQUESTITEM is an SAP database table in S/4HANA. It contains 55 fields.
Fields (55)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA