C_EHSAmountDEX

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 C_EHSAmountDEX.
-- 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 C_EHSAmountDEX AS
SELECT
  EHSAmount.EHSAmountUUID AS EHSAmountUUID,
  EHSAmount.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  cast( EHSAmount.EHSAmountValue as ehfnd_amns_value_nc preserving type ) AS EHSAmountValue,
  cast ( EHSAmount.UnitOfMeasure as ehfnd_unit_code_cunit preserving type ) AS UnitOfMeasure,
  EHSAmount._UnitText AS _UnitText,
  EHSAmount.EHSAmountHasWarning AS EHSAmountHasWarning,
  EHSAmount.EHSAmountIsFaulty AS EHSAmountIsFaulty,
  cast (EHSAmount.EHSAmountSourceType as ehfnd_amns_src_type_nc preserving type ) AS EHSAmountSourceType,
  EHSAmount._EHSAmountSourceType AS _EHSAmountSourceType,
  EHSAmount.EHSAmountSourceUUID AS EHSAmountSourceUUID,
  EHSAmount.EHSAmountExternalSource AS EHSAmountExternalSource,
  EHSAmount.EHSSubjectType AS EHSSubjectType,
  EHSAmount.EHSSubjectUUID AS EHSSubjectUUID,
  _EHSAmountsForActivity.EHSLocationUUID AS EHSLocationUUID
FROM I_EHSAmountRoot AS EHSAmount
LEFT OUTER JOIN C_EHSDataCollectionDEX AS _EHSDataCollection ON EHSAmount.EHSAmountSourceUUID = _EHSDataCollection.DataCollectionUUID AND EHSAmount.EHSAmountSourceType = '02'  -- association [0..1]
LEFT OUTER JOIN C_EHSCalcDefResultHeaderDEX AS _EHSCalcDefResultHeader ON EHSAmount.EHSAmountSourceUUID = _EHSCalcDefResultHeader.CalculationResultHeaderUUID AND EHSAmount.EHSAmountSourceType = '04'  -- association [0..1]
LEFT OUTER JOIN C_EHSSamplingHeaderDEX AS _EHSSamplingHeader ON EHSAmount.EHSAmountSourceUUID = _EHSSamplingHeader.SamplingHeaderUUID AND EHSAmount.EHSAmountSourceType = '05'  -- association [0..1]
LEFT OUTER JOIN C_EHSLocationAggregationDEX AS _EHSLocationAggregation ON EHSAmount.EHSAmountSourceUUID = _EHSLocationAggregation.LocAggregationUUID AND EHSAmount.EHSAmountSourceType = '06'  -- association [0..1]
LEFT OUTER JOIN C_EHSChmlPhysPropertyDEX AS _EHSChmlPhysProperty ON EHSAmount.EHSSubjectUUID = _EHSChmlPhysProperty.EHSChemicalPhysicalPropUUID AND EHSAmount.EHSSubjectType = '02'  -- association [0..1]
LEFT OUTER JOIN C_ListedSubstanceElementDEX AS _ListedSubstanceElement ON EHSAmount.EHSSubjectUUID = _ListedSubstanceElement.ListedSubstanceUUID AND EHSAmount.EHSSubjectType = '03'  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatlDEX AS _ChmlCmplncPrimMatl ON EHSAmount.EHSSubjectUUID = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID AND EHSAmount.EHSSubjectType = '06'  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationRevisionBasic AS _EHSLocationRevisionBasic ON _EHSLocationRevisionBasic.EHSLocationUUID = _EHSAmountsForActivity.EHSLocationUUID  -- association [0..1]
;