R_EHSEmDDataEmittedSubstanceTP

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 R_EHSEmDDataEmittedSubstanceTP.
-- 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 R_EHSEmDDataEmittedSubstanceTP AS
SELECT
  EHSEmDDataSubstanceUUID,
  EHSEmDDataUUID,
  EHSEmittedSubstanceUUID,
  EHSEmittedSubstPhysicalState,
  EHSEmittedSubstDetnType,
  EHSEmDDataEmissionsDetnType,
  EHSEmDDataEmissionsDetnMeth,
  EHSEmtdSubstDetnMethProcedDesc,
  EHSEmittedSubstanceComment,
  EHSEmittedSubstConcnUUID,
  _Concentration.EHSAmountValue AS EHSEmittedSubstConcnQuantity,
  _Concentration.EHSAmountIsMissing AS EHSEmittedSubstConcnIsMissing,
  cast(_Concentration.UnitOfMeasure as ehenv_emis_emsub_concn_unit preserving type ) AS EHSEmittedSubstConcnUnit,
  EHSEmittedSubstMassFlowUUID,
  _MassFlow.EHSAmountValue AS EHSEmittedSubstMassFlowQty,
  _MassFlow.EHSAmountIsMissing AS EHSEmittedSubstMassFlowIsMisg,
  cast(_MassFlow.UnitOfMeasure as ehenv_emis_emsub_mass_flow_unt preserving type ) AS EHSEmittedSubstMassFlowUnit,
  EHSEmittedSubstTotEmsnsUUID,
  _TotalEmissions.EHSAmountValue AS EHSEmittedSubstTotEmsnsQty,
  _TotalEmissions.EHSAmountIsMissing AS EHSEmittedSubstTotEmsnsIsMisg,
  cast( _TotalEmissions.UnitOfMeasure as ehenv_emis_emsub_tot_emsns_unt preserving type ) AS EHSEmittedSubstTotEmsnsUnit,
  _EHSEmDData.EHSEmDDataValidationStatus AS EHSEmDDataValidationStatus,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast( '' as ehfnd_indicator) AS EHSEmittedSubstIsMrkdForDel,
  cast( '' as ehfnd_indicator) AS EHSEmittedSubstIsMrkdForCrtn,
  _EHSEmittedSubstance.EHSSubjectUUID AS EHSSubjectUUID,
  _EHSEmittedSubstance.EHSSubjectType AS EHSSubjectType
FROM I_EHSEmDDataEmittedSubstance
LEFT OUTER JOIN I_UnitOfMeasureText AS _ConcentrationUnitText ON EHSEmittedSubstConcnUnit = _ConcentrationUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _MassFlowUnitText ON EHSEmittedSubstMassFlowUnit = _MassFlowUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _TotalEmissionsUnitText ON EHSEmittedSubstTotEmsnsUnit = _TotalEmissionsUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN E_EHSEmDDataEmittedSubstance AS _Extension ON EHSEmDDataSubstanceUUID = _Extension.EHSEmDDataSubstanceUUID  -- association [1..1]
;