ESTLS SAP Table - field list, table key, data, relationships and ABAP select examples
Dictionary Type: Table
Description: EHS: Report Template Symbol
Description: EHS: Report Template Symbol
EHS: Report Template Symbol data
ESTLS is a standard SAP Table which is used to store EHS: Report Template Symbol data and is available within R/3 SAP systems depending on the version and release level.
The ESTLS table consists of various fields, each holding specific information or linking keys about EHS: Report Template Symbol data available in SAP. These include DOKAR (Document Type), DOKNR (Document number), DOKVR (Document Version), DOKTL (Document Part).. 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. .
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
ESTLS KEY fields - List of fields that make up the full SQL / SAP table key
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| DOKAR | Document Type | DOKAR | CHAR | 3 | TDWA | DOKAR | CV2 | ||
| DOKNR | Document number | DOKNR | CHAR | 25 | ESD_DRAW | ALPHA | DOKNR | CV1 | |
| DOKVR | Document Version | DOKVR | CHAR | 2 | ESD_DRAW | DOKVR | CV3 | ||
| DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
| LDELINE | Line in structure file | ESELDELINE | INT4 | 10 | INT4 |
ESTLS table fields - Full list of fields found in SAP dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| LSYTYPE | Report Symbol Type | ESELSYTYPE | CHAR | 2 | ESDLSYTYPE | ||||
| LSYMOD | Control Mode for Symbol Replacement in Word | ESELSYMOD | CHAR | 3 | CHAR3 | ||||
| LSYLEN | Length of Symbol String | ESELSYLEN | NUMC | 3 | NUMC3 | ||||
| LSYESM | Environment Symbol Editing Mode | ESELSYESM | CHAR | 1 | CHAR1 | ||||
| LSYID | Report Symbol | ESELSYID | CHAR | 10 | TCGA6 | ESDLSYID | |||
| LSYENUM | Enviroment symbol number | ESELSYENUM | CHAR | 3 | CHAR3 | ||||
| LENID | Environment Identifier | ESELENID | CHAR | 10 | TCGB3 | ESDLENID | |||
| LSYRPAR | Expansion Parameters for a Report Symbol | ESELSYRPAR | CHAR | 30 | ESDLSYRPAR | ||||
| LSYRVAL | Expansion Value for a Report Symbol | ESELSYRVAL | CHAR | 30 | CHAR30 | ||||
| LENRGF | Startup index for instance selection in an environment | ESELENRGF | NUMC | 4 | NUMC4 | ||||
| LENRGT | Final index for entity selection in an environment | ESELENRGT | NUMC | 4 | NUMC4 | ||||
| LSYEFLG | Symbol definition incorrect | ESELSYEFLG | CHAR | 1 | ESDFLAG | ||||
| LSYRTIM | Expansion date for a report symbol | ESELSYRTIM | CHAR | 10 | ESDLSYRTIM | ||||
| LMSGFLG | Message Type for Missing Mandatory Report Symbol | ESELMSGFLG | CHAR | 1 | ESDMSGFLG | ||||
| LSEPA | Separator for Multiple-Value Characteristics | ESELSEPA | CHAR | 6 | ESDLSEPA |
| Key field | Non-key field |
How do I retrieve data from SAP table ESTLS using ABAP code
The following ABAP code Example will allow you to do a basic selection on ESTLS to SELECT all data from the tableDATA: WA_ESTLS TYPE ESTLS.
SELECT SINGLE *
FROM ESTLS
INTO CORRESPONDING FIELDS OF WA_ESTLS
WHERE...
How to access SAP table ESTLS
Within an ECC or HANA version of SAP you can also view further information about ESTLS 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