PROJBILLGREQITEM

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.

-- Project Billing Request Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJBILLGREQITEM (
    CLIENT,                          -- Client [MANDT]
    PROJECTBILLINGREQUESTITEMUUID,   -- Item UUID [PBRI_UUID]
    PROJECTBILLINGREQUESTUUID,       -- Proj Billg Req UUID [PBR_UUID]
    PROJBILLGELMNTENTRITMUUID,       -- PBE Entry UUID [PBEE_UUID]
    PROJECTBILLINGELEMENTUUID,       -- PBE UUID [PBE_UUID]
    SALESDOCUMENTITEM,               -- Item [POSNR]
    BILLINGPLAN,                     -- Bill. Plan No. [FPLNR]
    BILLINGPLANITEM,                 -- Item [FPLTR]
    BILLABLEREVENUEAMTINDOCCRCY,     -- Billable Revenue [PBE_BILLABLEREVNINDOCCRCY]
    NETPRICEAMOUNTINDOCCRCY,         -- Net Price [PBEE_NETPRICEINDOCCRCY]
    NETPRICEQUANTITY,                -- Net Rate [PBEE_SALESRATEPRICINGUNIT]
    NETPRICEQUANTITYUNIT,            -- Net Rate Unit [PBEE_SALESRATEUNIT]
    BASEUNITACTUALCOST,              -- Project Billing Request Item Cost Rate [PBRI_COSTRATE]
    MATERIAL,                        -- Material [MATNR]
    PROJBILLINGREQUESTITEMLONGTEXT,  -- Note [PBRI_LONGTEXT]
    PROJECTBILLINGREQUESTITEMDESC,   -- Item Description [PBRI_DESCRIPTION]
    PROJBILLGREQITMSOURCETYPE,       -- PBR Item SourceType [PBRI_SOURCEID]
    OPENQUANTITY,                    -- PBE Entry Open Qty [PBEE_OPENQTY]
    OPENAMOUNTINTRANSCRCY,           -- Open Amt Trans Crcy [PBEE_OPNAMTTRANSCRCY]
    OPENAMOUNTINPROJECTCURRENCY,     -- Open Amt Proj Crcy [PBEE_OPNAMTPROJCRCY]
    OPENAMOUNTINGLOBALCURRENCY,      -- Open Amt Glob Crcy [PBEE_OPNAMTINGCRCY]
    OPENREVENUEAMTINDOCCRCY,         -- Open Revenue [PBEE_OPENREVNINDOCCRCY]
    TOBEPOSTPONEDQUANTITY,           -- To Be Postponed Qty [PBEE_TOBEPSPNQTY]
    TOBEPOSTPONEDAMTINTRANSACCRCY,   -- Amt ToPostpn TrCrcy [PBEE_TOBEPSPNAMTTRANSCRCY]
    TOBEPOSTPONEDAMTINPROJECTCRCY,   -- Amt ToPostpn PrCrcy [PBEE_TOBEPSPNAMTPROJCRCY]
    TOBEPOSTPONEDAMTINGLOBALCRCY,    -- Amt ToPostpn GlCrcy [PBEE_TOBEPSPNAMTINGCRCY]
    TOBEWRITTENOFFQUANTITY,          -- Qty to Write Off [PBEE_TOBEWRTOFFQTY]
    TOBEWRITTENOFFAMTINTRANSCRCY,    -- Amt ToWrtOff TrCrcy [PBEE_TOBEWRTOFFTRANSCRCY]
    TOBEWRITTENOFFAMTINPROJECTCRCY,  -- Amt ToWrtOff PrCrcy [PBEE_TOBEWRTOFFPROJCRCY]
    TOBEWRITTENOFFAMTINGLOBALCRCY,   -- Amt ToWrtOff GlCrcy [PBEE_TOBEWRTOFFINGCRCY]
    TOBEBILLEDQUANTITY,              -- To Be Blld Qty [PBEE_TOBEBILLEDQTY]
    TOBEBILLEDAMTINTRANSCRCY,        -- To Be Blld Trans Cur [PBEE_TOBEBILLEDAMTTRANSCRCY]
    TOBEBILLEDAMTINPROJCURRENCY,     -- To Be Blld Proj Crcy [PBEE_TOBEBILLEDAMTPROJCRCY]
    TOBEBILLEDAMTINGLOBCURRENCY,     -- To Be Blld GlobCrcy [PBEE_TOBEBILLEDAMTINGCRCY]
    SERVICESRENDEREDDATE,            -- Serv. Rend. Dte [FBUDA]
    PROJBILLGREQITMCRTEDBYUSER,      -- Created By [PBRI_CREATEDBYUSR]
    PROJBILLGREQITMCRTEDATDTETME,    -- Created On [PBRI_CREATEDATDTETME]
    PROJBILLGREQITMLASTCHGDBY,       -- Item Changed By [PBRI_CHANGEDBYUSR]
    PROJBILLGREQITMLASTCHGDDTETME,   -- Item Changed On [PBRI_CHANGEDATDTETME]
    MANUALBILLABILITYSELECTION,      -- MnlBllySelection [PBRI_MANUALBILLABILITYSEL]
    MANUALBILLGSELFORPRJBLGREQITEM,  -- MnlBllySelection [PBRI_MANUALBILLABILITYSEL]
    PROJBILLGTRANSFCOSTQTYCODE,      -- Transfer Qty/Costs [PBE_TRANSFER_QTY_COSTS]
    PROJBILLGITMVALISNOTACTUALCOST,  -- Item Not Actual Cost [PBE_ITEMISNOTACTUALCOST]
    PRIMARY KEY (CLIENT, PROJECTBILLINGREQUESTITEMUUID)
);