EHENVD_SDEF_HEAD

Transparent Table Application Table
16 Fields 8 CDS Views

Sampling Definiton - Header - Database Table

EHENVD_SDEF_HEAD is an SAP database table in S/4HANA. Sampling Definiton - Header - Database Table. It contains 16 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Ehenv_Amns_All_Loc_Filter view inner Amounts for all locations filter
Ehenv_Amns_At_Loc_Filter view inner Amounts for location and sublocations filter
Ehenv_Cdef_Amns_All view inner All CDEFs for Amounts
Ehenv_Cdef_Amns_All_P view inner All CDEFs for Amounts with parameter
Ehenv_Sdef_Amns view inner Sampling Amounts
Ehenv_Sdef_Amns_At_Location view inner Sampling Amounts at Location
I_EHSActivityTitle view union BASIC EHS Activity Title
I_SamplingHeader view from BASIC Sampling Definition - Header

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_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
title EHENV_SDEF_NAME Sampling Name
title_normed EHFND_DESCRIPTION_L Description (L)
chem_property EHFND_CHEM_PROPERTY_CODE Chem. Property
analyte_type EHFND_AMNS_SUBJ_TYPE Subject Type
analyte_key EHFND_SBJ_KEY_REF_TXT Subject
unit EHFND_UNIT_CODE Unit of Measurement
desc_key_ref /BOBF/CONF_KEY NodeID
id EHENV_SDEF_HEADER_ID Samp. Def. Header ID
eew_sdef_header_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.

-- Sampling Definiton - Header - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_SDEF_HEAD (
    MANDT,              -- Client [MANDT]
    DB_KEY,             -- NodeID [/BOBF/CONF_KEY]
    PARENT_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]
    TITLE,              -- Sampling Name [EHENV_SDEF_NAME]
    TITLE_NORMED,       -- Description (L) [EHFND_DESCRIPTION_L]
    CHEM_PROPERTY,      -- Chem. Property [EHFND_CHEM_PROPERTY_CODE]
    ANALYTE_TYPE,       -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    ANALYTE_KEY,        -- Subject [EHFND_SBJ_KEY_REF_TXT]
    UNIT,               -- Unit of Measurement [EHFND_UNIT_CODE]
    DESC_KEY_REF,       -- NodeID [/BOBF/CONF_KEY]
    ID,                 -- Samp. Def. Header ID [EHENV_SDEF_HEADER_ID]
    EEW_SDEF_HEADER_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More