I_SALESORDERITEM

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.

-- Sales Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERITEM (
    BILLINGPLAN,
    MATERIAL,
    PLANT,
    REFERENCESDDOCUMENT,
    SALESORDER,
    SALESORDERITEM,
    WBSELEMENTINTERNALID,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _BATCH,
    _BILLINGBLOCKSTATUS,
    _BUSINESSAREA,
    _CHMLCMPLNCSTATUS,
    _CREATEDBYUSER,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DANGEROUSGOODSSTATUS,
    _DELIVERYBLOCKSTATUS,
    _DELIVERYDATETYPERULE,
    _DELIVERYPRIORITY,
    _DELIVERYSTATUS,
    _DIVISION,
    _HIGHERLEVELITEM,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _ITEMBILLINGBLOCKREASON,
    _ITEMCATEGORY,
    _ITEMDOWNPAYMENTSTATUS,
    _ITEMGENERALINCOMPLETIONSTATUS,
    _ITEMVOLUMEUNIT,
    _ITEMWEIGHTUNIT,
    _MATERIAL,
    _MATLACCOUNTASSIGNMENTGROUP,
    _ORDERQUANTITYUNIT,
    _ORDERRELATEDBILLINGSTATUS,
    _ORIGINALLYREQUESTEDMATERIAL,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _PARTIALDELIVERYITEM,
    _PLANT,
    _PRODUCT,
    _PRODUCTGROUP,
    _PROFITCENTER,
    _REFERENCESDDOCUMENT,
    _REFERENCESDDOCUMENTCATEGORY,
    _REFERENCESDDOCUMENTITEM,
    _REQUESTEDQUANTITYUNIT,
    _ROUTE,
    _SAFETYDATASHEETSTATUS,
    _SALESDOCUMENTRJCNREASON,
    _SALESORDER,
    _SDDOCUMENTREJECTIONSTATUS,
    _SDPROCESSSTATUS,
    _SHIPPINGPOINT,
    _SHIPPINGTYPE,
    _STORAGELOCATION,
    _TRANSACTIONCURRENCY,
    _TRANSITPLANT,
    _TRDCMPLNCEMBARGOSTS,
    _TRDCMPLNCSNCTNDLISTCHKSTS,
    _WBSELEMENTBASICDATA_2,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BATCH,
    BILLINGBLOCKSTATUS,
    BILLINGDOCUMENTDATE,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDERITEM,
    CAPPEDNETAMOUNT,
    CAPPEDNETAMTALERTTHLDINPCT,
    CHMLCMPLNCSTATUS,
    CONFDDELIVQTYINORDERQTYUNIT,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    DANGEROUSGOODSSTATUS,
    DELIVERYBLOCKSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYDATETYPERULE,
    DELIVERYGROUP,
    DELIVERYPRIORITY,
    DELIVERYSTATUS,
    DIVISION,
    FINANCIALCHAIN,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDVALUEDATE,
    HIGHERLEVELITEM,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    INTERNATIONALARTICLENUMBER,
    ITEMBILLINGBLOCKREASON,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMGROSSWEIGHT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIALBYCUSTOMER,
    MATLACCOUNTASSIGNMENTGROUP,
    MAXNMBROFPARTIALDELIVERY,
    NETAMOUNT,
    ORDERCOMBINATIONISALLOWED,
    ORDERQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORIGINALLYREQUESTEDMATERIAL,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PARTIALDELIVERYISALLOWED,
    PRICINGDATE,
    PRODUCT,
    PRODUCTCONFIGURATION,
    PRODUCTGROUP,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PROFITCENTER,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    RECEIVINGPOINT,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    ROUTE,
    SAFETYDATASHEETSTATUS,
    SALESDOCUMENTRJCNREASON,
    SALESORDERITEMCATEGORY,
    SALESORDERITEMTEXT,
    SDDOCUMENTREJECTIONSTATUS,
    SDPROCESSSTATUS,
    SERVICESRENDEREDDATE,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SLSORDERITEMDOWNPAYMENTSTATUS,
    STORAGELOCATION,
    TAXAMOUNT,
    TRANSACTIONCURRENCY,
    TRANSITPLANT,
    TRDCMPLNCEMBARGOSTS,
    TRDCMPLNCSNCTNDLISTCHKSTS,
    UNDERLYINGPURCHASEORDERITEM,
    VALUECHAINCATEGORY,
    WBSELEMENT,
    PRIMARY KEY (BILLINGPLAN, MATERIAL, PLANT, REFERENCESDDOCUMENT, SALESORDER, SALESORDERITEM, WBSELEMENTINTERNALID)
);