Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

EHHSSS_D_INVESTIGATIONS SAP (BI Investigation Data DS07) Structure details

Dictionary Type: Structure
Description: BI Investigation Data DS07

ABAP Code to SELECT data from EHHSSS_D_INVESTIGATIONS
Related tables to EHHSSS_D_INVESTIGATIONS
Access table EHHSSS_D_INVESTIGATIONS

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

EHHSSS_D_INVESTIGATIONS 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 "BI Investigation Data DS07" 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_EHHSSS_D_INVESTIGATIONS TYPE EHHSSS_D_INVESTIGATIONS.

The EHHSSS_D_INVESTIGATIONS table consists of various fields, each holding specific information or linking keys about BI Investigation Data DS07 data available in SAP. These include INVGUID (NodeID), START_DATE (Investigation Start Date), STATUS (Investigation Status), MAJOR_ROOT_CAUSE (Root Cause).. 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. .

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

SAP EHHSSS_D_INVESTIGATIONS structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
INCIDNT	Incident ID	EHHSS_INC_ID	CHAR	20		ALPHA	EHFND_BO_ID		EHHSS_ELM_INC_ID_SE
INVGUID	NodeID	/BOBF/CONF_KEY	RAW	16			/BOBF/CONF_KEY
START_DATE	Investigation Start Date	EHHSS_INVESTIG_START_DATE	DATS	8		DATLO	EHFND_DATE
STATUS	Investigation Status	EHHSS_INVESTIG_STATUS_CODE	CHAR	2		DFVAL	EHFND_BO_STATUS_TRANSACT_CODE
MAJOR_ROOT_CAUSE	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
INV_LEAD_ID	ID of Investigation Lead	EHHSS_BI_INV_LEAD_ID	CHAR	12
INV_LEAD_GROUP	Group of Investigation Lead	EHHSS_BI_INV_LEAD_GROUP	CHAR	1
INV_LEAD_NAME	Full Name of Investigation Lead	EHHSS_BI_INV_LEAD_NAME	CHAR	60
CONFIDENTIAL_TS	Restricted Access to Investigation	EHHSS_INVESTIG_CONFID_TS	CHAR	1			EHFND_TRI_STATE
END_DATE	Investigation End Date	EHHSS_INVESTIG_END_DATE	DATS	8		DATLO	EHFND_DATE
REQUIRED_TS	Investigation Required	EHHSS_INVESTIG_REQUIRED_TS	CHAR	1			EHFND_TRI_STATE
INV_LEAD_TEL_NUM	Telephone Number of Investigation Lead	EHHSS_INV_LEAD_TEL_NUM	CHAR	30			EHFND_ADDR_PHONE
INV_LEAD_EMAIL	E-Mail Address of Investigation Lead	EHHSS_BI_INV_LEAD_EMAIL	CHAR	60
RCGUID	NodeID	/BOBF/CONF_KEY	RAW	16			/BOBF/CONF_KEY
ROOT_CAUSE_TYPE	Root Cause Type	EHHSS_ROOT_CAUSE_TYPE	CHAR	21			EHHSS_ROOT_CAUSE_TYPE
RCLVL1	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL2	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL3	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL4	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL5	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL6	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL7	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL8	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL9	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
RCLVL10	Root Cause	EHHSS_CAUSE_CODE	CHAR	21	Assigned to domain	EHCAU	EHHSS_CAUSE_CODE
NUMRCAC	Number of Actions	EHHSS_BI_NUMRCAC	INT1	3			INT1
NUMINVA	Number of Investigation Actions	EHHSS_BI_NUMINVA	INT4	10			INT4
SERIAL	Serial Number	EHHSS_BI_SERIAL	INT4	10			INT4
BW_DELTATIMESTMP	BW Delta Time Stamp	EHHSS_BI_BW_DELTA_TIMESTAMP	DEC	15			TZNTSTMPS
BW_RECORDMODE	BW Delta Process: Record Mode	EHHSS_BI_BW_RECORDMODE	CHAR	1			RODMUPDMOD

Key field

Non-key field

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

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

How to access SAP table EHHSSS_D_INVESTIGATIONS

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

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

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!