SAP Activation Program, Conversion Program, DB Utility, MC, SPDD Tables
Are you looking for the right table related to SAP Activation Program, Conversion Program, DB Utility, MC, SPDD 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 Activation Program, Conversion Program, DB Utility, MC, SPDD (BC-DWB-DIC-AC) module.
Top 10 tables in Activation Program, Conversion Program, DB Utility, MC, SPDD
| Table | Description |
|---|---|
| MACID | Run-time Object "Matchcode ID" |
| DGKAT | DD: Size category in technical settings |
| TPOTB | Table parameters for ORACLE |
| TAPPL | R/3-DDIC: Application classes |
| DSTCL | Control Table for Distribution Program Running Parallel |
| TPTSP | Tablespace parameters for DB2 |
| TCNVCAUSE | DD: Information on Reason for Conversion |
| SLC_MAP_COLUMN | DDIC + LM: View Layer, Mapping of Columns |
| TMCOG | Selection of MC Object IDs for Setting Up Again |
| GEN_EXCEPTION | Sharing exception list for generation attribute |
List of tables in Activation Program, Conversion Program, DB Utility, MC, SPDD
| Table | Description |
|---|---|
| MACID | Run-time Object "Matchcode ID" |
| DGKAT | DD: Size category in technical settings |
| TPOTB | Table parameters for ORACLE |
| TAPPL | R/3-DDIC: Application classes |
| DSTCL | Control Table for Distribution Program Running Parallel |
| TPTSP | Tablespace parameters for DB2 |
| TCNVCAUSE | DD: Information on Reason for Conversion |
| SLC_MAP_COLUMN | DDIC + LM: View Layer, Mapping of Columns |
| TMCOG | Selection of MC Object IDs for Setting Up Again |
| GEN_EXCEPTION | Sharing exception list for generation attribute |
| TMCOL | Root Table Keys for Asynchronous MC Set-Up |
| UKRTB | Course Participation (Results) |
| TPROT | Table contains all DD tables to be logged |
| DTLIDOKCR | Set of conflicts for renaming the links to data elem. docu. |
| TRJOB | Job ID for Coordinating Batch-ABAP/UNIX for Transports |
| DDSPAR1 | Storage clause for tables and indexes |
| TDDAT | Maintenance Areas for Tables |
| TSORA | Table of valid ORACLE tablespaces |
| DTELDOKI | sddo |
| UTCMP | Verification Table for Decider in DD_DECIDE |
| DDSPAR2 | Storage clause for tables and indexes |
| DD27S | Fields in an Aggregate (View, MC Object, Lock Object) |
| DDSQLSCT | Texts for SQL Scripts |
| DD23T | AS400_L-MCID: Matchcode ID Texts |
| TATAF | Program for implementing ADD FIELDS |
| UBEKL | Salary Classes for Non-Academic Employees |
| USTUD | Students |
| T100A | Message IDs for T100 |
| DD43L | Secondary Key for Table Types |
| DDANNOLOAD_PROPT | Settings for annotation calculations |
| DDANNOLOAD | Calculated annotations for CDS entities |
| DD43T | Text Table for DD43L (Secondary Key for Table Types) |
| DDPRTUVAR | User settings for printing DD objects |
| DDPAMSCTRL | DD: Controls Parallel Handling during Mass Activation |
| DDSPAR | Storage clause for tables and indexes |
| DD23L | Matchcode ID |
| IGORA | Table category -> index storage parameters for ORACLE V6 |
| T100 | Messages |
| DD07L | R/3 DD: values for the domains |
| MCUSREXITS | User exits in the matchcode area |
| UBURO | Office Workplaces for Non-Academic Employees |
| DDBUF | DD: For transferring the new buffering parameters |
| DDDBFEATURES | DD: Transfer Structure for DB-Specific Features |
| DDDBSTMTHD | DD: Information on DB Statements |
| BGPROT | DB utility log |
| DCIMPDD | DD: Handle actions following DD import |
| SYSTABSTMT | Contains SQL Statements for Change of Nametab |
| DDOT4OPS | Supported Object Types for MT Separation Using GENFLAG |
| DDTPOOLCNV | DD: Names of tablepools to convert |
| DDPRS | R/3 DD: log lines |
| TMAGE | Table for mass activator |
| IGINF | Assignment of INFORMIX Storage Params to Table Categories |
| TATAF_S | DD: For statement editing |
| DBDIFFINDX | DD: Additional Info on DBDIFF-KEY and INDX Entries |
| DBDIFFINFO | Further Info on DBDIFF (Differences between DD and DB) |
| SLC_SQL_STMTS | DDIC objects lifecycle: SQL statements |
| DCGENTB4LOG | DD: activated objects in an activation run |
| TMCDF | Assignment Table for Default Matchcodes |
| MACOB | Run-Time Object "Matchcode Object" |
| DD25L | Aggregate Header (Views, MC Objects, Lock Objects) |
| DTELPROT | sddo |
| TAORA | Current ORACLE tablespaces |
| DDPROPERTIES | DD: General Properties |
| DD03T | DD: Texts for fields (language dependent) |
| DD25T | Short Texts for Views and Lock Objects |
| DD40T | Text on table types |
| DDPATH | DD: Definition of access paths |
| TBATG | Control table for batch table conversion |
| DDPART | DD: Partitioned form of TBATG |
| DD07T | DD: Texts for Domain Fixed Values (Language-Dependent) |
| DD28S | Lines of a selection condition |
| DD29T | AS400_L-SELCOND: Selection Condition Texts |
| GWFEODE | Test with fields or DE |
| DD12T | Text Table for DD12L (Short Descriptions of Sec. Indexes) |
| DDFTX | Run-time object with Screen Painter texts |
| DDSTORAGE | Storage clause for tables and indexes |
| DDPRH | R/3 DD: Log header |
| UPROF | Professors |
| DD04L | Data elements |
| DD08T | Texts on the relationship definitions |
| D010INC | Where-Used Table for ABAP INCLUDEs |
| DDNTLANG | DD: RADNTLANG Exception Tables |
| IAINF | Current INFORMIX Database Spaces |
| DD29L | Selection Condition for Views and MC IDs |
| DD12INF | Index parameter for INFORMIX |
| CDSREPSHA | CDS Repair: DDL object validation hash |
| DDNTDONE | DD: For restart in nametab generation with Include |
| TACOB | Table for activating DD objects |
| DDSTORAGE1 | Storage clause for tables and indexes |
| TCNVDBCONFIG | Parameter for table conversion |
| DDMIMETYPES | Mime Types (for Full-Text Index) |
| T100X | Error Messages: Supplements |
| DD02T | SAP DD: SAP Table Texts |
| DCSTACK4LOG | DD: Mass Activtion ABAP stack |
| DD14S | R/3 DD: components of SAP objects |
| DD40L | Table types (internal tables defined in DD) |
| DDANNOLOAD_DEP | Dependent entities of annotation calculations |
| DTELRENAME | sddo |
| DBDCGENTB | DD: Persisting Activating Ojects in Mass Activation |
| DCMASS4LOG | DD: Mass Activation dependency header |
| UKURS | Courses |
| TSYNC | Synchronization table for Dictionary - Processes |
| TACO1 | Table for activating DD objects |
| TXBUF | DDTMP: Tables with Authorization, but without Buffering |
| DDACL | Exclusion times for ABAP/4 Dictionary actions |
| SLC_MAP_TABLE | DDIC + LM: View Layer, Mapping of Tables |
| DDCNVEXIT | DD: External conversion methods |
| DBPROPERTIES | Database Installation Properties |
| DDTYPES | Table of all Dictionary types and classes |
| HOKRU_TTAB | SAP Object |
| DD09C | ABAP/4: Sytem-dependent attributes of tech. settings |
| DD17S | R/3 S_SECINDEX: secondary indexes, fields |
| DD05S | Foreign key fields |
| DDTENANTKEYS | DD Multi-Tenancy: Mixed table customer key range |
| DD09L | DD: Technical settings of tables |
| DD20T | AS400-T_MCOBJECT: MC Object Texts |
| DD02L | SAP Tables |
| CDSREPHDR | CDS Repair: Header details |
| DDDBFEATUREST | DD: DDDBFEATURES texts (not used) |
| DD20L | Matchcode objects |
| TADBM | Table Activation Program: Allowed Database Modifications |
| TSPDD | Table, Old SAP Version |
| TMCIR | Table Contains Run-Time Values for MC IDs Processed Asynchr. |
| MCDEFID | Default matchcode Ids per user |
| TDATS | R/3 DD: Control for Generating Data Interfaces |
| D010TAB | Table for Use Report<->Tables |
| DDPROF | DD: Settings for DDIC programs |
| DD03L | Table Fields |
| DD42S | Key fields for table types (internal tab. defined in DD) |
| DD08L | R/3 DD: relationship definitions |
| UKRST | Course Enrollment (Results) |
| CDSREPRESULT | CDS Repair: Results |
| DDART | DD: Data Class in Technical Settings |
| TSPDD2 | Table, Old SAP Version |
| TCNVDATA | Additional Information about Conversion |
| DDXTT | Nametab header structure for delayed writing |
| DD21S | S-MCIDTABLE: Tables for a MC ID |
| DBDCDEPTB | DD: Persisting of Dependencies Between DD Objects |
| DTELLINKS | sddo |
| UPERS | People at the university |
| UFACH | Faculties |
| DD10L | Lock table for DD activation |
| DTLIDOKI | Docu index for renaming the links to data element docu. |
| UNAMA | Non-academic employees |
| DD24S | Fields of a matchcode ID |
| T100U | Last person to change messages |
| TCNV | Conversion Table for Logging the Conversion Steps |
| DDSERVPERF | DD: Performance Key Figures of Server for Par. Execution |
| DD26S | Base tables and foreign key relationships for a view |
| VSYNC | Control Table for Distribution Program Running Parallel |
| TPIND | Index parameters for DB2 |
| DBDIFF | Definition of (Intended) Differences Between DD and DB |
| DDXTF | Nametab Field Structure for Delayed Writing |
| TRESE | Reserved Names |
| DCDEPTB4LOG | DD: Dependencies for an activation run (key log) |
| TSRCG | List of tables from which source coding is generated |
| DD15T | R/3 DD: texts on SAP objects |
| DDDBFUNC | DD: Creation/Transport of Database Functions |
| DARTT | DD: Data Class in Technical Settings: Texts |
| DD01T | R/3 DD: domain texts |
| DD12L | R/3 S_SECINDEX: secondary indexes, header; |
| TGORA | Assigning ORACLE Storage Parameters to Table Categories |
| DDSTORAGE2 | Storage clause for tables and indexes |
| SLC_MAP_INDEX | DDIC + LM: View Layer, Mapping of Columns |
| DDMIMETYPES_T | Mime Types (for Full-Text Index) |
| TDUMY | Dummy table for READ VERSION |
| IAORA | Table category -> index storage parameters for ORACLE V6 |
| DDDBSTMTPAR | DD: Parameters for Generation of Database Statements |
| DD04T | R/3 DD: Data element texts |
| TPTAB | Table parameters for DB2 |
| UKRSB | Course Descriptions |
| DD01L | Domains |
| DD15L | R/3 DD: SAP objects |
| DDDBSTMTS | DD: Statements for CDS Objects and Functions |
| T100_I | Text Verticalization: Delta Table for T100 |