I_EnvrmtAmountsForActivity

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_EnvrmtAmountsForActivity.
-- 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: IENVAMNSFORACT
-- Parameters: P_Language : sylangu

CREATE VIEW I_EnvrmtAmountsForActivity AS
SELECT
  AmountRoot.EHSAmountUUID AS EHSAmountUUID,
  AmountRoot.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  AmountRoot.UnitOfMeasureName AS UnitOfMeasureName,
  AmountRoot.UnitOfMeasure AS UnitOfMeasure,
  AmountRoot._UnitText AS _UnitText,
  AmountRoot.EHSAmountSourceType AS EHSAmountSourceType,
  AmountRoot._EHSAmountSourceType AS _EHSAmountSourceType,
  AmountRoot._EHSAmountSourceType._Text[1: Language = $session.system_language].EHSAmountSourceTypeName AS EHSAmountSourceTypeName,
  AmountRoot.EHSSubjectType AS EHSSubjectType,
  AmountRoot.EHSSubjectUUID AS EHSSubjectUUID,
  AmountRoot.EHSAmountValue AS EHSAmountValue,
  DataCollectionRoot.EHSLocationUUID AS EHSLocationUUID,
  DataCollectionRoot.DataUsagePeriodicity AS DataUsagePeriodicity,
  DataCollectionRoot._EHSLocation._EHSLocationRevisionName[1: Language = $session.system_language].EHSLocationName AS EHSLocationName,
  DataCollectionRoot._EHSLocation.Country AS Country,
  _EHSLocation._Country AS _Country,
  DataCollectionRoot._EHSLocation.Plant AS Plant,
  DataCollectionRoot._EHSLocation._Plant.PlantName AS PlantName,
  _EHSLocation._Plant AS _Plant,
  DataCollectionRoot._EHSLocation.BusinessArea AS BusinessArea,
  _EHSLocation._BusinessArea AS _BusinessArea,
  DataCollectionRoot._EHSLocation.Region AS Region,
  _EHSLocation._Region AS _Region,
  DataCollectionRoot._EHSLocation.EHSLocationType AS EHSLocationType,
  _EHSLocation._EHSLocationType AS _EHSLocationType,
  _LocAggregationPeriod.DataPeriodName AS DataPeriodName
FROM I_EHSAmountRoot AS AmountRoot
INNER JOIN I_DataCollectionRoot AS DataCollectionRoot ON /* join condition not captured in parsed metadata */
INNER JOIN t006a ON /* join condition not captured in parsed metadata */
INNER JOIN P_DataCollDefPeriod AS _DataCollDefPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalcDefResultHeader AS CalcDefResultHeader ON /* join condition not captured in parsed metadata */
INNER JOIN P_CalcPeriod AS _CalcPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_SamplingDefinitionRoot AS SamplingDefinitionRoot ON /* join condition not captured in parsed metadata */
INNER JOIN P_SamplingPeriod AS _SamplingPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_LocAggregationRoot AS LocAggregationRoot ON /* join condition not captured in parsed metadata */
INNER JOIN P_LocAggregationPeriod AS _LocAggregationPeriod ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_EHSAmountRoot
;