I_EHSCMPLNCSCENREVSNRLVTTODAY

CDS View
5 Fields 4 CDS Views

Compliance Scenario Relevant Revision

I_EHSCMPLNCSCENREVSNRLVTTODAY is a CDS View in S/4HANA. Compliance Scenario Relevant Revision. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_EHSEnvRptPRTRSubstEmsnsDecln view_entity from COMPOSITE EmD Data for PRTR report
I_EHSEnvRptPRTRSubstScenAggrgn view_entity from COMPOSITE Compl Scenario PRTR data aggregation
I_EHSEnvRptPRTRSubstScenCalc view_entity from COMPOSITE Compl Scenario PRTR calculation data
I_EHSEnvRptPRTRSubstScenColl view_entity from COMPOSITE Compl Scenario PRTR data collection

Fields (5)

KeyField CDS FieldsUsed in Views
KEY EHSComplianceScenarioRootUUID EHSComplianceScenarioRootUUID 4
KEY EHSLocationUUID EHSLocationUUID 4
EHSCmplncScenProdnProcTypeCode EHSCmplncScenProdnProcTypeCode 4
EHSComplianceScenarioID EHSComplianceScenarioID 4
EHSComplianceScenarioTypeCode EHSComplianceScenarioTypeCode 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.

-- Compliance Scenario Relevant Revision
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSCMPLNCSCENREVSNRLVTTODAY (
    EHSCOMPLIANCESCENARIOROOTUUID,
    EHSLOCATIONUUID,
    EHSCMPLNCSCENPRODNPROCTYPECODE,
    EHSCOMPLIANCESCENARIOID,
    EHSCOMPLIANCESCENARIOTYPECODE,
    PRIMARY KEY (EHSCOMPLIANCESCENARIOROOTUUID, EHSLOCATIONUUID)
);

Learn More