DD20L SAP (Matchcode objects) Table details
Dictionary Type: Table
Description: Matchcode objects
Description: Matchcode objects
Table field list including key, data, relationships and ABAP select examples
DD20L is a standard SAP Table which is used to store Matchcode objects data and is available within R/3 SAP systems depending on the version and release level.
The DD20L table consists of various fields, each holding specific information or linking keys about Matchcode objects data available in SAP. These include AS4LOCAL (Activation Status of a Repository Object), AS4VERS (Version of the entry (not used)), APPLCLASS (Application class for DD objects (not used)), AUTHCLASS (Activation type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: W - System table, contents transportable via separate TR objectsDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
Text table = DD20T
SAP DD20L table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MCONAME | Name of a matchcode object | MCONAME | CHAR | 10 | MCONAME | DMO | |||
| AS4LOCAL | Activation Status of a Repository Object | AS4LOCAL | CHAR | 1 | AS4LOCAL | ||||
| AS4VERS | Version of the entry (not used) | AS4VERS | NUMC | 4 | AS4VERS | ||||
| APPLCLASS | Application class for DD objects (not used) | APPLCLASS | CHAR | 4 | TAPPL | APPLCLASS | APP | ||
| AUTHCLASS | Activation type | AUTHCLASS_ | NUMC | 2 | AUTHCLASS | ||||
| VIEWNAME | Name of SAP table view | VIEWNAME | CHAR | 30 | Assigned to domain | VIEWNAME | DVI | ||
| ROOTTAB | Primary table of an aggregate | ROOTTAB | CHAR | 30 | Assigned to domain | AS4TAB | |||
| POOL | Pool in which matchcodes of a MC object are stored | MCPOOL | CHAR | 10 | Assigned to domain | SQLTABLE | |||
| AS4USER | Last Changed by | AS4USER | CHAR | 12 | AS4USER | ||||
| AS4DATE | Date of Last Change | AS4DATE | DATS | 8 | AS4DATE | ||||
| AS4TIME | Last changed at | AS4TIME | TIMS | 6 | AS4TIME | ||||
| ACTFLAG | Activation flag | ACTFLAG | CHAR | 1 | ACTFLAG | ||||
| MASTERLANG | Original Language in Repository objects | MASTERLANG | LANG | 1 | T002 | ISOLA | SPRAS | H_T002 |
| Key field | Non-key field |
How do I retrieve data from SAP table DD20L using ABAP code
The following ABAP code Example will allow you to do a basic selection on DD20L to SELECT all data from the tableDATA: WA_DD20L TYPE DD20L.
SELECT SINGLE *
FROM DD20L
INTO CORRESPONDING FIELDS OF WA_DD20L
WHERE...
How to access SAP table DD20L
Within an ECC or HANA version of SAP you can also view further information about DD20L and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects