I_EHSEnvRptPRTRSubstScenAggrgn

DDL: I_EHSENVRPTPRTRSUBSTSCENAGGRGN Type: view_entity COMPOSITE
14 Fields 4 Data Sources

Compl Scenario PRTR data aggregation

I_EHSEnvRptPRTRSubstScenAggrgn is a Composite CDS View that provides data about "Compl Scenario PRTR data aggregation" in SAP S/4HANA. It reads from 4 data sources (I_EHSAmountRoot, I_EHSCmplncScenRevsnRlvtToday, I_EHSCmplncScenLocAggrgn, I_LocAggregationRoot) and exposes 14 fields with key fields EHSComplianceScenarioRootUUID, EHSComplianceScenActivityUUID, EHSSubjectUUID, EHSAmountUUID, EHSDataClassifierUUID.

Data Sources (4)

SourceAliasJoin Type
I_EHSAmountRoot EHSAmount inner
I_EHSCmplncScenRevsnRlvtToday EHSCmplncScen from
I_EHSCmplncScenLocAggrgn EHSCmplncScenAggr inner
I_LocAggregationRoot LocAggregationRoot inner

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Compl Scenario PRTR data aggregation view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EHSComplianceScenarioRootUUID I_EHSCmplncScenRevsnRlvtToday EHSComplianceScenarioRootUUID UUID
KEY EHSComplianceScenActivityUUID I_LocAggregationRoot LocAggregationUUID UUID
KEY EHSSubjectUUID I_LocAggregationRoot EHSSubjectUUID Subject Ref Key
KEY EHSAmountUUID I_EHSAmountRoot EHSAmountUUID NodeID
KEY EHSDataClassifierUUID EHSLocAggrgnClassifier EHSDataClassifierUUID Data Classifier
EHSSubjectType I_LocAggregationRoot EHSSubjectType Subject Type
EHSAmountUTCDateTime I_EHSAmountRoot EHSAmountUTCDateTime Time Stamp
EHSAmountValue
UnitOfMeasure
EHSComplianceScenarioID I_EHSCmplncScenRevsnRlvtToday EHSComplianceScenarioID
EHSDataClassifierID EHSDataClassifier EHSDataClassifierID
EHSLocationUUID I_EHSCmplncScenRevsnRlvtToday EHSLocationUUID NodeID
EHSComplianceScenarioTypeCode I_EHSCmplncScenRevsnRlvtToday EHSComplianceScenarioTypeCode
EHSCmplncScenProdnProcTypeCode I_EHSCmplncScenRevsnRlvtToday EHSCmplncScenProdnProcTypeCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EHSEnvRptPRTRSubstScenAggrgn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EHSEnvRptPRTRSubstScenAggrgn AS
SELECT
  EHSCmplncScen.EHSComplianceScenarioRootUUID AS EHSComplianceScenarioRootUUID,
  LocAggregationRoot.LocAggregationUUID AS EHSComplianceScenActivityUUID,
  LocAggregationRoot.EHSSubjectUUID AS EHSSubjectUUID,
  EHSAmount.EHSAmountUUID AS EHSAmountUUID,
  EHSLocAggrgnClassifier.EHSDataClassifierUUID AS EHSDataClassifierUUID,
  LocAggregationRoot.EHSSubjectType AS EHSSubjectType,
  EHSAmount.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  cast ( EHSAmount.EHSAmountValue as ehfnd_amns_value_nc preserving type ) AS EHSAmountValue,
  cast ( EHSAmount.UnitOfMeasure as ehfnd_unit_code_nce preserving type ) AS UnitOfMeasure,
  EHSCmplncScen.EHSComplianceScenarioID AS EHSComplianceScenarioID,
  EHSDataClassifier.EHSDataClassifierID AS EHSDataClassifierID,
  EHSCmplncScen.EHSLocationUUID AS EHSLocationUUID,
  EHSCmplncScen.EHSComplianceScenarioTypeCode AS EHSComplianceScenarioTypeCode,
  EHSCmplncScen.EHSCmplncScenProdnProcTypeCode AS EHSCmplncScenProdnProcTypeCode
FROM I_EHSCmplncScenRevsnRlvtToday AS EHSCmplncScen
INNER JOIN I_EHSCmplncScenLocAggrgn AS EHSCmplncScenAggr ON /* join condition not captured in parsed metadata */
INNER JOIN I_LocAggregationRoot AS LocAggregationRoot ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSAmountRoot AS EHSAmount ON /* join condition not captured in parsed metadata */
;

Learn More