_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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SALESORDER (
    SALESORDER,
    _BILLINGCOMPANYCODE,
    _BILLINGSTATUS,
    _BUSINESSAREA,
    _CUSTOMERGROUP,
    _DELIVERYSTATUS,
    _DISTRIBUTIONCHANNEL,
    _HEADERBILLINGBLOCKREASON,
    _LIFECYCLESTATUS,
    _ORGANIZATIONDIVISION,
    _OVERALLDELIVERYSTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVERALLSTATUS,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORDERTYPE,
    _SALESORGANIZATION,
    _SOLDTOPARTY,
    _TRANSACTIONCURRENCY,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    BILLINGCOMPANYCODE,
    BUSINESSAREA,
    BUYER_ID,
    CONTRACTDOWNPAYMENTSTATUS,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CREDITCONTROLAREA,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    DELIVERYBLOCKREASON,
    DISTRIBUTIONCHANNEL,
    HDRGENERALINCOMPLETIONSTATUS,
    HEADERBILLGINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    HEADERDELIVINCOMPLETIONSTATUS,
    ID,
    INCOTERMSCLASSIFICATION,
    LASTCHANGEDATE,
    LASTCHANGEDDATETIME,
    LIFECYCLE_STATUS,
    MASTERSALESCONTRACT,
    ORDERID,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLCHMLCMPLNCSTATUS,
    OVERALLDANGEROUSGOODSSTATUS,
    OVERALLDELIVCONFSTATUS,
    OVERALLDELIVERYBLOCKSTATUS,
    OVERALLDELIVERYSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSAFETYDATASHEETSTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    OVERALLTRDCMPLNCEMBARGOSTS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    OVRLTRDCMPLNCSNCTNDLISTCHKSTS,
    PAYMENTMETHOD,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    SALESDOCAPPROVALREASON,
    SALESDOCAPPROVALSTATUS,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERBILLINGSTATUS,
    SALESORDERCONDITION,
    SALESORDERDATE,
    SALESORDERDELIVERYSTATUS,
    SALESORDERID,
    SALESORDERLIFECYCLESTATUS,
    SALESORDERTYPE,
    SALESORDERUUID,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SELLER_ID,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SOLDTOPARTY,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESORDER)
);