EHHSS_EXPOSURES_OF_RISKS

CDS View

Risks and assosiated exposures

EHHSS_EXPOSURES_OF_RISKS is a CDS View in S/4HANA. Risks and assosiated exposures. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Ehhss_Expas_Of_Risks_By_Loc view inner Exposure Analysis in Risks by Location

Fields (33)

KeyField CDS FieldsUsed in Views
KEY expas_rev_key expas_rev_key 1
KEY rsk_root_key rsk_root_key 1
abagt_key_ref abagt_key_ref 1
agent_key_ref agent_key_ref 1
analysis_type analysis_type 1
buss_area buss_area 1
cma_key_ref cma_key_ref 1
company_code company_code 1
confid_level confid_level 1
confidence_level_code confidence_level_code 1
cost_center cost_center 1
expas_root_key expas_root_key 1
is_simulated is_simulated 1
job job 1
lisu_root_key_ref lisu_root_key_ref 1
loc_auth_group loc_auth_group 1
loc_name loc_name 1
loc_root_key_ref loc_root_key_ref 1
oel_value oel_value 1
oel_value_unit oel_value_unit 1
op_status_code op_status_code 1
phys_agt_key_ref phys_agt_key_ref 1
phys_expr_const phys_expr_const 1
plant_id plant_id 1
ras_type ras_type 1
rating_code rating_code 1
reglist_key reglist_key 1
revision_date revision_date 1
rsk_rev_key rsk_rev_key 1
shift_pattern shift_pattern 1
source_doc_ref source_doc_ref 1
stadj_value stadj_value 1
stadj_value_unit stadj_value_unit 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.

-- Risks and assosiated exposures
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSS_EXPOSURES_OF_RISKS (
    EXPAS_REV_KEY,
    RSK_ROOT_KEY,
    ABAGT_KEY_REF,
    AGENT_KEY_REF,
    ANALYSIS_TYPE,
    BUSS_AREA,
    CMA_KEY_REF,
    COMPANY_CODE,
    CONFID_LEVEL,
    CONFIDENCE_LEVEL_CODE,
    COST_CENTER,
    EXPAS_ROOT_KEY,
    IS_SIMULATED,
    JOB,
    LISU_ROOT_KEY_REF,
    LOC_AUTH_GROUP,
    LOC_NAME,
    LOC_ROOT_KEY_REF,
    OEL_VALUE,
    OEL_VALUE_UNIT,
    OP_STATUS_CODE,
    PHYS_AGT_KEY_REF,
    PHYS_EXPR_CONST,
    PLANT_ID,
    RAS_TYPE,
    RATING_CODE,
    REGLIST_KEY,
    REVISION_DATE,
    RSK_REV_KEY,
    SHIFT_PATTERN,
    SOURCE_DOC_REF,
    STADJ_VALUE,
    STADJ_VALUE_UNIT,
    PRIMARY KEY (EXPAS_REV_KEY, RSK_ROOT_KEY)
);