SAP ESH_S_JOIN_ATTRIBUTES_LIST List with the attributes from join Table data and field list

ESH_S_JOIN_ATTRIBUTES_LIST is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "List with the attributes from join" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ESH_S_JOIN_ATTRIBUTES_LIST TYPE ESH_S_JOIN_ATTRIBUTES_LIST.

The ESH_S_JOIN_ATTRIBUTES_LIST table consists of various fields, each holding specific information or linking keys about List with the attributes from join data available in SAP. These include NODE_NAME (Node Name), MODEL_NODE_FIELD (Node Field), NODE_FIELD (Node Field), ALIAS (Join attribute 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_S_JOIN_ATTRIBUTES_LIST structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ESH_S_JOIN_ATTRIBUTES_LIST structure 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_S_JOIN_ATTRIBUTES_LIST 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
OBJECT_TYPE	Object Type	ESH_E_OM_OBJECT_TYPE	CHAR	20			ESH_D_OM_OBJECT_TYPE
NODE_NAME	Node Name	ESH_E_OM_NODE_NAME	CHAR	20			ESH_D_OM_NODE_NAME
MODEL_NODE_FIELD	Node Field	ESH_E_OM_NODE_FIELD	CHAR	30	Assigned to domain		FDNAME
NODE_FIELD	Node Field	ESH_E_OM_NODE_FIELD	CHAR	30	Assigned to domain		FDNAME
ALIAS	Join attribute name			0
FIELD_TYPE	Field type			0
AUTH_CHECK	Authorization Check	ESH_E_OM_AUTH_CHECK_32	CHAR	32
INTTYPE	ABAP data type (C,D,N,...)	INTTYPE	CHAR	1			INTTYPE
LENG	Length (No. of Characters)	DDLENG	NUMC	6			DDLENG
DECIMALS	Number of Decimal Places	DECIMALS	NUMC	6			DDLENG
VALUE				0
CONSTRAINT	Update Flag	ESH_E_OM_UPDATE_FLAG	CHAR	1			XFELD
PATH				0
IS_INTERACTIVE_NAV	Is relevant for interactive navigation			0
RANK_WEIGHT	Ranking Weight	ESH_E_OM_RANKING_WEIGHT	INT1	3			ESH_D_OM_RANKING_WEIGHT
RANK_WEIGHT_TREX	Ranking weight (TREX)			0
OBJECT_TYPE_CHECK	Object Type	ESH_E_OM_OBJECT_TYPE	CHAR	20			ESH_D_OM_OBJECT_TYPE
NODE_NAME_CHECK	Node Name	ESH_E_OM_NODE_NAME	CHAR	20			ESH_D_OM_NODE_NAME
HAS_MULTI_NODES	Node check uses data from different nodes			0
NO_FREESTYLE_SEARCH	Flag: No freestyle search	ESH_E_OM_NO_FREESTYLE_SEARCH	CHAR	1			XFELD

Key field

Non-key field

< ESH_S_IX_OBJECT_DATA - Object data for indexing ESH_S_JOIN_PATH_STEP - List with path steps >

How do I retrieve data from SAP structure ESH_S_JOIN_ATTRIBUTES_LIST using ABAP code?

As ESH_S_JOIN_ATTRIBUTES_LIST is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ESH_S_JOIN_ATTRIBUTES_LIST as there is no data to select.

How to access SAP table ESH_S_JOIN_ATTRIBUTES_LIST

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

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