EHHSS_SAMPLING_SAMPLES

CDS View
37 Fields 3 CDS Views

Samples of a sampling

EHHSS_SAMPLING_SAMPLES is a CDS View in S/4HANA. Samples of a sampling. It contains 37 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Ehhss_Sampling_Campaign_Allres view inner All results of a sampling campaign
Ehhss_Sampling_Highest_Blank view from Highest blank of a sampling
Ehhss_Sampling_Highest_Blank_C view from Highest blank comparator of a sampling

Fields (37)

KeyField CDS FieldsUsed in Views
KEY amount_root_key amount_root_key 1
KEY splng_spl_key splng_spl_key 1
amountcategory amountcategory 1
blank_indicator blank_indicator 1
blank_type blank_type 1
calib_report_key_ref calib_report_key_ref 1
ehsm_component ehsm_component 1
end_timestamp end_timestamp 1
equipment_calibrated_ind equipment_calibrated_ind 1
equipment_id equipment_id 1
field_sheet_key_ref field_sheet_key_ref 1
flow_rate_end flow_rate_end 1
flow_rate_start flow_rate_start 1
flow_rate_unit flow_rate_unit 1
is_reviewed is_reviewed 1
loc_root_key_ref loc_root_key_ref 3
media_id media_id 1
method_ref method_ref 1
outofpreciseness_operator outofpreciseness_operator 1
person_sampled person_sampled 1
planned_date planned_date 1
ppe_worn ppe_worn 1
processing_phase processing_phase 3
sample_count sample_count 1
sample_id sample_id 1
shift_pattern shift_pattern 1
splng_root_key splng_root_key 3
start_timestamp start_timestamp 1
status status 1
subject_root_key_ref subject_root_key_ref 3
subjecttype subjecttype 1
substantiation substantiation 1
technician technician 1
validity validity 1
value value 2
valuetype valuetype 1
valueunit highest_bank_unit,valueunit 3

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.

-- Samples of a sampling
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSS_SAMPLING_SAMPLES (
    AMOUNT_ROOT_KEY,
    SPLNG_SPL_KEY,
    AMOUNTCATEGORY,
    BLANK_INDICATOR,
    BLANK_TYPE,
    CALIB_REPORT_KEY_REF,
    EHSM_COMPONENT,
    END_TIMESTAMP,
    EQUIPMENT_CALIBRATED_IND,
    EQUIPMENT_ID,
    FIELD_SHEET_KEY_REF,
    FLOW_RATE_END,
    FLOW_RATE_START,
    FLOW_RATE_UNIT,
    IS_REVIEWED,
    LOC_ROOT_KEY_REF,
    MEDIA_ID,
    METHOD_REF,
    OUTOFPRECISENESS_OPERATOR,
    PERSON_SAMPLED,
    PLANNED_DATE,
    PPE_WORN,
    PROCESSING_PHASE,
    SAMPLE_COUNT,
    SAMPLE_ID,
    SHIFT_PATTERN,
    SPLNG_ROOT_KEY,
    START_TIMESTAMP,
    STATUS,
    SUBJECT_ROOT_KEY_REF,
    SUBJECTTYPE,
    SUBSTANTIATION,
    TECHNICIAN,
    VALIDITY,
    VALUE,
    VALUETYPE,
    VALUEUNIT,
    PRIMARY KEY (AMOUNT_ROOT_KEY, SPLNG_SPL_KEY)
);

Learn More