EHFNDD_SPLNG

Transparent Table Application Table
20 Fields 1 CDS Views

Sampling - #GENERATED#

EHFNDD_SPLNG is an SAP database table in S/4HANA. Sampling - #GENERATED#. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Ehhss_Sampling_Samples view inner Samples of a sampling

Fields (20)

KeyField Data ElementDescription DomainTypeLength
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
id EHFND_SPLNG_ID Sampling ID
method_ref EHFND_SAMPLING_METHOD_REF Sampling Method
technician EHFND_SPLNG_TECHNICIAN_ID Responsible
status EHFND_BO_STATUS_TRANSACT_CODE BO Status
planned_date EHFND_SPLNG_PLANNED_DATE Planned Date
sample_count EHFND_SPLNG_SAMPLE_COUNT Number of Samples
atf_key /BOBF/CONF_KEY NodeID
remark_text_key_ref /BOBF/CONF_KEY NodeID
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
ehsm_component EHFND_EHSM_COMPONENT Component
processing_phase EHFND_SAMPLE_STATUS Sample Status
completion_date EHFND_TIME_STAMP Timestamp
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
eew_splng_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.

-- Sampling - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_SPLNG (
    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]
    ID,                   -- Sampling ID [EHFND_SPLNG_ID]
    METHOD_REF,           -- Sampling Method [EHFND_SAMPLING_METHOD_REF]
    TECHNICIAN,           -- Responsible [EHFND_SPLNG_TECHNICIAN_ID]
    STATUS,               -- BO Status [EHFND_BO_STATUS_TRANSACT_CODE]
    PLANNED_DATE,         -- Planned Date [EHFND_SPLNG_PLANNED_DATE]
    SAMPLE_COUNT,         -- Number of Samples [EHFND_SPLNG_SAMPLE_COUNT]
    ATF_KEY,              -- NodeID [/BOBF/CONF_KEY]
    REMARK_TEXT_KEY_REF,  -- NodeID [/BOBF/CONF_KEY]
    LOC_ROOT_KEY_REF,     -- Location [EHFND_LOCATION_KEY_REF]
    EHSM_COMPONENT,       -- Component [EHFND_EHSM_COMPONENT]
    PROCESSING_PHASE,     -- Sample Status [EHFND_SAMPLE_STATUS]
    COMPLETION_DATE,      -- Timestamp [EHFND_TIME_STAMP]
    ARCHIVING_STATUS,     -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    EEW_SPLNG_ROOT_D,     -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More