EHHSS_SAMPLING_CAMPAIGN_ALLRES

CDS View
63 Fields 1 CDS Views

All results of a sampling campaign

EHHSS_SAMPLING_CAMPAIGN_ALLRES is a CDS View in S/4HANA. All results of a sampling campaign. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Ehhss_Sampling_Campaign_Result view from Results of a sampling campaign

Fields (63)

KeyField CDS FieldsUsed in Views
KEY amount_root_key amount_root_key 1
KEY Sampling_Campaign_key Sampling_Campaign_key 1
KEY splng_spl_key splng_spl_key 1
abagt_key_ref abagt_key_ref 1
agent_key_ref agent_key_ref 1
amountcategory amountcategory 1
blank_indicator blank_indicator 1
blank_type blank_type 1
buss_area buss_area 1
calib_report_key_ref calib_report_key_ref 1
cma_key_ref cma_key_ref 1
company_code company_code 1
cost_center cost_center 1
country country 1
ehsm_component ehsm_component 1
end_date end_date 1
end_time end_time 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
highest_bank_operator highest_bank_operator 1
highest_bank_unit highest_bank_unit 1
highest_bank_value highest_bank_value 1
is_reviewed is_reviewed 1
job_key_ref job_key_ref 1
loc_auth_group loc_auth_group 1
loc_name loc_name 1
loc_root_key_ref loc_root_key_ref 1
media_id media_id 1
method_ref method_ref 1
op_status op_status 1
outofpreciseness_operator outofpreciseness_operator 1
person_sampled person_sampled 1
planned_date planned_date 1
plant_id plant_id 1
ppe_worn ppe_worn 1
processing_phase processing_phase 1
region region 1
requested_sample_count requested_sample_count 1
sample_count sample_count 1
sample_date_day sample_date_day 1
sample_date_month sample_date_month 1
sample_date_year sample_date_year 1
sample_id sample_id 1
sampling_method_ref sampling_method_ref 1
shift_pattern shift_pattern 1
splng_root_key splng_root_key 1
start_date start_date 1
start_time start_time 1
start_timestamp start_timestamp 1
status status 1
subject_root_key_ref subject_root_key_ref 1
subjecttype subjecttype 1
substantiation substantiation 1
technician technician 1
validity validity 1
value value 1
valuetype valuetype 1
valueunit valueunit 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.

-- All results of a sampling campaign
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSS_SAMPLING_CAMPAIGN_ALLRES (
    AMOUNT_ROOT_KEY,
    SAMPLING_CAMPAIGN_KEY,
    SPLNG_SPL_KEY,
    ABAGT_KEY_REF,
    AGENT_KEY_REF,
    AMOUNTCATEGORY,
    BLANK_INDICATOR,
    BLANK_TYPE,
    BUSS_AREA,
    CALIB_REPORT_KEY_REF,
    CMA_KEY_REF,
    COMPANY_CODE,
    COST_CENTER,
    COUNTRY,
    EHSM_COMPONENT,
    END_DATE,
    END_TIME,
    END_TIMESTAMP,
    EQUIPMENT_CALIBRATED_IND,
    EQUIPMENT_ID,
    FIELD_SHEET_KEY_REF,
    FLOW_RATE_END,
    FLOW_RATE_START,
    FLOW_RATE_UNIT,
    HIGHEST_BANK_OPERATOR,
    HIGHEST_BANK_UNIT,
    HIGHEST_BANK_VALUE,
    IS_REVIEWED,
    JOB_KEY_REF,
    LOC_AUTH_GROUP,
    LOC_NAME,
    LOC_ROOT_KEY_REF,
    MEDIA_ID,
    METHOD_REF,
    OP_STATUS,
    OUTOFPRECISENESS_OPERATOR,
    PERSON_SAMPLED,
    PLANNED_DATE,
    PLANT_ID,
    PPE_WORN,
    PROCESSING_PHASE,
    REGION,
    REQUESTED_SAMPLE_COUNT,
    SAMPLE_COUNT,
    SAMPLE_DATE_DAY,
    SAMPLE_DATE_MONTH,
    SAMPLE_DATE_YEAR,
    SAMPLE_ID,
    SAMPLING_METHOD_REF,
    SHIFT_PATTERN,
    SPLNG_ROOT_KEY,
    START_DATE,
    START_TIME,
    START_TIMESTAMP,
    STATUS,
    SUBJECT_ROOT_KEY_REF,
    SUBJECTTYPE,
    SUBSTANTIATION,
    TECHNICIAN,
    VALIDITY,
    VALUE,
    VALUETYPE,
    VALUEUNIT,
    PRIMARY KEY (AMOUNT_ROOT_KEY, SAMPLING_CAMPAIGN_KEY, SPLNG_SPL_KEY)
);

Learn More