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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SALESORDERITEM (
    SALESORDER,
    SALESORDERITEM,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _BATCH,
    _BILLINGBLOCKSTATUS,
    _BUSINESSAREA,
    _CHMLCMPLNCSTATUS,
    _CONTROLLINGAREA,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DANGEROUSGOODSSTATUS,
    _DELIVERYBLOCKSTATUS,
    _DELIVERYDATETYPERULE,
    _DELIVERYPRIORITY,
    _DELIVERYSTATUS,
    _DOWNPAYMENTPROCESSINGVARIANT,
    _HIGHERLEVELITEM,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _ITEMBILLINGBLOCKREASON,
    _ITEMCATEGORY,
    _ITEMDOWNPAYMENTSTATUS,
    _ITEMGENERALINCOMPLETIONSTATUS,
    _ITEMISBILLINGRELEVANT,
    _ITEMVOLUMEUNIT,
    _ITEMWEIGHTUNIT,
    _MATLACCOUNTASSIGNMENTGROUP,
    _MRPAREA,
    _ORDERQUANTITYUNIT,
    _ORDERRELATEDBILLINGSTATUS,
    _ORIGINALLYREQUESTEDMATERIAL,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _PARTIALDELIVERYITEM,
    _PRODUCTGROUP,
    _PRODUCTPRICINGGROUP,
    _PURCHASECONFIRMATIONSTATUS,
    _REFERENCESDDOCUMENT,
    _REFERENCESDDOCUMENTCATEGORY,
    _REFERENCESDDOCUMENTITEM,
    _REQUESTEDQUANTITYUNIT,
    _ROUTE,
    _SAFETYDATASHEETSTATUS,
    _SALESDOCUMENTRJCNREASON,
    _SALESORDER,
    _SDDOCUMENTREJECTIONSTATUS,
    _SDPRICINGPROCEDURE,
    _SDPROCESSSTATUS,
    _SHIPPINGPOINT,
    _SHIPPINGTYPE,
    _SLSDOCITEMSUPPLYBLOCKREASON,
    _SLSDOCITMOVRLSUPPLYBLOCKSTS,
    _STORAGELOCATION,
    _TRANSACTIONCURRENCY,
    _TRDCMPLNCEMBARGOSTS,
    _TRDCMPLNCSNCTNDLISTCHKSTS,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BATCH,
    BILLINGBLOCKSTATUS,
    BILLINGDOCUMENTDATE,
    BILLINGPLAN,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDERITEM,
    BUSSOLNORDITEMBUNDLEITEM,
    CHMLCMPLNCSTATUS,
    CONFDDELIVQTYINORDERQTYUNIT,
    CONFIRMEDDELIVERYDATE,
    CONTROLLINGAREA,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCEXTREFBYSHIPTOPARTY,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    DANGEROUSGOODSSTATUS,
    DELIVERYBLOCKSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYDATETYPERULE,
    DELIVERYGROUP,
    DELIVERYPRIORITY,
    DELIVERYSTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOWNPAYMENTPROCESSINGVARIANT,
    ENPRJTPCUSTPRJEXPDNETAMTCRCY,
    ENTPROJTYPECUSTPROJEXPDNETAMT,
    FIXEDVALUEDATE,
    HIGHERLEVELITEM,
    HIGHERLEVELITEMCATEGORY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    INTERNATIONALARTICLENUMBER,
    ITEMBILLINGBLOCKREASON,
    ITEMCATEGORYGROUP,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMGROSSWEIGHT,
    ITEMISBILLINGRELEVANT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIALBYCUSTOMER,
    MATERIALGROUP,
    MATERIALPRICINGGROUP,
    MATLACCOUNTASSIGNMENTGROUP,
    MAXNMBROFPARTIALDELIVERY,
    MRPAREA,
    NETAMOUNT,
    ORDERCOMBINATIONISALLOWED,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORDERTOBASEQUANTITYDNMNTR,
    ORDERTOBASEQUANTITYNMRTR,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PARTIALDELIVERYISALLOWED,
    PLANT,
    PRICINGDATE,
    PRODUCT,
    PRODUCTCONFIGURATION,
    PRODUCTGROUP,
    PROFITCENTER,
    PURCHASECONFIRMATIONSTATUS,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    RECEIVINGPOINT,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    REQUESTEDDELIVERYDATE,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    ROUTE,
    SAFETYDATASHEETSTATUS,
    SALESDOCITEMSUPPLYBLOCKREASON,
    SALESDOCUMENTRJCNREASON,
    SALESDOCUMENTTYPE,
    SALESORDERITEMCATEGORY,
    SALESORDERITEMTEXT,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SDDOCUMENTITEMUSAGE,
    SDDOCUMENTREJECTIONSTATUS,
    SDPRICINGPROCEDURE,
    SDPROCESSSTATUS,
    SERVICESRENDEREDDATE,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    SLSCONTRAUTOASSGMTIDFORSLSORD,
    SLSDOCITMOVRLSUPPLYBLOCKSTATUS,
    SLSORDERITEMDOWNPAYMENTSTATUS,
    SOLDTOPARTY,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    TAXAMOUNT,
    TRANSACTIONCURRENCY,
    TRANSITPLANT,
    TRDCMPLNCEMBARGOSTS,
    TRDCMPLNCSNCTNDLISTCHKSTS,
    UNDERLYINGPURCHASEORDERITEM,
    UNDRLGPURORDITMBYSHIPTOPARTY,
    VALUECHAINCATEGORY,
    VARCONFIGURATIONBUSOBJECTKEY,
    VARCONFIGURATIONBUSOBJECTTYPE,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (SALESORDER, SALESORDERITEM)
);