I_EHSAmountsForActivity

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_EHSAmountsForActivity.
-- 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_EHSAmountsForActivity AS
SELECT
  EHSAmountRoot.EHSAmountUUID AS EHSAmountUUID,
  EHSAmountRoot.EHSAmountSourceUUID AS EHSAmountSourceUUID,
  cast( EHSAmountRoot.EHSAmountSourceType as ehfnd_amns_src_type_nc preserving type ) AS EHSAmountSourceType,
  cast( EHSAmountRoot.EHSSubjectType as ehenv_amns_qry_subj_type preserving type ) AS EHSSubjectType,
  EHSAmountRoot.EHSSubjectUUID AS EHSSubjectUUID,
  EHSAmountRoot.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  cast( EHSAmountRoot.EHSAmountValue as ehfnd_amns_value_nc preserving type ) AS EHSAmountValue,
  cast( EHSAmountRoot.UnitOfMeasure as ehfnd_unit_code_nce preserving type ) AS UnitOfMeasure,
  cast( EHSAmountRoot.UnitOfMeasureDimension as ehfnd_unit_dimension_nc preserving type ) AS UnitOfMeasureDimension,
  EHSAmountRoot.EHSAmountIsMissing AS EHSAmountIsMissing,
  EHSAmountRoot.EHSAmountIsFaulty AS EHSAmountIsFaulty,
  EHSAmountRoot.EHSAmountIsNotAvailable AS EHSAmountIsNotAvailable,
  EHSAmountRoot.EHSAmountIsReplaced AS EHSAmountIsReplaced,
  EHSAmountRoot.EHSAmountDeviationID AS EHSAmountDeviationID,
  EHSAmountRoot.EHSAmountHasWarning AS EHSAmountHasWarning,
  EHSAmountRoot.EHSAmountIsPreliminary AS EHSAmountIsPreliminary,
  EHSAmountRoot.EHSAmountStatus AS EHSAmountStatus,
  EHSAmountRoot.EHSAmountExternalSource AS EHSAmountExternalSource,
  cast( EHSAmountRoot.EHSAmtOutOfPrecisenessOptr as ehfnd_amns_outofprecis_op_nc preserving type ) AS EHSAmtOutOfPrecisenessOptr,
  EHSAmountRoot.Note AS Note,
  DataCollectionRoot.DataCollectionUUID AS EHSComplianceScenActivityUUID,
  DataCollectionRoot.DataCollectionID AS EHSComplianceScenActivityID,
  DataCollectionRoot.DataCollectionName AS EHSComplianceScenActivityName,
  DataCollectionRoot.DataCollectionTitle AS EHSComplianceScenActivityTitle,
  cast( DataCollectionRoot.DataUsagePeriodicity as ehenv_mdef_period_code_nc preserving type ) AS DataUsagePeriodicity,
  DataCollectionRoot.EHSLocationUUID AS EHSLocationUUID,
  EHSAmountRoot._EHSAmountSourceType AS _EHSAmountSourceType,
  EHSAmountRoot._EHSAmountStatus AS _EHSAmountStatus,
  EHSAmountRoot._UnitText AS _UnitText,
  DataCollectionRoot._EHSLocation AS _EHSLocation,
  DataCollectionRoot._EHSDataPeriod AS _EHSDataPeriod
FROM I_EHSAmountRoot AS EHSAmountRoot
INNER JOIN I_DataCollectionRootBasic AS DataCollectionRoot 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_SamplingReference AS SamplingReference ON /* join condition not captured in parsed metadata */
INNER JOIN I_SamplingHeader AS SamplingHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_SamplingDefinitionRoot AS SamplingDefinitionRoot ON /* join condition not captured in parsed metadata */
INNER JOIN I_LocAggregationRoot AS LocAggregationRoot ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSEmittedSubstanceDataSet AS EHSEmittedSubstanceDataSet ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSEmittedSubstance AS EHSEmittedSubstance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSAmountIssueTypeText AS _EHSAmountIssueTypeText ON EHSAmountIssueType = _EHSAmountIssueTypeText.EHSAmountIssueType  -- association [0..*]
LEFT OUTER JOIN I_EHSDataPeriod AS _EHSDataPeriod ON DataUsagePeriodicity = _EHSDataPeriod.EHSDataPeriod  -- association [0..1]
-- UNION with additional select branch(es): I_EHSAmountRoot
;