T_PURCHASEREQNITEM

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.

-- Purchase Requisition Basic Item View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T_PURCHASEREQNITEM (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    _ACCASSGNMTCATEGORY,
    _CURRENCY,
    _PLANT,
    _PURCHASINGGROUP,
    _SUPPLIER,
    _UNITOFMEASURE,
    ACCOUNTASSIGNMENTCATEGORY,
    BASEUNIT,
    BATCH,
    BUDGETPERIOD,
    COMMITMENTITEM,
    CONSUMPTIONPOSTING,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    DELIVDATECATEGORY,
    DELIVERYADDRESSID,
    DELIVERYDATE,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    EXPECTEDOVERALLLIMITAMOUNT,
    EXTERNALAPPROVALSTATUS,
    FIXEDSUPPLIER,
    FUNCTIONALAREA,
    FUND,
    FUNDEDPROGRAM,
    FUNDMGMTISACTIVE,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    GRANTID,
    HIERARCHYDRILLSTATE,
    HIERARCHYLEVEL,
    HIERARCHYNODE,
    HIERARCHYNODEORDINALNUMBER,
    HIERARCHYNODESUBTREESIZE,
    HIERARCHYPARENTNODE,
    INVOICEISEXPECTED,
    ISCLOSED,
    ISDELETED,
    ISOUTLINE,
    ISPURREQNBLOCKED,
    ISPURREQNOVRLREL,
    ITEMDELIVERYADDRESSID,
    ITEMNETAMOUNT,
    LANGUAGE,
    MANUALDELIVERYADDRESSID,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALREVISIONLEVEL,
    MINREMAININGSHELFLIFE,
    MRPCONTROLLER,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    ORDEREDQUANTITY,
    OVERALLLIMITAMOUNT,
    PARTIALINVOICEDISTRIBUTION,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PFMTRANSDATAFOOTPRINTUUID,
    PLANT,
    PROCESSINGSTATUS,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERPRICETYPE,
    PURCHASEREQNITEMUNIQUEID,
    PURCHASEREQUISITIONISFIXED,
    PURCHASEREQUISITIONITEMFOREDIT,
    PURCHASEREQUISITIONITEMTEXT,
    PURCHASEREQUISITIONPRICE,
    PURCHASEREQUISITIONRELEASEDATE,
    PURCHASEREQUISITIONSTATUS,
    PURCHASEREQUISITIONTYPE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    PURCHASINGPARENTITEM,
    PURCONTRACTFOROVERALLLIMIT,
    PURCONTRACTITEMFOROVERALLLIMIT,
    PURGCONFIGURABLEITEMNUMBER,
    PURGEXTERNALSORTNUMBER,
    PURREQCREATIONDATE,
    PURREQNCATALOG,
    PURREQNCATALOGITEM,
    PURREQNCROSSCATALOGITEM,
    PURREQNISAPPLICABLEFORREWORK,
    PURREQNISPFMFOOTPRINTVISIBLE,
    PURREQNITEMCURRENCY,
    PURREQNLIMITCONSUMPTIONAMT,
    PURREQNORIGIN,
    PURREQNPRICEQUANTITY,
    PURREQNRELEASESTATUS,
    PURREQNREWORKCOMMENTTEXT,
    PURREQNSOURCEOFSUPPLYTYPE,
    PURREQNSSPREQUESTOR,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    RELEASESTRATEGY,
    REQUESTEDQUANTITY,
    REQUIREMENTTRACKING,
    REQUISITIONERNAME,
    SERVICEPERFORMER,
    SOURCEOFSUPPLYISASSIGNED,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERMATERIALNUMBER,
    SUPPLYINGPLANT,
    TAXCODE,
    USERDESCRIPTION,
    WBSELEMENT,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);