SAP EHSBS_OTPT_RECO_SDA_DA Specification Data: Composition Table data and field list

EHSBS_OTPT_RECO_SDA_DA 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 "Specification Data: Composition" 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_EHSBS_OTPT_RECO_SDA_DA TYPE EHSBS_OTPT_RECO_SDA_DA.

The EHSBS_OTPT_RECO_SDA_DA table consists of various fields, each holding specific information or linking keys about Specification Data: Composition data available in SAP. These include STOFF (Substance), IDENT1 (First Substance Identifier), IDENT2 (Second Substance Identifier), REM (Note)... 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. .

EHSBS_OTPT_RECO_SDA_DA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP EHSBS_OTPT_RECO_SDA_DA 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 EHSBS_OTPT_RECO_SDA_DA 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
ENGINE_KEY_COL	Generic Column Key	ESE_GEN_COLKEY	INT4	10			ESD_GEN_COLKEY
STOFF	Substance	ESESUBST	CHAR	12		SPEC1	ESDSUBID
IDENT1	First Substance Identifier	FRMLE_IDENT_1	CHAR	132			TEXT132
IDENT2	Second Substance Identifier	FRMLE_IDENT_2	CHAR	132			TEXT132
REM	Note	ESEREM	CHAR	60			TEXT60
REFSUB	Reference Substance	ESE_REF_SUBST	CHAR	132			ESD_REF_SUBST
SUBID	Specification	ESESUBID	CHAR	12		SPEC1	ESDSUBID	ES0
IDENT	Identifier	ESEIDENT	CHAR	132			TEXT132	ES5
COMPCAT	Component Type	ESECOMPCAT	CHAR	10	Assigned to domain		ESDCOMPCAT
COMPNAM	Desc. for the Component Type	ESECOMPNAM	CHAR	40			TEXT40
PRECL	Operator for Lower Limit	ESEPRECL	CHAR	5			ESDPREC
COMPLOW	Lower Limit of a Component Proportion	ESECOMPLOW	DEC	10(4)			ESDDEC6_4
PRECU	Operator for Upper Limit	ESEPRECU	CHAR	5			ESDPRECU
COMPUPP	Upper limit of a component proportion	ESECOMPUPP	DEC	10(4)			ESDDEC6_4
COMPAVG	Target Value or Actual Value of a Component	ESECOMPAVG	DEC	10(4)			ESDDEC6_4
COMPEXP	Unit for Quantity Specification	ESECOMPEXP	UNIT	3	Assigned to domain	CUNIT	MEINS
COMPEXP6	Unit of Measurement (6)	ESECOMPEXP6	CHAR	6			MEINS6
COMPEXPT	Unit of Measurement (10)	ESECOMPEXPT	CHAR	10			MEINST
COMPEXPL	Unit of Measurement (30)	ESECOMPEXPL	CHAR	30			MEINSL
ORD	Sort Sequence	ESEORD	NUMC	4			NUMC4
COMPEXCVAL	Exception Value of a Component	ESECOMPEXCVAL	CHAR	2	Assigned to domain		ESDCOMPEXCVAL
COMPEXCVALNAM	Description of Exception Value of a Component	ESECOMPEXCVALNAM	CHAR	40			TEXT40

Key field

Non-key field

< EHSBS_OTPT_RECO_SDA - Specification Data EHSBS_OTPT_RECO_SDA_LI - Specification Data: Value Assignments >

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

As EHSBS_OTPT_RECO_SDA_DA 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 EHSBS_OTPT_RECO_SDA_DA as there is no data to select.

How to access SAP table EHSBS_OTPT_RECO_SDA_DA

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

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