_PURCHASEREQUISITIONITEM

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 _PURCHASEREQUISITIONITEM (
    PURCHASEREQNITEMUNIQUEID,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    _PURCHASEREQUISITION,
    _SUPPLIER,
    _UNITOFMEASURE,
    ACCOUNTASSIGNMENTCATEGORY,
    ADDRESSID,
    BASEUNIT,
    BATCH,
    COMPANYCODE,
    CONSUMPTIONPOSTING,
    CREATEDBYUSER,
    CREATIONDATE,
    DELIVDATECATEGORY,
    DELIVERYADDRESSID,
    DELIVERYDATE,
    EXPECTEDOVERALLLIMITAMOUNT,
    EXTCOMPANYCODEFORPURG,
    EXTCONTRACTFORPURG,
    EXTCONTRACTITEMFORPURG,
    EXTDESIREDSUPPLIERFORPURG,
    EXTFIXEDSUPPLIERFORPURG,
    EXTINFORECORDFORPURG,
    EXTMATERIALFORPURG,
    EXTPLANTFORPURG,
    EXTPURGORGFORPURG,
    FIXEDSUPPLIER,
    FIXEDSUPPLIERNAME,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    INVOICEISEXPECTED,
    ISCLOSED,
    ISDELETED,
    ISENDOFPURPOSEBLOCKED,
    ISPURREQNBLOCKED,
    ITEMDELIVERYADDRESSID,
    ITEMNETAMOUNT,
    LANGUAGE,
    LASTCHANGEDATETIME,
    MANUALDELIVERYADDRESSID,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALPLANNEDDELIVERYDURN,
    MINREMAININGSHELFLIFE,
    MRPAREA,
    MRPCONTROLLER,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    ORDEREDQUANTITY,
    OVERALLLIMITAMOUNT,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PROCESSINGSTATUS,
    PROCMTHUBPURCHASEREQUISITION,
    PROCMTHUBPURREQUISITIONITEM,
    PROCMTHUBPURREQUISITIONTYPE,
    PROCMTHUBSUPPLIER,
    PROCUREMENTHUBSOURCESYSTEM,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEREQNITEMCOLLECTION,
    PURCHASEREQNITEMSEASON,
    PURCHASEREQNITEMSEASONYEAR,
    PURCHASEREQNITEMSTOCKSEGMENT,
    PURCHASEREQNITEMTHEME,
    PURCHASEREQUISITIONISFIXED,
    PURCHASEREQUISITIONITEMTEXT,
    PURCHASEREQUISITIONPRICE,
    PURCHASEREQUISITIONRELEASEDATE,
    PURCHASEREQUISITIONSTATUS,
    PURCHASEREQUISITIONTYPE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    PURREQCREATIONDATE,
    PURREQNCMPLTNSCAT,
    PURREQNITEMCURRENCY,
    PURREQNLIMITCONSUMPTIONAMT,
    PURREQNORIGIN,
    PURREQNPRICEQUANTITY,
    PURREQNRELEASESTATUS,
    PURREQNREQUESTOR,
    PURREQNSOURCEOFSUPPLYTYPE,
    PURREQNSSPAUTHOR,
    PURREQNSSPCATALOG,
    PURREQNSSPCATALOGITEM,
    PURREQNSSPCROSSCATALOGITEM,
    PURREQNSSPREQUESTOR,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    REQUESTEDQUANTITY,
    REQUIREMENTTRACKING,
    REQUISITIONERNAME,
    SERVICEPERFORMER,
    SOURCEOFSUPPLYISASSIGNED,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERNAME,
    SUPPLYINGPLANT,
    PRIMARY KEY (PURCHASEREQNITEMUNIQUEID, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);