I_EHSEnvRptPRTRSubstScenCalc

DDL: I_EHSENVRPTPRTRSUBSTSCENCALC Type: view_entity COMPOSITE
15 Fields 4 Data Sources

Compl Scenario PRTR calculation data

I_EHSEnvRptPRTRSubstScenCalc is a Composite CDS View that provides data about "Compl Scenario PRTR calculation data" in SAP S/4HANA. It reads from 4 data sources (I_CalcDefResultHeader, I_EHSAmountRoot, I_EHSCmplncScenRevsnRlvtToday, I_EHSCmplncScenCalc) and exposes 15 fields with key fields EHSComplianceScenarioRootUUID, EHSComplianceScenActivityUUID, CalculationResultHeaderUUID, EHSSubjectUUID, EHSAmountUUID.

Data Sources (4)

SourceAliasJoin Type
I_CalcDefResultHeader CalcDefResultHeader inner
I_EHSAmountRoot EHSAmount inner
I_EHSCmplncScenRevsnRlvtToday EHSCmplncScen from
I_EHSCmplncScenCalc EHSCmplncScenCalc inner

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Compl Scenario PRTR calculation data 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 (15)

KeyFieldSource TableSource FieldDescription
KEY EHSComplianceScenarioRootUUID I_EHSCmplncScenRevsnRlvtToday EHSComplianceScenarioRootUUID UUID
KEY EHSComplianceScenActivityUUID I_CalcDefResultHeader CalculationRootUUID UUID
KEY CalculationResultHeaderUUID I_CalcDefResultHeader CalculationResultHeaderUUID UUID
KEY EHSSubjectUUID I_CalcDefResultHeader EHSSubjectUUID Subject Ref Key
KEY EHSAmountUUID I_EHSAmountRoot EHSAmountUUID NodeID
KEY EHSDataClassifierUUID EHSCalcDefRsltHdrClassifier EHSDataClassifierUUID Data Classifier
EHSSubjectType I_CalcDefResultHeader 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_EHSEnvRptPRTRSubstScenCalc.
-- 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_EHSEnvRptPRTRSubstScenCalc AS
SELECT
  EHSCmplncScen.EHSComplianceScenarioRootUUID AS EHSComplianceScenarioRootUUID,
  CalcDefResultHeader.CalculationRootUUID AS EHSComplianceScenActivityUUID,
  CalcDefResultHeader.CalculationResultHeaderUUID AS CalculationResultHeaderUUID,
  CalcDefResultHeader.EHSSubjectUUID AS EHSSubjectUUID,
  EHSAmount.EHSAmountUUID AS EHSAmountUUID,
  EHSCalcDefRsltHdrClassifier.EHSDataClassifierUUID AS EHSDataClassifierUUID,
  CalcDefResultHeader.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_EHSCmplncScenCalc AS EHSCmplncScenCalc ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalcDefResultHeader AS CalcDefResultHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSAmountRoot AS EHSAmount ON /* join condition not captured in parsed metadata */
;

Learn More