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