SAP ESH_HDB_CONSTR Constraints for Application-Table Based Connector Nodes Table data and field list

ESH_HDB_CONSTR is a standard SAP Table which is used to store Constraints for Application-Table Based Connector Nodes data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_HDB_CONSTR table consists of various fields, each holding specific information or linking keys about Constraints for Application-Table Based Connector Nodes data available in SAP. These include LOGSYS (Logical system), OBJECT_TYPE (Object Type), NODE_NAME (Node Name), CONSTRAINT_KEY (Constraint Key)... 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_CONSTR table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_HDB_CONSTR 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_CONSTR 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
OBJECT_TYPEObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
NODE_NAMENode Name ESH_E_OM_NODE_NAMECHAR20ESH_D_OM_NODE_NAME
CONSTRAINT_KEYConstraint Key ESH_E_HDB_CONSTRAINT_KEYCHAR10
HDB_DBSCHEMADatabase Schema ESH_E_HDB_DBSCHEMACHAR64ESH_D_HDB_DBSCHEMA
HDB_DBTABNAMEDatabase table name ESH_E_HDB_DBTABNAMECHAR64ESH_D_HDB_DBTABNAME
HDB_DBATTRIBUTEDatabase Table Attribute Name ESH_E_HDB_DBATTRIBUTECHAR255ESH_D_HDB_DBATTRIBUTE
OPERATORJoin Operator ESH_E_HDB_OPERATORCHAR2ESH_D_HDB_OPERATOR
CONSTRAINT_VALConstraint Value ESH_E_HDB_CONSTRAINT_VALSTRG0
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_CONSTR using ABAP code

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

SELECT SINGLE *
FROM ESH_HDB_CONSTR
INTO CORRESPONDING FIELDS OF WA_ESH_HDB_CONSTR
WHERE...

How to access SAP table ESH_HDB_CONSTR

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

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