I_EHSEnvRptPRTRSubstScenColl

DDL: I_EHSENVRPTPRTRSUBSTSCENCOLL Type: view_entity COMPOSITE Package: EHENV_BO_ENV_REPORT
14 Fields 5 Data Sources

Compl Scenario PRTR data collection

I_EHSEnvRptPRTRSubstScenColl is a Composite CDS View that provides data about "Compl Scenario PRTR data collection" in SAP S/4HANA. It reads from 5 data sources (I_DataCollectionRootBasic, I_DataCollectionSchedule, I_EHSActiveScenDataColl, I_EHSAmountRoot, I_EHSCmplncScenRevsnRlvtToday) and exposes 14 fields with key fields EHSComplianceScenarioRootUUID, EHSComplianceScenActivityUUID, EHSSubjectUUID, EHSAmountUUID, EHSDataClassifierUUID. Part of development package EHENV_BO_ENV_REPORT.

Data Sources (5)

SourceAliasJoin Type
I_DataCollectionRootBasic DataCollectionRootBasic inner
I_DataCollectionSchedule DataCollectionSchedule inner
I_EHSActiveScenDataColl EHSActiveScenDataColl inner
I_EHSAmountRoot EHSAmount inner
I_EHSCmplncScenRevsnRlvtToday EHSCmplncScen from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Compl Scenario PRTR data collection 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
KEY EHSComplianceScenActivityUUID I_DataCollectionRootBasic DataCollectionUUID UUID
KEY EHSSubjectUUID I_DataCollectionRootBasic EHSSubjectUUID Subject Ref Key
KEY EHSAmountUUID I_EHSAmountRoot EHSAmountUUID NodeID
KEY EHSDataClassifierUUID EHSDataClassifier EHSDataClassifierUUID Data Classifier
EHSSubjectType I_DataCollectionRootBasic 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_EHSEnvRptPRTRSubstScenColl.
-- 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_EHSEnvRptPRTRSubstScenColl AS
SELECT
  EHSCmplncScen.EHSComplianceScenarioRootUUID AS EHSComplianceScenarioRootUUID,
  DataCollectionRootBasic.DataCollectionUUID AS EHSComplianceScenActivityUUID,
  DataCollectionRootBasic.EHSSubjectUUID AS EHSSubjectUUID,
  EHSAmount.EHSAmountUUID AS EHSAmountUUID,
  EHSDataClassifier.EHSDataClassifierUUID AS EHSDataClassifierUUID,
  DataCollectionRootBasic.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_EHSActiveScenDataColl AS EHSActiveScenDataColl ON /* join condition not captured in parsed metadata */
INNER JOIN I_DataCollectionRootBasic AS DataCollectionRootBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_DataCollectionSchedule AS DataCollectionSchedule ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSAmountRoot AS EHSAmount ON /* join condition not captured in parsed metadata */
;

Learn More