I_SALESORDER

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDER (
    PAYMENTPLAN,
    SALESORDER,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _BILLINGCOMPANYCODE,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _CREDITCONTROLAREA,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERCREDITACCOUNT,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _CUSTOMERPURCHASEORDERTYPE,
    _DELIVERYBLOCKREASON,
    _DELIVERYDATETYPERULE,
    _DISTRIBUTIONCHANNEL,
    _DOWNPAYMENTSTATUS,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LASTCHANGEDBYUSER,
    _OMNICHNLSALESPROMOTIONSTATUS,
    _ORGANIZATIONDIVISION,
    _OVERALLBILLINGBLOCKSTATUS,
    _OVERALLCHMLCMPLNCSTATUS,
    _OVERALLDANGEROUSGOODSSTATUS,
    _OVERALLDELIVERYBLOCKSTATUS,
    _OVERALLDELIVERYSTATUS,
    _OVERALLORDRELTDBILLGSTATUS,
    _OVERALLSDDOCREFERENCESTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _OVRLSFTYDATASHEETSTS,
    _OVRLTRADECMPLNCEMBARGOSTATUS,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _OVTRDCMPLNCSNCTNDLISTCHKSTS,
    _PRICELISTTYPE,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESDISTRICT,
    _SALESDOCAPPROVALSTATUS,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORDERAPPROVALREASON,
    _SALESORDERTYPE,
    _SALESORGANIZATION,
    _SDDOCUMENTREASON,
    _SDPRICINGPROCEDURE,
    _SHIPPINGCONDITION,
    _SHIPPINGTYPE,
    _SOLDTOPARTY,
    _SOLUTIONORDER,
    _TAXDEPARTURECOUNTRY,
    _TOTALBLOCKSTATUS,
    _TOTALCREDITCHECKSTATUS,
    _TRANSACTIONCURRENCY,
    _VATREGISTRATIONCOUNTRY,
    ACCOUNTINGDOCEXTERNALREFERENCE,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ASSIGNMENTREFERENCE,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    BILLINGPLAN,
    BUSINESSSOLUTIONORDER,
    COMPLETEDELIVERYISDEFINED,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREDITCONTROLAREA,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERCREDITACCOUNT,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERTYPE,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DELIVERYBLOCKREASON,
    DELIVERYDATETYPERULE,
    DISTRIBUTIONCHANNEL,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDVALUEDATE,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    ISEUTRIANGULARDEAL,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MEANSOFTRANSPORTREFMATERIAL,
    MEANSOFTRANSPORTTYPE,
    ORDERCOMBINATIONISALLOWED,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLCHMLCMPLNCSTATUS,
    OVERALLDANGEROUSGOODSSTATUS,
    OVERALLDELIVERYBLOCKSTATUS,
    OVERALLDELIVERYSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSAFETYDATASHEETSTATUS,
    OVERALLSDDOCREFERENCESTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTRDCMPLNCEMBARGOSTS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PAYMENTMETHOD,
    PRICELISTTYPE,
    PRICINGDATE,
    PROPOSEDBILLINGDOCUMENTTYPE,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    RECEIVINGPOINT,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REQUESTEDDELIVERYDATE,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERAPPROVALREASON,
    SALESORDERDATE,
    SALESORDERDOWNPAYMENTSTATUS,
    SALESORDERPROCESSINGTYPE,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SERVICESRENDEREDDATE,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SLSDOCISRLVTFORPROOFOFDELIV,
    SOLDTOPARTY,
    SPECIALPROCESSINGCODE,
    TAXDEPARTURECOUNTRY,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (PAYMENTPLAN, SALESORDER)
);