EHHSSD_IAC_ROOT SAP (Action - Root) Table details

Dictionary Type: Table
Description: Action - Root




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




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

EHHSSD_IAC_ROOT is a standard SAP Table which is used to store Action - Root data and is available within R/3 SAP systems depending on the version and release level.

The EHHSSD_IAC_ROOT table consists of various fields, each holding specific information or linking keys about Action - Root data available in SAP. These include DB_KEY (NodeID), DATETIME_CR (Date/Time of Item Creation), USER_ID_CR (Object Created By), DATETIME_CH (Date/Time of Item Change).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EHHSSD_IAC_ROOT table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
DB_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
DATETIME_CRDate/Time of Item Creation /BOBF/DATETIME_CRDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CRObject Created By /BOBF/USER_ID_CRCHAR12UNAMEUSER_COMP
DATETIME_CHDate/Time of Item Change /BOBF/DATETIME_CHDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CHObject Changed By /BOBF/USER_ID_CHCHAR12UNAME
BO_KEY_REFBO Reference – Definition Key of the Business Object EHFND_BO_REF_BO_DEF_KEYRAW16/BOBF/CONF_KEY
ROOT_KEY_REFBO Reference – Instance Key of the ROOT Node EHFND_BO_REF_ROOT_INST_KEYRAW16/BOBF/CONF_KEY
NODE_KEY_REFBO Reference – Definition Key of the Subnode EHFND_BO_REF_NODE_DEF_KEYRAW16/BOBF/CONF_KEY
KEY_REFBO Reference – Instance Key of the Subnode EHFND_BO_REF_NODE_INST_KEYRAW16/BOBF/CONF_KEY
PC_BO_KEY_REFPCBO Reference – Definition Key of the Process Control BO EHFND_PCBO_REF_BO_DEF_KEYRAW16/BOBF/CONF_KEY
PC_ROOT_KEY_REFPCBO Reference – Instance Key of the ROOT Node EHFND_PCBO_REF_ROOT_INST_KEYRAW16/BOBF/CONF_KEY
DEF_ROOT_KEY_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
IDID EHFND_ACT_IDCHAR20ALPHAEHFND_BO_ID
EHSM_COMPONENTComponent of EHS Management EHFND_EHSM_COMPONENTCHAR5EHFND_EHSM_COMPONENT
PURPOSEProcess Purpose EHFND_PURPOSECHAR23Assigned to domainEHFND_PURPOSE
VARIANTName of Process Variant EHFND_WFF_VARIANTCHAR30EHFND_WFF_VARIANT
STATUSStatus EHFND_ACT_STATUS_CODECHAR2DFVALEHFND_BO_STATUS_TRANSACT_CODE
TITLETitle EHFND_ACT_TITLECHAR60EHFND_DESCRIPTION_S
SUBJECTSubtype EHFND_ACT_SUBJECT_CODECHAR21Assigned to domainEHASUEHFND_ACT_SUBJECT_CODEEHFND_ELM_ACT_SUBJECT_CODE
CATEGORYCategory EHFND_ACT_CATEGORY_CODECHAR3EHFND_ACT_CATEGORY_CODE
TYPEType EHFND_ACT_TYPE_CODECHAR21Assigned to domainEHACTEHFND_ACT_TYPE_CODEEHFND_ELM_ACT_TYPE_CODE
PRIORITYPriority EHFND_ACT_PRIORITY_CODENUMC1EHFND_ACT_PRIORITY
PROT_GOALProtection Goal EHFND_ACT_PROT_GOAL_CODECHAR21Assigned to domainEHAPGEHFND_ACT_PROT_GOAL_CODEEHFND_ELM_ACT_PROT_GOAL_CODE
EFFECTIVEffectiveness EHFND_ACT_EFFECTIV_CODECHAR21Assigned to domainEHACEEHFND_ACT_EFFECTIV_CODEEHFND_ELM_ACT_EFFECTIV_CODE
EA_ST_TIMESTAMPStart date (UTC) EHFND_START_TIME_STAMPDEC15TSTLC/BOBF/TIMESTAMP
EA_ST_TI_ZOTime Zone of Earliest Start Date EHFND_ACT_EA_START_TI_ZOCHAR6Assigned to domainTZNZONE
DUE_TIMESTAMPDue date (UTC) EHFND_DUE_TIME_STAMPDEC15TSTLC/BOBF/TIMESTAMP
DUE_TI_ZOTime Zone for Due Date EHFND_ACT_DUE_TI_ZOCHAR6Assigned to domainTZNZONEVTTZZ
DUE_N_THDue Date Range EHFND_ACT_DUE_N_THINT410EHFND_INTEGER_POSITIVE
DUE_TYPEDue Type EHFND_ACT_DUE_TYPECHAR3EHFND_ACT_DUE_TYPE
RESP_IDResponsible EHFND_ACT_RESP_IDCHAR13RESIDEHFND_ACT_RESP_ID
IMPLEM_IDImplementor EHFND_ACT_IMPLEM_IDCHAR13IMPIDEHFND_ACT_IMPLEM_ID
APPR_IDApprover EHFND_ACT_APPROVER_IDCHAR13APRIDEHFND_ACT_APPROVER_ID
IMPL_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
IMPL_TI_ZOTime Zone of Implementation EHFND_ACT_IMPL_TI_ZOCHAR6Assigned to domainTZNZONE
APPR_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
APPR_TI_ZOTime Zone of Approval EHFND_ACT_APPROVER_TI_ZOCHAR6Assigned to domainTZNZONE
PLANT_IDPlant ID EHFND_PLANT_IDCHAR4Assigned to domainWERKSEHFND_CMP_PLANT_ID
FUNC_LOC_IDFunctional Location ID EHFND_FUNCT_LOC_IDCHAR30EHFLOEHFND_FUNCT_LOC_IDEHFND_ELM_FL_ID
EQU_IDEquipment EHFND_EQU_IDCHAR18Assigned to domainALPHAEQUNREHFND_ELM_EQU_ID
EQU_TYPEEquipment Type EHFND_EQU_TYPE_CODE_VALUECHAR10EHFND_EQU_TYPE_CODEEHFND_ELM_EQU_TYPE_CODE
WF_EXIST_INDProcess (Workflow) Exists EHFND_ACT_WF_EXIST_INDCHAR1EHFND_INDICATOR
EXT_NOTIF_IDNotification ID EHFND_EXT_NOTIF_IDCHAR12ALPHAEHFND_EXT_NOTIF_ID
EXT_NOTIF_TYPENotification Type EHFND_EXT_NOTIF_TYPE_CODECHAR2Assigned to domainQMART
EXT_NOTIF_PRIONotification Priority EHFND_EXT_NOTIF_PRIORITYCHAR1Assigned to domainPRIOK
MAT_IDMaterial EHFND_MAT_IDCHAR18Assigned to domainMATN1MATNREHFND_CMP_MAT_ID
PROC_SETUP_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
DESC_KEY_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
ACT_NATURE_TSAction Nature Ternary EHFND_ACT_NAT_TSCHAR1EHFND_ACT_NAT_TRI_STATE
MIGRATION_SRCMigration Source EHFND_ACT_MIGRATION_SOURCECHAR60EHFND_ACT_MIGRATION_SOURCE
CH_REQ_TYPEChange Request Type EHFND_CH_REQ_TYPECHAR3EHFND_CH_REQ_TYPEEHFND_ELM_MOC_CR_TYPE
CH_REQ_IMPACTChange Request Impact EHFND_CH_REQ_IMPACTCHAR2EHFND_CH_REQ_IMPACT
CH_REQ_PRIORITYChange Request Priority EHFND_CH_REQ_PRIORITYCHAR1EHFND_CH_REQ_PRIORITY
CH_REQ_LIFETIMEChange Request Lifetime EHFND_CH_REQ_LIFETIMECHAR3EHFND_CH_REQ_LIFETIME
CH_REQ_IDChange Request ID EHFND_CH_REQ_IDCHAR20ALPHAEHFND_CH_REQ_ID
CH_REQ_REP_IDChange Request Reporter EHFND_CH_REQ_REPORTERCHAR10REPIDEHFND_CH_REQ_REPORTEREHFND_ELM_MOC_BP
REQUESTER_IDAction Requester EHFND_ACT_REQUESTER_IDCHAR13EHFND_ACT_REQUESTER_ID
EEW_ACT_ROOT_DDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

SELECT SINGLE *
FROM EHHSSD_IAC_ROOT
INTO CORRESPONDING FIELDS OF WA_EHHSSD_IAC_ROOT
WHERE...

How to access SAP table EHHSSD_IAC_ROOT

Within an ECC or HANA version of SAP you can also view further information about EHHSSD_IAC_ROOT 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!