SAP ECSD_DEF Table for Defining System Data Containers Table data and field list

ECSD_DEF is a standard SAP Table which is used to store Table for Defining System Data Containers data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ECSD_DEF table consists of various fields, each holding specific information or linking keys about Table for Defining System Data Containers data available in SAP. These include FUSER (Created by), FDATE (Created on), FTIME (Created at), FRELEASE (Release of SAP System)... 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. .

ECSD_DEF table Technical Details:

Delivery Class: W - System table, contents transportable via separate TR objects
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ECSD_DEF table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ECSD_DEF table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
NAMEeCATT Object ETOBJ_NAMECHAR30ETOBJ_NAME
FUSERCreated by HIER_FUSERCHAR12HIER_USER
FDATECreated on HIER_FDATEDATS8SYDATS
FTIMECreated at HIER_FTIMETIMS6SYTIME
FRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
LUSERLast changed by HIER_LUSERCHAR12HIER_USER
LDATELast Changed On HIER_LDATEDATS8SYDATS
LTIMETime of Last Change HIER_LTIMETIMS6SYTIME
LRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
TYPEeCATT Object Type (Test Data, Script, Configuration, etc.) ETOBJ_TYPECHAR4ETOBJ_TYPE
TWB_RESPPerson Responsible ET_RESPCHAR35CHAR35
TWB_DISTLTest Case/eCATT Object Attributes: Distribution List TWB_DISTLCHAR1SC_DIST
REUSEeCATT Object Attributes: Reusability ETREUSECHAR1ETREUSE
TWB_EUBOBJTest object TWB_EUNAMECHAR30SEU_NAME
TWB_EUTYPETest object type TWB_EUTYPECHAR1TWB_EUTYPE
SEARCH_1eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_2eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_3eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_4eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_5eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_6eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_7eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_8eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_9eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
SEARCH_10eCatt Object Attributes: Search Term ET_SEARCHCHAR20CHAR20
S_DOC_IDUnique ID for Notes ETNOTE_IDCHAR32SYCHAR32
S_OBJ_IDObject key SWO_TYPEIDCHAR70SWO_TYPEID
S_DOC_TITLShort description of contents SO_OBJ_DESCHAR50SO_OBJ_DES
TOOLNAMEName of Test Tool ETTOOLNAMECHAR40ETTOOLNAME
FRANGEApplication component ID UFPS_POSIDCHAR24UFPS_POSID
MASTER_SOFTCOMPSoftware Component DLVUNITCHAR30Assigned to domainDLVUNITH_CVERS
BCSET_MODEMode for BC Set Usage ETBCSET_MODECHAR1ETBCSET_MODE
API_MODEMode for API Access ETAPI_MODECHAR1ETAPI_MODE
COL_TSTOBJDATACollect Data about Tested Object ET_COLLECT_MDCHAR1
NO_TRANSLATIONPrevent Translation ETNO_TRANSLATIONCHAR1ETNO_TRANSLATION
TWB_TITLETitle TWB_TITLECHAR75HIER_TEXT
USING_TOOLeCATT Test Tool Type (eCATT, TestZone, etc.) ETTESTTOOL_TYPECHAR1ETTESTTOOL_TYPE

Key field Non-key field



How do I retrieve data from SAP table ECSD_DEF using ABAP code

The following ABAP code Example will allow you to do a basic selection on ECSD_DEF to SELECT all data from the table
DATA: WA_ECSD_DEF TYPE ECSD_DEF.

SELECT SINGLE *
FROM ECSD_DEF
INTO CORRESPONDING FIELDS OF WA_ECSD_DEF
WHERE...

How to access SAP table ECSD_DEF

Within an ECC or HANA version of SAP you can also view further information about ECSD_DEF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).