_PURCHASEORDERITEM

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 _PURCHASEORDERITEM (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    _COMPANYCODE,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PURCHASEORDER,
    _SUPPLIERITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    ARTICLECATEGORY,
    BASEUNIT,
    COMPANYCODE,
    CREATIONDATE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CURRENCY,
    CUSTOMER,
    DOCUMENTCURRENCY,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    EFFECTIVEAMOUNT,
    EVALDRCPTSETTLMTISALLOWED,
    EXPECTEDOVERALLLIMITAMOUNT,
    FLDLOGSKITITMREFDOCUMENT1UUID,
    GOODSRECEIPTDURATIONINDAYS,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    HIGHESTMESSAGESEVERITYLEVEL,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INTERNATIONALARTICLENUMBER,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISCOMPLETELYDELIVERED,
    ISFINALLYINVOICED,
    ISRETURNSITEM,
    ISSTATISTICALITEM,
    ISSUINGSTORAGELOCATION,
    ITEMDESCRIPTION,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALGROUP,
    MRPAREA,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITY,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OVERALLLIMITAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PLANT,
    PPSPURORDERITEMSTATUS,
    PPSPURORDERITEMSTATUSTEXT,
    PPSPURORDITEMSTATUSCRITICALITY,
    PRICEISTOBEPRINTED,
    PRICINGDATECONTROL,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERITEMUNIQUEID,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEORDERTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGORDERREASON,
    PURCHASINGORGANIZATION,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGDOCITEMCATEGORYNAME,
    PURGDOCSUBITEMCATEGORY,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    REQUIREMENTTRACKING,
    REQUISITIONERNAME,
    RETAILPROMOTION,
    SERVICEPACKAGE,
    SERVICEPERFORMER,
    STOCKSEGMENT,
    STORAGELOCATION,
    SUPLREVALCRITRADELIVCOMPLETED,
    SUPPLIER,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERQUOTATION,
    SUPPLIERSUBRANGE,
    TAXCODE,
    TAXJURISDICTION,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    VALUATIONTYPE,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM)
);