I_EHSLocAggrgnEmtdSubst

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_EHSLocAggrgnEmtdSubst.
-- 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.
-- SQL view name: ILOCAGGREMITSUBS
-- Parameters: P_Language : lang, P_EHSSubjectType : ehfnd_amns_subj_type, P_UnitOfMeasure : ehfnd_unit_code, P_EHSComplianceScenUsagePeriod : ehenv_usage_period, P_EHSAmountSourceType : ehfnd_amns_src_type

CREATE VIEW I_EHSLocAggrgnEmtdSubst AS
SELECT
  emsu_dset.EHSEmittedSubstDataSetUUID AS EHSEmittedSubstDataSetUUID,
  emsu_dset.EHSEmittedSubstanceUUID AS EHSEmittedSubstanceUUID,
  emsu_root.EHSLocationUUID AS EHSLocationUUID,
  emsu_dset.EHSEmittedSubstDataSetTitle AS EHSEmittedSubstDataSetTitle,
  emsu_root.EHSSubjectUUID AS EHSSubjectUUID,
  scen_root.EHSComplianceScenarioRootUUID AS EHSComplianceScenarioRootUUID,
  scen_name.EHSComplianceScenarioName AS EHSComplianceScenarioName,
  cast( scen_root.EHSComplianceScenarioStatus as char2 preserving type ) AS EHSComplianceScenarioStatus,
  cast( scen_root.EHSComplianceScenarioTypeCode as char2 preserving type ) AS EHSComplianceScenarioTypeCode,
  $parameters.P_EHSAmountSourceType AS EHSAmountSourceType
FROM I_EHSEmittedSubstanceDataSet AS emsu_dset
INNER JOIN I_EHSEmittedSubstance AS emsu_root ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSCmplncScenEmittedSubst AS scen_emsu ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSCmplncScenRoot AS scen_root ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSCmplncScenName AS scen_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSEmittedSubstClassifier AS emsu_acla ON emsu_acla.EHSDataClassifierUUID = $parameters.P_EHSDataClassifierUUID AND emsu_acla.EHSEmittedSubstanceUUID = emsu_root.EHSEmittedSubstanceUUID AND emsu_acla.EHSEmittedSubstDataSetUUID = emsu_dset.EHSEmittedSubstDataSetUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplncScenNameFllbckLang AS scen_name ON scen_root.EHSComplianceScenarioRootUUID = scen_name.EHSComplianceScenarioRootUUID  -- association [0..1]
;