I_SLSPRCGCNDNRECDVALIDITY

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.

-- Validity of Condition Record for Pricing in Sales
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSPRCGCNDNRECDVALIDITY (
    ACCOUNTTAXTYPE,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BATCH,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BR_NFDOCUMENTTYPE,
    BR_TAXCODE,
    BRSPCFCFREEDEFINEDFIELD1,
    BRSPCFCFREEDEFINEDFIELD2,
    BRSPCFCFREEDEFINEDFIELD3,
    BRSPCFCTAXBASEPERCENTAGECODE,
    BRSPCFCTAXDEPARTUREREGION,
    BRSPCFCTAXDESTINATIONREGION,
    BRSPCFCTXGRPDYNTAXEXCEPTIONS,
    BUSINESSPARTNERINDUSTRYCODE,
    CITYCODE,
    CNDNBILLINGDOCUMENTCATEGORY,
    COMMODITYCODE,
    CONDITIONCONTRACT,
    CONDITIONISEXCLUSIVE,
    CONDITIONPROCESSINGSTATUS,
    CONDITIONRELEASESTATUS,
    CONDITIONSCALEBASISVALUE,
    CONDITIONVALIDITYENDDATE,
    CONDITIONVALIDITYSTARTDATE,
    CONFIGURATIONNUMBER,
    CONSUMPTIONTAXCTRLCODE,
    COUNTRY,
    COUNTRYOFORIGIN,
    COUNTY,
    CUSTOMER,
    CUSTOMERCONDITIONGROUP,
    CUSTOMERGROUP,
    CUSTOMERHIERARCHY,
    CUSTOMERHIERARCHYNODEID,
    CUSTOMERHIERARCHYNODETYPE,
    CUSTOMERHIERARCHYROOTNODE,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERTYPE,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DEPARTURECOUNTRY,
    DESTINATIONCOUNTRY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTSERVICEORG,
    EQUIPMENT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INDUSTRY,
    INTERNATIONALARTICLENUMBER,
    LOCALSALESTAXAPPLICABILITYCODE,
    MAINITEMMATERIALPRICINGGROUP,
    MAINITEMPRICINGREFMATERIAL,
    MATERIAL,
    MATERIALEXTERNALGROUP,
    MATERIALGROUP,
    MATERIALPRICINGGROUP,
    MATLACCOUNTASSIGNMENTGROUP,
    MATUSAGEINDICATOR,
    ORDERQUANTITYUNIT,
    ORDERTYPE,
    PAYERPARTY,
    PERSONNEL,
    PLANT,
    PLANTCITY,
    PLANTCOUNTY,
    PLANTREGION,
    POSTALCODE,
    PRICELISTTYPE,
    PRICINGDATE,
    PRODUCTHIERARCHYNODE,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PRODUNIVHIERARCHYNODE,
    PURGDOCSUPPLYINGPLANT,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    REGION,
    REQUIREMENTSEGMENT,
    RETURNREASON,
    RETURNSREFUNDEXTENT,
    ROUTE,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERSALESORGANIZATION,
    SALESORGANIZATION,
    SALESSDDOCUMENTCATEGORY,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    SDDOCUMENTREASON,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    SOLDTOPARTY,
    STOCKSEGMENT,
    SUBSCRIPTIONCONTRACTDURATION,
    SUBSCRIPTIONCONTRACTLOCKREASON,
    SUBSCRPNCONTRDURATIONUNIT,
    SUPPLIER,
    TAXCODE,
    TAXJURISDICTION,
    TECHNICALOBJECTTYPE,
    TIMESHEETOVERTIMECATEGORY,
    TRADINGCONTRACT,
    TRADINGCONTRACTITEM,
    TRANSACTIONCURRENCY,
    TXRLVNCECLASSFCTNFORARGENTINA,
    VALUATIONTYPE,
    VALUEADDEDSERVICECHARGECODE,
    VARIANTCONDITION,
    VOLUMEREBATEGROUP,
    WORKITEM
);