_SALESDOCUMENTITEM

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 _SALESDOCUMENTITEM (
    SHIPTOPARTY,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _CUSTOMERGROUP,
    _DELIVERYPRIORITY,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _ITEMCATEGORY,
    _MATERIAL,
    _MATERIALGROUP,
    _MATERIALTEXT,
    _ORDERQUANTITYUNIT,
    _ORGANIZATIONDIVISION,
    _ORIGINALLYREQUESTEDMATERIAL,
    _PLANT,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTTEXT,
    _SALESDOCUMENTTYPE,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SHIPPINGPOINT,
    _STORAGELOCATION,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BATCH,
    BILLOFMATERIAL,
    BOMEXPLOSIONDATE,
    CHMLCMPLNCSTATUS,
    COMPLETIONRULE,
    CONTROLLINGOBJECT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERGROUP,
    CUSTRETITMFOLLOWUPACTIVITY,
    DANGEROUSGOODSSTATUS,
    DELIVERYCONFIRMATIONSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYGROUP,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    EXPDDELIVQUANTITYCHANGEREASON,
    FASHIONCANCELDATE,
    HIGHERLEVELITEM,
    INTERNATIONALARTICLENUMBER,
    INVENTORYSPECIALSTOCKTYPE,
    ISRETURNSITEM,
    ITEMBILLINGBLOCKREASON,
    ITEMBILLINGINCOMPLETIONSTATUS,
    ITEMDELIVERYINCOMPLETIONSTATUS,
    ITEMGENERALINCOMPLETIONSTATUS,
    LASTCHANGEDATE,
    MATERIAL,
    MATERIALBYCUSTOMER,
    MATERIALGROUP,
    MRPAREA,
    NETAMOUNT,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PLANT,
    PRICINGINCOMPLETIONSTATUS,
    PRICINGTYPE,
    PRODAVAILABILITYCHECKGROUP,
    PRODUCT,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PROFITCENTER,
    PURCHASECONFIRMATIONSTATUS,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    RETURNREASON,
    ROUTE,
    SAFETYDATASHEETSTATUS,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTEXT,
    SALESDOCUMENTITEMTYPE,
    SALESDOCUMENTITEMUUID,
    SALESDOCUMENTTYPE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SHIPPINGPOINT,
    STORAGELOCATION,
    TOTALDELIVERYSTATUS,
    TRDCMPLNCEMBARGOSTS,
    TRDCMPLNCSNCTNDLISTCHKSTS,
    UNLOADINGPOINTNAME,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (SHIPTOPARTY)
);