SAP ESH_HDB_DBSCHEMA Schema Mapping for ESH on Application Tables Scenario Table data and field list

ESH_HDB_DBSCHEMA is a standard SAP Table which is used to store Schema Mapping for ESH on Application Tables Scenario data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_HDB_DBSCHEMA table consists of various fields, each holding specific information or linking keys about Schema Mapping for ESH on Application Tables Scenario data available in SAP. These include LOGSYS (Logical system), SW_COMP_ID (Software Component), OBJECT_TYPE (Object Type), NODE_NAME (Node Name)... 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. .

ESH_HDB_DBSCHEMA table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_HDB_DBSCHEMA 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 ESH_HDB_DBSCHEMA 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
SW_COMP_IDSoftware Component ESH_E_OM_SYSRELCHAR32
OBJECT_TYPEObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
NODE_NAMENode Name ESH_E_OM_NODE_NAMECHAR20ESH_D_OM_NODE_NAME
HDB_DBSCHEMADatabase Schema ESH_E_HDB_DBSCHEMACHAR64ESH_D_HDB_DBSCHEMA
HDB_DBTABNAMEDatabase table name ESH_E_HDB_DBTABNAMECHAR64ESH_D_HDB_DBTABNAME
MOD_USERLast Modification User ESH_E_ADM_BIN_LAST_MOD_USERCHAR12SYCHAR12
MOD_TIMESTAMPESH: Timestamp ESH_E_ADM_TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_HDB_DBSCHEMA
INTO CORRESPONDING FIELDS OF WA_ESH_HDB_DBSCHEMA
WHERE...

How to access SAP table ESH_HDB_DBSCHEMA

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

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