I_EHSAmountSimpleCube

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

CREATE VIEW I_EHSAmountSimpleCube AS
SELECT
  EHSAmountsForActivity.EHSAmountUUID AS EHSAmountUUID,
  EHSAmountsForActivity.EHSLocationUUID AS EHSLocationUUID,
  cast(_EHSLocation._EHSLocationRoot.EHSLocationID as ehfnd_loc_id) AS EHSLocationID,
  EHSAmountsForActivity._EHSAmountIssueTypeText[1: Language = $parameters.P_Language].EHSAmountIssueTypeText AS EHSAmountIssueTypeText,
  EHSAmountsForActivity.EHSAmountIssueType AS EHSAmountIssueType,
  EHSAmountsForActivity._EHSAmountSourceType._Text[1: Language = $parameters.P_Language].EHSAmountSourceTypeName AS EHSAmountSourceTypeName,
  EHSAmountsForActivity.EHSAmountSourceType AS EHSAmountSourceType,
  EHSAmountsForActivity.EHSAmountStatus AS EHSAmountStatus,
  cast(substring(tstmp_to_dats(EHSAmountsForActivity.EHSAmountUTCDateTime,'UTC',$session.client,'INITIAL'),1,6) as ehfnd_yearmonth ) AS EHSAmountUTCYearMonth,
  EHSAmountsForActivity.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  cast( 1 as abap.int4 ) AS NumberOfRecords,
  case EHSAmountsForActivity.EHSAmountIssueType when '02' then 1 else 0 end AS EHSNmbrOfAmountsWthExceedances,
  case EHSAmountsForActivity.EHSAmountIssueType when '04' then 1 else 0 end AS EHSNmbrOfAmountsWthMissingData
FROM I_EHSAmountsForActivity AS EHSAmountsForActivity
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationIdentifier AS _EHSLocationIdentifier ON EHSLocationID = _EHSLocationIdentifier.EHSLocationID  -- association [0..*]
LEFT OUTER JOIN I_EHSAmountExceedanceTypeText AS _EHSAmountExceedanceTypeText ON EHSAmountExceedanceType = _EHSAmountExceedanceTypeText.EHSAmountExceedanceType  -- association [0..*]
;