EHHSSD_IRT_ROOT
Report - Root
EHHSSD_IRT_ROOT is an SAP database table in S/4HANA. Report - Root. It contains 20 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IncidentReport | view | from | BASIC | Incident Report |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| datetime_cr | /BOBF/DATETIME_CR | Created On/At | ||||
| user_id_cr | /BOBF/USER_ID_CR | Created By | ||||
| datetime_ch | /BOBF/DATETIME_CH | Changed On/At | ||||
| user_id_ch | /BOBF/USER_ID_CH | Changed By | ||||
| bo_key_ref | EHFND_BO_REF_BO_DEF_KEY | BO Reference – Definition Key of the Business Object | ||||
| root_key_ref | EHFND_BO_REF_ROOT_INST_KEY | BO Reference – Instance Key of the ROOT Node | ||||
| node_key_ref | EHFND_BO_REF_NODE_DEF_KEY | Definition Key | ||||
| key_ref | EHFND_BO_REF_NODE_INST_KEY | BO Reference – Instance Key of the Subnode | ||||
| id | EHFND_RPT_ID | Report ID | ||||
| group_name | EHFND_ADS_AIF_GROUP_NAME | Form Group | ||||
| form_name | EHFND_ADS_AIF_FORM_NAME | Form Name | ||||
| document_id_authority | EHFND_RPT_ID_AUTHORITY | Authority Report ID | ||||
| status | EHFND_RPT_STATUS_CODE | Report Status | ||||
| country | EHFND_RPT_COUNTRY_CODE | Country/Region | ||||
| language | EHFND_RPT_LANGUAGE_CODE | Report Language | ||||
| required_ts | EHFND_RPT_REQUIRED_TS | Rpt Required | ||||
| archiving_status | /BOFU/ARCHIVING_STATUS_CODE | Archiving Stat. | ||||
| eew_rpt_root_d | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Report - Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_IRT_ROOT (
MANDT, -- Client [MANDT]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
DATETIME_CR, -- Created On/At [/BOBF/DATETIME_CR]
USER_ID_CR, -- Created By [/BOBF/USER_ID_CR]
DATETIME_CH, -- Changed On/At [/BOBF/DATETIME_CH]
USER_ID_CH, -- Changed By [/BOBF/USER_ID_CH]
BO_KEY_REF, -- BO Reference – Definition Key of the Business Object [EHFND_BO_REF_BO_DEF_KEY]
ROOT_KEY_REF, -- BO Reference – Instance Key of the ROOT Node [EHFND_BO_REF_ROOT_INST_KEY]
NODE_KEY_REF, -- Definition Key [EHFND_BO_REF_NODE_DEF_KEY]
KEY_REF, -- BO Reference – Instance Key of the Subnode [EHFND_BO_REF_NODE_INST_KEY]
ID, -- Report ID [EHFND_RPT_ID]
GROUP_NAME, -- Form Group [EHFND_ADS_AIF_GROUP_NAME]
FORM_NAME, -- Form Name [EHFND_ADS_AIF_FORM_NAME]
DOCUMENT_ID_AUTHORITY, -- Authority Report ID [EHFND_RPT_ID_AUTHORITY]
STATUS, -- Report Status [EHFND_RPT_STATUS_CODE]
COUNTRY, -- Country/Region [EHFND_RPT_COUNTRY_CODE]
LANGUAGE, -- Report Language [EHFND_RPT_LANGUAGE_CODE]
REQUIRED_TS, -- Rpt Required [EHFND_RPT_REQUIRED_TS]
ARCHIVING_STATUS, -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
EEW_RPT_ROOT_D, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA