_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,
    WBSELEMENTINTERNALID,
    _MATERIAL,
    _PLANT,
    _SALESORDER,
    BATCH,
    BILLINGBLOCKSTATUS,
    BILLINGDOCUMENTDATE,
    BILLINGPLAN,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    CAPPEDNETAMOUNT,
    CHMLCMPLNCSTATUS,
    CONTRACTITEMDOWNPAYMENTSTATUS,
    CONTROLLINGAREA,
    CREATIONDATE,
    CUSTOMERPAYMENTTERMS,
    DANGEROUSGOODSSTATUS,
    DELIVERYBLOCKSTATUS,
    DELIVERYCONFIRMATIONSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYPRIORITY,
    DELIVERYSTATUS,
    DIVISION,
    INCOTERMSCLASSIFICATION,
    INCOTERMSVERSION,
    ITEMBILLINGBLOCKREASON,
    ITEMBILLINGINCOMPLETIONSTATUS,
    ITEMDELIVERYINCOMPLETIONSTATUS,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMISDELIVERYRELEVANT,
    MATERIAL,
    MATERIALBYCUSTOMER,
    NETAMOUNT,
    ORDERRELATEDBILLINGSTATUS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PARTIALDELIVERYISALLOWED,
    PAYERPARTY,
    PAYMENTMETHOD,
    PLANT,
    PRICINGDATE,
    PRICINGINCOMPLETIONSTATUS,
    PRODUCT,
    PRODUCTHIERARCHYNODE,
    PROFITCENTER,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    RESPONSIBLEEMPLOYEE,
    ROUTE,
    SAFETYDATASHEETSTATUS,
    SALESDISTRICT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTRJCNREASON,
    SALESEMPLOYEE,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERID,
    SALESORDERITEMCATEGORY,
    SALESORDERITEMPOSITION,
    SALESORDERITEMTEXT,
    SALESORDERITEMTYPE,
    SDDOCREFERENCESTATUS,
    SDDOCUMENTREJECTIONSTATUS,
    SDPROCESSSTATUS,
    SHIPPINGCONDITION,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    SOLDTOPARTY,
    STORAGELOCATION,
    TOTALDELIVERYSTATUS,
    TOTALSDDOCREFERENCESTATUS,
    TRANSACTIONCURRENCY,
    TRDCMPLNCEMBARGOSTS,
    TRDCMPLNCSNCTNDLISTCHKSTS,
    PRIMARY KEY (SALESORDER, SALESORDERITEM, WBSELEMENTINTERNALID)
);