SAP ABAP Data Dictionary Tables

SAP ABAP Data Dictionary Tables

Find below a list of SAP ABAP Data Dictionary Tables.

  

Table Name	Short text
DD01L	Domains
DD01T	R/3 DD: domain texts
DD02ALL	Table Parameters for ALLBASE
DD02DB2	DB2/390: Table Parameters
DD02DB6	Table Parameters for DB2 Version 2
DD02INF	Table Parameters for INFORMIX, Version 6
DD02L	SAP tables
DD02MSS	Table Parameters for Microsoft SQL Server
DD02ORA	Table parameters for ORACLE, version 6
DD02SYB	Storage Parameters for Tables in SYBASE
DD02T	R/3 DD: SAP table texts
DD03L	Table Fields
DD03T	DD: Texts for fields (language dependent)
DD04L	Data elements
DD04T	R/3 DD: Data element texts
DD05S	Foreign key fields
DD06L	Pool/cluster structures
DD06T	R/3 DD: texts on SQL tables
DD07L	R/3 DD: values for the domains
DD07T	DD: Texts for Domain Fixed Values (Language-Dependent)
DD08L	R/3 DD: relationship definitions
DD08T	Texts on the relationship definitions
DD09C	ABAP/4: Sytem-dependent attributes of tech. settings
DD09L	DD: Technical settings of tables
DD10L	Lock table for DD activation
DD12DB2	DB2/390: Index Parameters
DD12DB6	Index Parameters for DB2 Universal Database Version 2
DD12INF	Index parameter for INFORMIX
DD12L	R/3 S_SECINDEX: secondary indexes, header;
DD12MSS	Index Parameters for MS SQL Server
DD12ORA	Index Parameters for ORACLE
DD12SYB	Index Parameters for SYBASE System_10
DD12T	Text Table for DD12L (Short Descriptions of Sec. Indexes)
DD14S	R/3 DD: components of SAP objects
DD15L	R/3 DD: SAP objects
DD15T	R/3 DD: texts on SAP objects
DD16S	R/3 DD: SQL table fields
DD17S	R/3 S_SECINDEX: secondary indexes, fields
DD20L	Matchcode objects
DD20T	AS400-T_MCOBJECT: MC Object Texts
DD21S	S-MCIDTABLE: Tables for a MC ID
DD23L	Matchcode ID
DD23T	AS400_L-MCID: Matchcode ID Texts
DD24S	Fields of a matchcode ID
DD25L	Aggregate Header (Views, MC Objects, Lock Objects)
DD25T	Short Texts for Views and Lock Objects
DD26S	Base tables and foreign key relationships for a view
DD27S	Fields in an Aggregate (View, MC Object, Lock Object)
DD28S	Lines of a selection condition
DD29L	Selection Condition for Views and MC IDs
DD29T	AS400_L-SELCOND: Selection Condition Texts
DD30L	Search helps
DD30T	Search help texts
DD31S	Assignment of search helps to collective search helps
DD32S	Search Help Parameter
DD33S	Assignment of search help fields
DD35L	Search help attachments to structures: Headers
DD36S	Parameter-field assignments for search help attachment
DD40L	Table types (internal tables defined in DD)
DD40T	Text on table types
DD42S	Key fields for table types (internal tab. defined in DD)
DD90L	Header Information for External Index
DD90T	R/3-DD: Text for External Index
DD91S	DocID Key Definition of External Index
DD92S	Mapping of R/3 Data on External Index
DD93S	Attribute of an External Index
DD94S	Languages of an Index Category
DD96S	Synchronization Tables
DD97S	Statements for Trigger and Stored Procedures
DDACL	Exclusion times for ABAP/4 Dictionary actions
DDALIAS	DD: Second name for accessing tables
DDART	DD: Data Class in Technical Settings
DDBUF	DD: For transferring the new buffering parameters
DDCDIM	DD: Conversion, number of table lines
DDCNVEXIT	DD: External conversion methods
DDCNVSTAT	DD: Statistical Data for Conversion
DDCNVTABL	DD: Contains incr. conv. tables depend. on release/component
DDCNVTIMES	DD: Exclusion times for conversion
DDCNVUSR	DD: Exception table of converter
DDCPRO	DD: Conversion projects
DDCPROT	DD: Text on conversion projects
DDCPROTAB	DD: Table for conversion projects
DDCQUEUE	DD: Queue for CNV Operations
DDCSTA	DD: Conversion, number of table lines
DDCSTAT	DD: Statistics table for conversions
DDDTRENUPG	DD: Table for Renaming Data Elements During Upgrade
DDF4PSINDX	Contains Information for Personalizing the F4 Help
DDFTX	Run-time object with Screen Painter texts
DDFTX*
DDFTX2
DDFTX3
DDFTX4
DDFTX5
DDFTX6
DDFTX7
DDFTX8
DDFTX9
DDICNVCTRL	Control String for Transaction ICNV
DDICNVDAYS	DD: Days of Week
DDICNVDIST	Distribution of data records of base tables
DDICNVLST	Contains information on converter exits
DDLBBUFTST	Test: Recognize Access to Buffered Tables
DDLOADD	R3load-data table for migration
DDLOADH	R3load-header table for migration
DDPAMSCTRL	DD: Controls Parallel Handling during Mass Activation
DDPART	DD: Partitioned form of TBATG
DDPATH	DD: Definition of access paths
DDPRH	R/3 DD: Log header
DDPROF	DD: Settings for DDIC programs
DDPRS	R/3 DD: log lines
DDPRTUVAR	User settings for printing DD objects
DDSERVPERF	DD: Performance Key Figures of Server for Par. Execution
DDSHDEFSH	Default value - search help per user and collective s.h.
DDSHENTITY	Table of data elements which need the value table help
DDSHHVALUE	Historic Help Values
DDSHLPVERS	Current Version of Search Help Activator
DDSHPVALUE	Personal Help Values
DDSPAR	Storage clause for tables and indexes
DDSPAR1	Storage clause for tables and indexes
DDSPAR2	Storage clause for tables and indexes
DDSTATHIST	DD: Statistical Data for Conversion
DDSTORAGE	Storage clause for tables and indexes
DDSTORAGE1	Storage clause for tables and indexes
DDSTORAGE2	Storage clause for tables and indexes
DDSYN	Parameters for Buffer Synchronization
DDTYPES	Table of all Dictionary types and classes
DDTYPET	ABAP/4 Dictionary: Texts for type groups
DDVE1	Value Table for Domain DDVERINT4
DDVEPR	Check Table with Two Key Fields
DDXTF	Nametab field structure for delayed writing
DDXTT	Nametab header structure for delayed writing
DDYTF	Substitution Nametab (shadow-shadow-nametab for DDXTF)
DDYTT	Substitution Nametab (shadow-shadow-nametab for DDXTT)

SAP ABAP COMPUTE ADD COLLECT and APPEND

SAP ABAP COMPUTE ADD COLLECT and APPEND

COMPUTE The COMPUTE statement is used to assign the result of the mathematical statement to a variable. The use of COMPUTE statement is optional. Please examine the following program.

Data: d_result type i,
          d_num1 type i,
          d_num2 type i.


COMPUTE d_result = d_num1 + d_num2.

is the same as

d_result = d_num1 + d_num2.

 

Note: If you want to add 2 numbers then it can also be done as follows in SAP ABAP. 

add d_num1 to d_num2.

In this case the result is stored in d_num2.

---

COLLECT To Sum up the entries in the internal table you can use the COLLECT statement. The syntax is as shown below.

COLLECT wa INTO itab.

 

Please note that when using COLLECT you should ensure that all the fields that are not a part of the table key  should be numeric. This means that fields that are not part of the table key should be either f,i or p.

Example

DATA: BEGIN OF d_collect,
        key(5) TYPE c,
        num1(2) TYPE n,
        num2    TYPE i,
      END OF d_collect.

DATA itab LIKE STANDARD TABLE OF d_collect.

d_collect-key = 'First'.

d_collect-num1 = '20'.

d_collect-num2 = '30'.

 

COLLECT d_collect into itab.

 

d_collect-key = 'First'.

d_collect-num1 = '20'.

d_collect-num2 = '15'.

 

COLLECT d_collect into itab.

 

d_collect-key = 'Second'.

d_collect-num1 = '20'.

d_collect-num2 = '15'.

COLLECT d_collect into itab.

 

The result is as follows. 

After first collect

First

20

30

>>>>>

First

20

30

After Second Collect

First

20

15

>>>>>

First

20

45

After Third Collect

		Second	20	15	>>>>>	First	20	45
						Second	20	15

Please make a not that the first and the third COLLECT statements act as insertion statements and they just append the row to the table.

---

APPEND

The APPEND statement will just insert lines in the internal table. See the example given below.

Example:

DATA: BEGIN OF d_append,
        key(5) TYPE c,
        num1(2) TYPE n,
        num2    TYPE i,
            END OF d_append.

 

DATA itab LIKE STANDARD TABLE OF d_append.

 

d_append-key = 'First'.

d_append-num1 = '20'.

d_append-num2 = '30'.

 

APPEND d_append to itab.

 

d_append-key = 'First'.

d_append-num1 = '20'.

d_append-num2 = '15'.

 

APPEND d_append to itab.

 

d_append-key = 'Second'.

d_append-num1 = '20'.

d_append-num2 = '15'.

APPEND d_append to itab.

After first APPEND

First

20

30

>>>>>

First

20

30

After Second APPEND

		First	20	15	>>>>>	First	20	30
						First	20	15

After Third Collect

		Second	20	15	>>>>>	First	20	30
						First	20	15
						Second	20	15

---