SAP Sales and Distribution (SD) Tables
Table | Description | Module |
---|---|---|
SCEKB | Runtime Version of SCE Knowledge Base | SD |
SCEMAT | Materials | SD |
SCECNT | Control Knowledge (Tasks and Events) | SD |
SCEDEP | Dependencies (Basic Data) | SD |
TVROPT | SD - Report Optimization | SD |
SCENUM | Numeric Characteristics | SD |
SCECUCO | Interface Design - Sequence of Characteristics in a Group | SD |
IDFITYP | Tax Type: Possible Entries | SD |
SCECUHD | Interface Design - Header Data | SD |
IPCDEST | meters for Destinations" | SD |
SCEKBTX | Language-Dependent Description for SCE Knowledge Base | SD |
SCETASK | Tasks (SCE) | SD |
SCECUSD | Interface Design - Grouping Structure | SD |
SCEPROF | Profile of Knowledge Base (Starting Point of Configuration) | SD |
SCECLVTX | Lang.-Dependent Descs of Vals of Alphanum. Chars of Classes | SD |
SCEKBOBJ | Knowledge-Base Object (SCE) | SD |
SCECLVAL | Values Assigned to Characteristics of a Class | SD |
SCECHATX | Language-Dependent Description of Characteristic | SD |
SCECNTTX | Language-Dependent Descriptions of Control Knowledge | SD |
SCEOCLTX | Language-Dependent Descriptions of OO Classes | SD |
SCEDESCR | Language-Dependent Descriptions of KB Object/Task/Event | SD |
SCEDEPTX | Language-Dependent Descriptions for Dependencies | SD |
SCEVALTX | Language-Dependent Descriptions of Values of Alphanum. Chars | SD |
SCECUSDT | Interface Design - Description of Groupings | SD |
SCESUPER | Class Hierarchy of Knowledge Base | SD |
IDFITYPT | Tax Type: Texts for Possible Entries | SD |
SCEEVENT | Events (SCE) | SD |
SCEVALSYM | Symbol Table for Characteristic Values | SD |
SCEDEPVAR | Variables of Dependencies | SD |
SCEDOCKEY | Storage Location of Document Key | SD |
SCEDEPSRC | Source Code of Dependency | SD |
SCEDOCOBJ | Link Between Documents and Objects | SD |
SCEDEPSPN | SPNs of Dependency | SD |
SCEHASCHA | Characteristics of OO Class | SD |
SCEHASDEC | Assignment of Decomposition to OO Class | SD |
ZZDEA_MST | Drug Enforcement Administration (DEA) | SD |
ZIFPORDER | Purchase Order Header | SD |
SCEVARVAL | Values in Variant Tables | SD |
SCEVACOND | Assignment of Variant Condition to Char. Value in SCE KB | SD |
SCETABFUN | Value Assignment Alternatives for Variant Table and Functs | SD |
SCESTRING | Alphanumeric Characteristics | SD |
SCESTRDOM | Allowed Values for Alphanumeric Characteristics | SD |
SCEPRTDEP | Assignment of Dependencies to Components (of BOM) | SD |
SCEPROFTX | Language-Dependent Description of Knowledge-Base Profile | SD |
SCEOCLASS | OO Classes of SCE Knowledge Base | SD |
SCENUMDOM | Allowed Values of Numeric Characteristic | SD |
SCELNGTXT | Storage Location for Long Texts | SD |
SCEKMTDEP | Assignment: Dependencies for Configurable Materials | SD |
SCEINVIEW | Allocation of Characteristic of Class to Org. Area | SD |
SCEHASPRT | Components of Decomposition (BOM and so on) | SD |
ZZDEA_QTY | DEA quantity limits per customer and material | SD |
SCEDEPPAT | Pattern of Dependency | SD |
SCEDEPDOC | Documentation for Dependencies | SD |
SCECHAPOS | Position of Characteristic in Class | SD |
SCECHAINP | No User Entry for Characteristic of Class | SD |
SCECHADEP | Assignment: Classic Dependencies to Chars of Classes | SD |
IDCN_VOID | Void Reasons | SD |
IDCN_BOMA | Books for Prenumbered Documents | SD |
IDCN_DOTY | Country-Specific Document Classes | SD |
IDCN_EXCP | Errors for Prenumbered Documents | SD |
IDCN_LOMA | Lots for Prenumbered Documents | SD |
SCEVALDEP | Assignment of Dependencies to Char. Values of Classes | SD |
SCECHARAC | Characteristics | SD |
SCECHAREF | Reference of Reference Characteristic | SD |
SCECHAVIS | Characteristic of Class Hidden/Shown | SD |
SCEDEPDNN | DNNs of Dependency | SD |
SCEDEPCOM | Compilation of Dependency Nets | SD |
SCEDECOMP | Decomposition (BOM and so on) | SD |
SCECONFPR | Configuration Profiles | SD |
SCECNTDEP | Assignment of Dependencies to Control Knowledge | SD |
SCECLSDOM | Allowed Values of Alphanumeric Characteristic of Class | SD |
SCECLACOM | Compilation for Classic Dependencies | SD |
SCECLNDOM | Allowed Values for Numeric Characteristic of Class | SD |
SCECLPREC | Precedence List for OO Classes | SD |
SCEPROFILE | Knowledge-Base Profiles (SCE) | SD |
IDCN_DOTYT | Country-Specific Document Classes - Texts | SD |
IPM_RAWREC | Due Pre-List for Product Sales | SD |
IDCN_VOIDT | Void Reasons - Texts | SD |
IDCN_BOMAT | Books for Prenumbered Documents - Texts | SD |
IDCN_LOMAT | Lots for Prenumbered Documents - Texts | SD |
IDCN_ODN_TR | Prenumbered ODN for multiple print pages | SD |
IPM_VAL_MAP | Assignment Table for Generic Value Mapping | SD |
ZZDEA_SCHED | DEA Drug Schedules | SD |
ZIFPORDERPOS | Purchase Order Items | SD |
ZQUIZ_MASTER | Quiz Table | SD |
J_1USEXTRACTH | EXTRACTH | SD |
IDCNTRY_CHECK | Country specific checks | SD |
IPM_ATTR_MAP1 | Assignment Table for Generic Attribute Mapping | SD |
J_1USEXTRACTD | EXTRACTD | SD |
IDVKBUR_BUPLA | Assignment of Business Place to Sales Office | SD |
IPM_ATTR_MAP2 | Assignment Table for Generic Attribute Mapping | SD |
ZZDEA_MAT_SCHD | DEA Schedule of Material | SD |
ZZDEA_BUS_TYPE | DEA Business Activity Codes | SD |
IDCNTRY_CHECK_V | Country-specific check values | SD |
IPM_TRANSFER_STA | Keeps track of the transfer status of billing items | SD |
CMSC_RFC_DES_QUE | CMS Table for storing RFC destination & que no range | SD |
J_1USEXTRACTD_MM | EXTRACTD_MM | SD |
SAP Master Data Tables
Tcode | Description | Module |
---|---|---|
A011 | Country/Country of Dest./Customer Classif./Material Classif. | SD-MD |
A010 | Additional Selling Plant/Material | SD-MD |
A009 | Additional Selling Plant/EAN | SD-MD |
A008 | Plant/Additional selling plant | SD-MD |
A007 | Division/Customer | SD-MD |
A006 | Price List Type/Currency/Material | SD-MD |
A005 | Customer/Material | SD-MD |
A004 | Material | SD-MD |
A003 | Tax Classification | SD-MD |
A002 | Country/Customer Classification/Material Classification | SD-MD |
Full List of SAP Master Data Tables
SAP Basic Functions Tables
Tcode | Description | Module |
---|---|---|
NACH | Detailed output data | SD-BF |
KNVH | Customer Hierarchies | SD-BF |
QTVB | Product Allocation: Allocation used by Customer Order | SD-BF |
QTCH | Product Allocation: Feature Directory | SD-BF |
B200 | Overall Status - Credit Check | SD-BF |
B024 | Shipping point | SD-BF |
KNMT | Customer-Material Info Record Data Table | SD-BF |
FPLT | Billing Plan: Dates | SD-BF |
T190 | Product Allocation: Controlling | SD-BF |
T180 | Screen Sequence Control: Transaction Default Values | SD-BF |
Full List of SAP Basic Functions Tables
SAP Sales Tables
Tcode | Description | Module |
---|---|---|
B090 | SEPA Mandate - Payment Method | SD-SLS |
TPVH | Product Proposal: Definition of Source Indicator | SD-SLS |
TPVD | Product Proposal: Definition of Customer Procedure | SD-SLS |
T184 | Sales Documents: Item Category Determination | SD-SLS |
TCSP | Cross-Selling Profile: Definition | SD-SLS |
T476 | Parameterization of the Configuration Editor | SD-SLS |
T176 | Sales Documents: Customer Order Types | SD-SLS |
S467 | Indirect Order Update | SD-SLS |
T663 | Delivery interval:Sched.agreements for component suppliers | SD-SLS |
TPRG | Date display format | SD-SLS |
Full List of SAP Sales Tables
SAP Foreign Trade Tables
Tcode | Description | Module |
---|---|---|
A330 | Preferential Cust.Duties: Imp.ctry/Orig.ctry/Ship.ctry/Matl | SD-FT |
A326 | Pharm. Products Duty Rate: Import Country/Code/Pharma. Code | SD-FT |
A325 | Duties Pharma. Products: Import country/Code/CAS/Material | SD-FT |
A321 | Third Country Duty Rate: Import Country/Code | SD-FT |
A320 | Third country Duties: Import ctry/Code/Orig.ctry/Ship.ctry | SD-FT |
A317 | Anti-dumping Duty Rate: Imp.Cntry/Code Number/Cntry of Orig. | SD-FT |
A316 | Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.Ctry/Anti-d. Code | SD-FT |
A315 | Cust.Duty Anti-dumping: Import/Code/Orig.ctry/Manu./Exp./Mat | SD-FT |
A310 | Duty Rate Customs Exemption: Importing Ctry/Code/Material | SD-FT |
A301 | Info Record Type and Incoterms | SD-FT |
Full List of SAP Foreign Trade Tables
SAP Billing Tables
Tcode | Description | Module |
---|---|---|
A144 | Sales Deal Basic Data | SD-BIL |
S473 | Pendulum List - Requisitioner | SD-BIL |
S071 | Condition Update | SD-BIL |
KNVI | Customer Master Tax Indicator | SD-BIL |
A399 | Withholding tax code - country-specific | SD-BIL |
A149 | Customer-dependent data determination | SD-BIL |
A148 | Product Hierarchy | SD-BIL |
A147 | Customer Hierarchy (Sales Deal) | SD-BIL |
A146 | Customer Hierarchy | SD-BIL |
A145 | Sales Deal - Customer/Material | SD-BIL |
Full List of SAP Billing Tables
SAP Sales Support Tables
Tcode | Description | Module |
---|---|---|
TVC4 | Sales Activity Outcome Analysis | SD-CAS |
TKSF | Value Table: Statistics Grp for Sls Activ. Procg in Header | SD-CAS |
TVCB | Sales Activity Description 02 | SD-CAS |
TVC5 | Sales Activities: Allowed Statuses by Status Group | SD-CAS |
TVC2 | Reasons for Sales Activities | SD-CAS |
TVCA | Sales Activity Description 01 | SD-CAS |
TVC3 | Sales Activity Status | SD-CAS |
TVC6 | Sales Activity Status Groups | SD-CAS |
TVC7 | Sales Activities: Assigning Outcome Analysis to Act.Reason | SD-CAS |
TVC1 | Sales Activity Outcome | SD-CAS |
Full List of SAP Sales Support Tables
SAP Information System Tables
Tcode | Description | Module |
---|---|---|
S135 | Value contract, target/release order value | SD-IS |
TVSG | Sales Statistics Groups | SD-IS |
S020 | SIS: Customer Potential Analysis | SD-IS |
S131 | Doc. Payment Guarantee: Update Letter of Credit Values (LIS) | SD-IS |
S264 | SD- Offer | SD-IS |
TKSFK | Update Sequence: Sales Activity Processing Statistics: Headr | SD-IS |
TVSFP | Update Group: Statistics (Item) | SD-IS |
TVSFK | Update Group: Statistics (Header) | SD-IS |
S020E | S020 - Structure Information | SD-IS |
TMCW2 | Administrative Data for SIS Re-Setup | SD-IS |
Full List of SAP Information System Tables
SAP Electronic Data Interchange Tables
Tcode | Description | Module |
---|---|---|
EDPAR | Convert External < > Internal Partner Number | SD-EDI |
EDPST | Translation table EDI Int. Doc. <--> SD item categories | SD-EDI |
EDPVW | Partner Functions Allowed for EDI | SD-EDI |
EDSDC | Assignment of EDI Partner by Sales Org., Distrib.Ch.,Div. | SD-EDI |
PRICAT_007 | PRICAT: Template for Non-ERP Fields to Unit of Measure | SD-EDI |
PRICAT_006 | PRICAT: Template for Non-ERP Fields to Catalog Item | SD-EDI |
PRICAT_005 | PRICAT: ID for Supply of Data to Catalog per Material | SD-EDI |
PRICAT_004 | PRICAT: ID for Supply of Data to Catalog per Material Group | SD-EDI |
PRICAT_003 | PRICAT inbound: Assignment of SAP mat. group - purch. group | SD-EDI |
PRICAT_002 | PRICAT inbound: Assignment of ILN mat. group - SAP mat. grp | SD-EDI |
Full List of SAP Electronic Data Interchange Tables
SAP POS Interface Tables
Tcode | Description | Module |
---|---|---|
A134 | Vendor | SD-POS |
C007 | Vendor | SD-POS |
WVFB | DRS Interface, Intermediate Buffer, Order Item FM | SD-POS |
TWPIB | Transaction-type-based control of sales as per receipts POS | SD-POS |
TWPFI | POS outbound profile | SD-POS |
TWPEK | POS outbound: Condition types | SD-POS |
TWPDZ | Assignment of credit card institute to customer | SD-POS |
WVFB2 | SRS: received external requirement numbers/phys. inv. nos | SD-POS |
TWPBR | Definition of the Check Rules for POS Upload | SD-POS |
TWPIF | Transaction type-dependent control of POS financial trans. | SD-POS |
Full List of SAP POS Interface Tables
Related Articles for SAP Sales and Distribution Table
- What is SAP? Definition of ERP SAP Software Systems
- SAP QM Tutorial – SAP Quality Management (QM) Training Tutorials
- SAP SD Tutorial – Sales & Distribution (SAP SD) Module Training
- SAP FICO Tutorial – SAP FI & SAP CO Training Tutorials
- SAP PM Tutorial – SAP Plant Maintenance Training Tutorials
- What is SAP PS (Project Systems) Module
- SAP Modules – Complete List of ERP SAP R/3 Modules
- How to Maintain Credit Limit for Customers in SAP
- Create Customer Master Record in SAP (Customer Master Data)
- Setup Partner Determination Procedure in SAP SD