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 (
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    COMPANYCODE,
    EBELN,
    EBELP,
    EXTSOURCESYSTEM,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    _PLANT,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    ACCOUNTASSIGNMENTCATEGORY,
    COMPANYCODENAME,
    CREATEDBYUSER,
    CROSSPLANTCONFIGURABLEPRODUCT,
    DELIVERYSTATUS,
    DELIVERYSTATUSDESCRIPTION,
    DOCUMENTCURRENCY,
    GOODSRECEIPTQTY,
    ISCOMPLETELYDELIVERED,
    ISENDOFPURPOSEBLOCKED,
    ISRETURNSITEM,
    MATERIAL,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MAXCONTRACTAMOUNT,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    OVERALLLIMITAMOUNT,
    PLANT,
    PLANTNAME,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERITEMUNIQUEID,
    PURCHASEORDEROUTPUTSTATUSNAME,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEORDERSTATUS,
    PURCHASEORDERTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGGROUPNAME,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATIONNAME,
    PURGCATNAME,
    PURGDOCHDRCOMPANYCODE,
    RECEIVINGCOMPANYCODE,
    ROUGHGOODSRECEIPTQTY,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEOPENQTY,
    SCHEDULELINEORDERQUANTITY,
    SERVICEPERFORMER,
    STILLTOINVOICEVALUE,
    STOCKSEGMENT,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    SUPPLIERNAME,
    PRIMARY KEY (CALENDARMONTH, CALENDARQUARTER, CALENDARWEEK, CALENDARYEAR, COMPANYCODE, EBELN, EBELP, EXTSOURCESYSTEM, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTCATEGORY, PURCHASINGDOCUMENTITEM, PURCHASINGDOCUMENTSTATUS, PURCHASINGGROUP, PURCHASINGORGANIZATION, SUPPLIER, WBSELEMENTINTERNALID)
);