PROJBLGELMNTENTR

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 Element Entry
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJBLGELMNTENTR (
    MANDT,                           -- Client [MANDT]
    PROJBILLGELMNTENTRITMUUID,       -- PBE Entry UUID [PBEE_UUID]
    PROJECTBILLINGELEMENTUUID,       -- PBE UUID [PBE_UUID]
    ORIGINALREVENUEAMTINDOCCRCY,     -- Original Revenue [PBEE_ORIGINALREVNINDOCCRCY]
    PROJBILLGELMNTENTRSOURCETYPE,    -- PBE Entry SourceType [PBEE_SOURCEID]
    PRJBLGELMENTRDATAMODELVERSION,   -- Data Model Version [PBEE_DATAVRSN]
    PRJBLGELMENTRYLONGTEXT,          -- long text [PBEE_LONGTEXT]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    MATERIAL,                        -- Material [MATNR]
    QUANTITYUNIT,                    -- Unit of measure [RUNIT]
    TRANSACTIONCURRENCY,             -- Transaction Currency [PBEE_TRANSACCRCY]
    PROJBILLGELMNTENTRISCANCELLED,   -- PBE Entry Cancelled [PBEE_ISCANCELLED]
    PRICINGDATE,                     -- Pricing Date [PBEE_PRICINGDATE]
    NETPRICEAMOUNTISMANUAL,          -- Net Price Manual [PBEE_NETPRICEISMANUAL]
    PROJECTCURRENCY,                 -- Project Currency [PBEE_PROJECTCRCY]
    GLOBALCURRENCY,                  -- Global Currency [PBEE_GLOBALCRCY]
    SERVICESRENDEREDDATE,            -- Serv. Rend. Dte [FBUDA]
    ORIGINALTOTALQUANTITY,           -- Original Quantity [PBEE_ORIGINALQTY]
    ORIGINALAMOUNTINTRANSACCRCY,     -- Origl Amt Trans Crcy [PBEE_ORIGLAMTTRANSCRCY]
    ORIGINALAMOUNTINPROJECTCRCY,     -- Origl Amt Proj Crcy [PBEE_ORIGLAMTPROJCRCY]
    ORIGINALAMOUNTINGLOBALCURRENCY,  -- Original Amt InGCrcy [PBEE_ORIGLAMTINGCRCY]
    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]
    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]
    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]
    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]
    BILLABLEREVENUEAMTINDOCCRCY,     -- Billable Revenue [PBEE_BILLABLERVNINDOCCRCY]
    MANUALNETPRICEAMTINDOCCRCY,      -- Net Price [PBEE_MNLNETPRICEINDOCCRCY]
    NETPRICEAMOUNTINDOCCRCY,         -- Net Price [PBEE_NETPRICEINDOCCRCY]
    NETPRICEQUANTITY,                -- Net Rate [PBEE_SALESRATEPRICINGUNIT]
    NETPRICEQUANTITYUNIT,            -- Net Rate Unit [PBEE_SALESRATEUNIT]
    PROJBILLGELMNTENTRISREVERSED,    -- PBE Entry Reversed [PBEE_ISREVESRSED]
    PROJBILLGELMNTENTRISREVERSAL,    -- PBE Entry Reversal [PBEE_ISREVERSAL]
    PRJBLGELMENTRCANCLNSRCECODE,     -- Cancln Src PBEE [PBEE_CANCELLINGSRC]
    PROJECTBILLINGELEMENTENTRYDESC,  -- Item Description [PBEE_DESCRIPTION]
    PROJBILLGELEMENTENTRYOBJECT,     -- PBEE Object Number [PBEE_OBJNR]
    PRJBLGELMENTRCREATEDBYUSER,      -- PBE Entry Created By [PBEE_CREATEDBYUSR]
    PRJBLGELMENTRCREATEDATDTETME,    -- PBE Entry Created On [PBEE_CREATEDATDTETME]
    PRJBLGELMENTRLASTCHGDBYUSER,     -- PBE Entry Changed By [PBEE_CHANGEDBYUSR]
    PRJBLGELMENTRLASTCHGDATDTETME,   -- PBE Entry Changed On [PBEE_CHANGEDATDTETME]
    PROJBILLGTRANSFCOSTQTYCODE,      -- Transfer Qty/Costs [PBE_TRANSFER_QTY_COSTS]
    PROJBILLGITMVALISNOTACTUALCOST,  -- Item Not Actual Cost [PBE_ITEMISNOTACTUALCOST]
    OBJECTNUMBER,                    -- Object number [J_OBJNR]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    PRIMARY KEY (MANDT, PROJBILLGELMNTENTRITMUUID)
);