EHHSSD_INV_ROOT

Transparent Table Application Table
16 Fields 1 CDS Views

Investigation Root Table

EHHSSD_INV_ROOT is an SAP database table in S/4HANA. Investigation Root Table. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSInvestigation view_entity from BASIC Investigation Basic

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY ehsinvestigationuuid EHHSS_INV_ROOT_KEY Investigation UUID
ehsinvestigationid EHHSS_INV_ID ID
creationdatetime ABP_CREATION_TSTMPL Created On
createdbyuser ABP_CREATION_USER Created By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
ehsinvestigationtypecode EHHSS_INV_TYPE_CODE Type
ehsinvestigationstatus EHHSS_INV_STATUS Status
ehsinvestigationreasontext EHHSS_INV_REASON_T Investigation Reason
ehsinvstgnactualstartdate EHHSS_INV_ACT_START_DATE Start Date
ehsinvestigationplannedenddate EHHSS_INV_PLANNED_END_DATE Planned End Date
ehsinvestigationactualenddate EHHSS_INV_ACT_END_DATE End Date
locallastchangedatetime TIMESTAMPL Time Stamp
ehsinvstgncancelreasontext EHHSS_INV_CANCEL_REASON_T Reason
ehsinvstgnreopenreasontext EHHSS_INV_REOPEN_REASON_T Reason

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.

-- Investigation Root Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_INV_ROOT (
    CLIENT,                          -- Client [MANDT]
    EHSINVESTIGATIONUUID,            -- Investigation UUID [EHHSS_INV_ROOT_KEY]
    EHSINVESTIGATIONID,              -- ID [EHHSS_INV_ID]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    EHSINVESTIGATIONTYPECODE,        -- Type [EHHSS_INV_TYPE_CODE]
    EHSINVESTIGATIONSTATUS,          -- Status [EHHSS_INV_STATUS]
    EHSINVESTIGATIONREASONTEXT,      -- Investigation Reason [EHHSS_INV_REASON_T]
    EHSINVSTGNACTUALSTARTDATE,       -- Start Date [EHHSS_INV_ACT_START_DATE]
    EHSINVESTIGATIONPLANNEDENDDATE,  -- Planned End Date [EHHSS_INV_PLANNED_END_DATE]
    EHSINVESTIGATIONACTUALENDDATE,   -- End Date [EHHSS_INV_ACT_END_DATE]
    LOCALLASTCHANGEDATETIME,         -- Time Stamp [TIMESTAMPL]
    EHSINVSTGNCANCELREASONTEXT,      -- Reason [EHHSS_INV_CANCEL_REASON_T]
    EHSINVSTGNREOPENREASONTEXT,      -- Reason [EHHSS_INV_REOPEN_REASON_T]
    PRIMARY KEY (CLIENT, EHSINVESTIGATIONUUID)
);

Learn More