EHFNDD_SPLNG_SPL

Transparent Table Application Table
29 Fields 2 CDS Views

Sample - #GENERATED#

EHFNDD_SPLNG_SPL is an SAP database table in S/4HANA. Sample - #GENERATED#. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Ehhss_Sampling_Samples view from Samples of a sampling
I_EHSSamplingCampaignBlankSmpl view_entity inner BASIC EHS Sampling Campaign Sampling

Fields (29)

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
blank_indicator EHFND_SAMPLE_BLANK_IND Is Blank Sample
blank_type EHFND_SAMPLE_BLANK_TYPE_CODE Blank Sample Type
person_sampled EHFND_SPLNG_SPLD_PERSON_ID Sampled Person
media_id EHFND_SAMPLE_MEDIA_ID Medium ID
equipment_id EHFND_SAMPLE_EQUIP_ID Equipment ID
equipment_calibrated_ind EHFND_SAMPLE_EQUIP_CALIB_IND Equipment Calibrated
flow_rate_start EHFND_SAMPLE_FLOW_RATE_START Initial Flow Rate
flow_rate_end EHFND_SAMPLE_FLOW_RATE_END Final Flow Rate
flow_rate_unit EHFND_SAMPLE_FLOW_RATE_UNIT Flow Rate Unit
start_timestamp EHFND_SAMPLE_START_TSTMP Sample Start
end_timestamp EHFND_SAMPLE_END_TSTMP Sample End
ppe_worn EHFND_CTRL_KEY_REF Control Key
calib_report_key_ref EHFND_SAMPLE_CALIB_REPORT_REF Calibration Report
field_sheet_key_ref EHFND_SAMPLE_FIELD_SHEET_REF Field Sheet
validity EHFND_SAMPLE_VALIDITY Sample Validity
latitude EHFND_GEOLOC_LATITUDE Latitude
longitude EHFND_GEOLOC_LONGITUDE Longitude
id EHFND_SAMPLE_ID Sample ID
shift_pattern EHFND_SHIFT_PATTERN Shift Pattern
substantiation EHFND_SPLNG_SUBSTANTIATION Invalidation Reason
is_reviewed EHFND_SAMPLE_REVIEWED_FLAG Reviewed
eew_splng_sample_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.

-- Sample - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_SPLNG_SPL (
    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]
    BLANK_INDICATOR,           -- Is Blank Sample [EHFND_SAMPLE_BLANK_IND]
    BLANK_TYPE,                -- Blank Sample Type [EHFND_SAMPLE_BLANK_TYPE_CODE]
    PERSON_SAMPLED,            -- Sampled Person [EHFND_SPLNG_SPLD_PERSON_ID]
    MEDIA_ID,                  -- Medium ID [EHFND_SAMPLE_MEDIA_ID]
    EQUIPMENT_ID,              -- Equipment ID [EHFND_SAMPLE_EQUIP_ID]
    EQUIPMENT_CALIBRATED_IND,  -- Equipment Calibrated [EHFND_SAMPLE_EQUIP_CALIB_IND]
    FLOW_RATE_START,           -- Initial Flow Rate [EHFND_SAMPLE_FLOW_RATE_START]
    FLOW_RATE_END,             -- Final Flow Rate [EHFND_SAMPLE_FLOW_RATE_END]
    FLOW_RATE_UNIT,            -- Flow Rate Unit [EHFND_SAMPLE_FLOW_RATE_UNIT]
    START_TIMESTAMP,           -- Sample Start [EHFND_SAMPLE_START_TSTMP]
    END_TIMESTAMP,             -- Sample End [EHFND_SAMPLE_END_TSTMP]
    PPE_WORN,                  -- Control Key [EHFND_CTRL_KEY_REF]
    CALIB_REPORT_KEY_REF,      -- Calibration Report [EHFND_SAMPLE_CALIB_REPORT_REF]
    FIELD_SHEET_KEY_REF,       -- Field Sheet [EHFND_SAMPLE_FIELD_SHEET_REF]
    VALIDITY,                  -- Sample Validity [EHFND_SAMPLE_VALIDITY]
    LATITUDE,                  -- Latitude [EHFND_GEOLOC_LATITUDE]
    LONGITUDE,                 -- Longitude [EHFND_GEOLOC_LONGITUDE]
    ID,                        -- Sample ID [EHFND_SAMPLE_ID]
    SHIFT_PATTERN,             -- Shift Pattern [EHFND_SHIFT_PATTERN]
    SUBSTANTIATION,            -- Invalidation Reason [EHFND_SPLNG_SUBSTANTIATION]
    IS_REVIEWED,               -- Reviewed [EHFND_SAMPLE_REVIEWED_FLAG]
    EEW_SPLNG_SAMPLE_D,        -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More