SAP Sales and Distribution Tables
Are you looking for the right table related to SAP Sales and Distribution Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Sales and Distribution (SD) module.
Top 10 tables in Sales and Distribution
| Table | Description |
|---|---|
| SCEKMTDEP | Assignment: Dependencies for Configurable Materials |
| SCEDEPTX | Language-Dependent Descriptions for Dependencies |
| SCENUMDOM | Allowed Values of Numeric Characteristic |
| SCEDEPVAR | Variables of Dependencies |
| SCEKBOBJ | Knowledge-Base Object (SCE) |
| SCETABFUN | Value Assignment Alternatives for Variant Table and Functs |
| SCEVALSYM | Symbol Table for Characteristic Values |
| SCEPRTDEP | Assignment of Dependencies to Components (of BOM) |
| SCEDESCR | Language-Dependent Descriptions of KB Object/Task/Event |
| SCECNTTX | Language-Dependent Descriptions of Control Knowledge |
List of tables in Sales and Distribution
| Table | Description |
|---|---|
| SCEKMTDEP | Assignment: Dependencies for Configurable Materials |
| SCEDEPTX | Language-Dependent Descriptions for Dependencies |
| SCENUMDOM | Allowed Values of Numeric Characteristic |
| SCEDEPVAR | Variables of Dependencies |
| SCEKBOBJ | Knowledge-Base Object (SCE) |
| SCETABFUN | Value Assignment Alternatives for Variant Table and Functs |
| SCEVALSYM | Symbol Table for Characteristic Values |
| SCEPRTDEP | Assignment of Dependencies to Components (of BOM) |
| SCEDESCR | Language-Dependent Descriptions of KB Object/Task/Event |
| SCECNTTX | Language-Dependent Descriptions of Control Knowledge |
| SCECHAPOS | Position of Characteristic in Class |
| SCEDOCKEY | Storage Location of Document Key |
| SCECHATX | Language-Dependent Description of Characteristic |
| SCEKBTX | Language-Dependent Description for SCE Knowledge Base |
| SCEDECOMP | Decomposition (BOM and so on) |
| SCECNTDEP | Assignment of Dependencies to Control Knowledge |
| SCECUCO | Interface Design - Sequence of Characteristics in a Group |
| SCELNGTXT | Storage Location for Long Texts |
| SCECHAINP | No User Entry for Characteristic of Class |
| SCEDEPSPN | SPNs of Dependency |
| SCEHASPRT | Components of Decomposition (BOM and so on) |
| SCEDEPSRC | Source Code of Dependency |
| SCECHADEP | Assignment: Classic Dependencies to Chars of Classes |
| IPM_VAL_MAP | Assignment Table for Generic Value Mapping |
| IPM_TRANSFER_STA | Keeps track of the transfer status of billing items |
| SCEVARVAL | Values in Variant Tables |
| SCECUHD | Interface Design - Header Data |
| SCECUSDT | Interface Design - Description of Groupings |
| TVROPT | SD - Report Optimization |
| SCECLPREC | Precedence List for OO Classes |
| SCEKB | Runtime Version of SCE Knowledge Base |
| SCEDEPCOM | Compilation of Dependency Nets |
| SCEDEPDNN | DNNs of Dependency |
| SCEHASCHA | Characteristics of OO Class |
| SCECHAVIS | Characteristic of Class Hidden/Shown |
| SCENUM | Numeric Characteristics |
| SCEPROFTX | Language-Dependent Description of Knowledge-Base Profile |
| SCEDOCOBJ | Link Between Documents and Objects |
| SCEDEP | Dependencies (Basic Data) |
| SCEPROF | Profile of Knowledge Base (Starting Point of Configuration) |
| SCEEVENT | Events (SCE) |
| SCECHAREF | Reference of Reference Characteristic |
| IPM_RAWREC | Due Pre-List for Product Sales |
| SCEOCLASS | OO Classes of SCE Knowledge Base |
| SCECLACOM | Compilation for Classic Dependencies |
| SCESTRDOM | Allowed Values for Alphanumeric Characteristics |
| SCECLNDOM | Allowed Values for Numeric Characteristic of Class |
| SCESTRING | Alphanumeric Characteristics |
| IPM_ATTR_MAP2 | Assignment Table for Generic Attribute Mapping |
| SCEVALDEP | Assignment of Dependencies to Char. Values of Classes |
| IPM_ATTR_MAP1 | Assignment Table for Generic Attribute Mapping |
| SCECNT | Control Knowledge (Tasks and Events) |
| SCEHASDEC | Assignment of Decomposition to OO Class |
| IPCDEST | IPC Parameters for Destinations |
| SCECLSDOM | Allowed Values of Alphanumeric Characteristic of Class |
| SCEPROFILE | Knowledge-Base Profiles (SCE) |
| SCECLVAL | Values Assigned to Characteristics of a Class |
| SCEDEPDOC | Documentation for Dependencies |
| SCEMAT | Materials |
| CMSC_RFC_DES_QUE | CMS Table for storing RFC destination & que no range |
| SCEINVIEW | Allocation of Characteristic of Class to Org. Area |
| SCECONFPR | Configuration Profiles |
| SCESUPER | Class Hierarchy of Knowledge Base |
| SCETASK | Tasks (SCE) |
| SCEOCLTX | Language-Dependent Descriptions of OO Classes |
| SCECHARAC | Characteristics |
| SCEDEPPAT | Pattern of Dependency |
| SCEVACOND | Assignment of Variant Condition to Char. Value in SCE KB |
| SCECUSD | Interface Design - Grouping Structure |
| SCECLVTX | Lang.-Dependent Descs of Vals of Alphanum. Chars of Classes |
| SCEVALTX | Language-Dependent Descriptions of Values of Alphanum. Chars |