I_SALESCONTRACT

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 Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESCONTRACT (
    SALESCONTRACT,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _BILLINGCOMPANYCODE,
    _CENTRALCREDITCHECKSTATUS,
    _CENTRALCREDITCHKTECHERRSTS,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DISTRIBUTIONCHANNEL,
    _DOWNPAYMENTSTATUS,
    _EXPRTINSURCREDITCHECKSTATUS,
    _FINDOCCREDITCHECKSTATUS,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLGINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LASTCHANGEDBYUSER,
    _MAXDOCVALUECREDITCHECKSTATUS,
    _ORGANIZATIONDIVISION,
    _OVERALLBILLINGBLOCKSTATUS,
    _OVERALLCHMLCMPLNCSTATUS,
    _OVERALLDANGEROUSGOODSSTATUS,
    _OVERALLPRICINGINCOMPLETIONSTS,
    _OVERALLSDDOCREFERENCESTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVERALLTOTALSDDOCREFSTATUS,
    _OVRLITMBILLINGINCOMPLETIONSTS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _OVRLSFTYDATASHEETSTS,
    _OVRLTRADECMPLNCEMBARGOSTATUS,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _OVTRDCMPLNCSNCTNDLISTCHKSTS,
    _PAYMENTTERMCREDITCHECKSTATUS,
    _PAYTAUTHSNCREDITCHECKSTS,
    _PRICELISTTYPE,
    _SALESCONTRACTAPPROVALREASON,
    _SALESCONTRACTTYPE,
    _SALESCONTRACTVALIDITYPERDCAT,
    _SALESDISTRICT,
    _SALESDOCAPPROVALSTATUS,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SDDOCUMENTREASON,
    _SDPRICINGPROCEDURE,
    _SHIPPINGCONDITION,
    _SHIPPINGTYPE,
    _STANDARDPARTNER,
    _TAXDEPARTURECOUNTRY,
    _TOTALBLOCKSTATUS,
    _TOTALCREDITCHECKSTATUS,
    _TRANSACTIONCURRENCY,
    _VATREGISTRATIONCOUNTRY,
    ACCOUNTINGDOCEXTERNALREFERENCE,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ASSIGNMENTREFERENCE,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    CENTRALCREDITCHECKSTATUS,
    CENTRALCREDITCHKTECHERRSTS,
    COMPLETEDELIVERYISDEFINED,
    CONTRACTDOWNPAYMENTSTATUS,
    CONTRACTMANUALCOMPLETION,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERSUPLMNT,
    CUSTOMERPURCHASEORDERTYPE,
    DISTRIBUTIONCHANNEL,
    EXPRTINSURCREDITCHECKSTATUS,
    FINDOCCREDITCHECKSTATUS,
    FIXEDVALUEDATE,
    HEADERBILLGINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MAXDOCVALUECREDITCHECKSTATUS,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLCHMLCMPLNCSTATUS,
    OVERALLDANGEROUSGOODSSTATUS,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSAFETYDATASHEETSTATUS,
    OVERALLSDDOCREFERENCESTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALSDDOCREFSTATUS,
    OVERALLTRDCMPLNCEMBARGOSTS,
    OVRLITMBILLINGINCOMPLETIONSTS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    OVRLTRDCMPLNCSNCTNDLISTCHKSTS,
    PAYMENTMETHOD,
    PAYMENTTERMCREDITCHECKSTATUS,
    PAYTAUTHSNCREDITCHECKSTS,
    PRICELISTTYPE,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    SALESCONTRACTDATE,
    SALESCONTRACTTYPE,
    SALESCONTRACTVALIDITYENDDATE,
    SALESCONTRACTVALIDITYPERDCAT,
    SALESCONTRACTVALIDITYSTARTDATE,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SERVICESRENDEREDDATE,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SOLDTOPARTY,
    TAXDEPARTURECOUNTRY,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (SALESCONTRACT)
);