I_EHSAmountsCube

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_EHSAmountsCube.
-- 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: IEHSAMNTCUBE
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW I_EHSAmountsCube AS
SELECT
  EHSAmountsForActivity.EHSAmountUUID AS EHSAmountUUID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date).EHSParentLocationID AS EHSMainLocationID,
  _EHSDataClassifierForFilter.EHSDataClassifierID AS EHSDataClassifierID,
  _EHSLocClassifier._EHSClassifierRoot.EHSLocClassifierID AS EHSLocClassifierID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date)._EHSLocationRevisionNameT[1: Language = $parameters.P_Language and RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationName AS EHSMainLocationName,
  EHSAmountsForActivity.EHSAmountSourceType AS EHSAmountSourceType,
  EHSAmountsForActivity.EHSSubjectType AS EHSSubjectType,
  EHSAmountsForActivity.EHSSubjectUUID AS EHSSubjectUUID,
  EHSAmountsForActivity.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  cast(tstmp_to_dats(EHSAmountsForActivity.EHSAmountUTCDateTime,'UTC',$session.client,'INITIAL') as ehfnd_date preserving type ) AS EHSAmountUTCDate,
  cast(substring(tstmp_to_dats(EHSAmountsForActivity.EHSAmountUTCDateTime,'UTC',$session.client,'INITIAL'),1,6) as ehfnd_yearmonth ) AS EHSAmountUTCYearMonth,
  cast(substring(tstmp_to_dats(EHSAmountsForActivity.EHSAmountUTCDateTime,'UTC',$session.client,'INITIAL'),1,4) as ehfnd_year_code ) AS EHSAmountUTCYear,
  EHSAmountsForActivity.EHSAmountValue AS EHSAmountValue,
  EHSAmountsForActivity.UnitOfMeasure AS UnitOfMeasure,
  EHSAmountsForActivity.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  EHSAmountsForActivity.EHSAmountIsReplaced AS EHSAmountIsReplaced,
  EHSAmountsForActivity.EHSAmountDeviationID AS EHSAmountDeviationID,
  EHSAmountsForActivity.EHSAmountIsPreliminary AS EHSAmountIsPreliminary,
  EHSAmountsForActivity.EHSAmountStatus AS EHSAmountStatus,
  EHSAmountsForActivity.EHSAmountExternalSource AS EHSAmountExternalSource,
  EHSAmountsForActivity.EHSComplianceScenActivityUUID AS EHSComplianceScenActivityUUID,
  EHSAmountsForActivity.EHSComplianceScenActivityID AS EHSComplianceScenActivityID,
  EHSAmountsForActivity.EHSComplianceScenActivityName AS EHSComplianceScenActivityName,
  EHSAmountsForActivity.EHSComplianceScenActivityTitle AS EHSComplianceScenActivityTitle,
  EHSAmountsForActivity.DataUsagePeriodicity AS DataUsagePeriodicity,
  EHSAmountsForActivity.EHSLocationUUID AS EHSLocationUUID,
  EHSAmountsForActivity.EHSAmountIssueType AS EHSAmountIssueType,
  EHSAmountsForActivity._EHSAmountSourceType._Text[1: Language = $parameters.P_Language].EHSAmountSourceTypeName AS EHSAmountSourceTypeName,
  EHSAmountsForActivity._UnitText._Text[1: Language = $parameters.P_Language].UnitOfMeasureName AS UnitOfMeasureName,
  EHSAmountsForActivity._UnitText._DimensionText[1: Language = $parameters.P_Language].UnitOfMeasureDimensionName AS UnitOfMeasureDimensionName,
  EHSAmountsForActivity._EHSAmountStatus._Text[1: Language = $parameters.P_Language].EHSAmountStatusName AS EHSAmountStatusName,
  EHSAmountsForActivity._EHSDataPeriod._Text[1: Language = $parameters.P_Language].EHSDataPeriodText AS EHSDataPeriodText,
  EHSAmountsForActivity._EHSAmountIssueTypeText[1: Language = $parameters.P_Language].EHSAmountIssueTypeText AS EHSAmountIssueTypeText,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationRevisionName[1: Language = $parameters.P_Language].EHSLocationName AS EHSLocationName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationType AS EHSLocationType,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationRevisionUUID AS EHSLocationRevisionUUID,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationType._Text[1: Language = $parameters.P_Language].EHSLocationTypeText AS EHSLocationTypeText,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Country AS Country,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Country._Text[1: Language = $parameters.P_Language].CountryName AS CountryName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Region AS Region,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Region._RegionText[1: Language = $parameters.P_Language].RegionName AS RegionName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Plant AS Plant,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Plant.PlantName AS PlantName,
  cast ( _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].OrganizationalUnit as ehfnd_org_unit_id_nc preserving type ) AS OrganizationalUnit,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._OrganizationalUnit._OrgUnitText[1: Language = $parameters.P_Language].OrganizationalUnitName AS OrganizationalUnitName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].ControllingArea AS ControllingArea,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CostCenter AS CostCenter,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._CostCenter[1: ValidityStartDate <= $parameters.P_Date and ValidityEndDate >= $parameters.P_Date]._Text[1: Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CompanyCode AS CompanyCode,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationStatus AS EHSLocationStatus,
  cast( _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].BusinessArea AS BusinessArea,
  _EHSLocationRoot.EHSLocationID AS EHSLocationID,
  _EHSLocClassifiers(P_Mandt: $session.client, P_Langu: $parameters.P_Language).Classifiers AS EHSLocClassifiersText,
  _EHSDataClassifiers(P_SAPClient: $session.client).Classifiers AS EHSDataClassifiersText,
  _EHSSubject.EHSSubjectID AS EHSSubjectID,
  _EHSSubject.CASNumber AS CASNumber,
  _EHSSubject._Text[1: Language = $parameters.P_Language ].EHSSubjectText AS EHSSubjectText,
  0 AS NumberOfRecords,
  EHSAmountsForActivity.EHSAmountValue AS EHSAmountDataMaxQuantity,
  EHSAmountsForActivity.EHSAmountValue AS EHSAmountDataMinQuantity
FROM I_EHSAmountsForActivity AS EHSAmountsForActivity
LEFT OUTER JOIN I_EHSLocationForFiltering AS _EHSLocationForFiltering ON EHSAmountsForActivity.EHSLocationUUID = _EHSLocationForFiltering.EHSLocationUUID  -- association [1..*]
LEFT OUTER JOIN I_EHSLocationByIdentifier AS _EHSLocationByIdentifier ON EHSMainLocationID = _EHSLocationByIdentifier.EHSLocationID  -- association [1..*]
LEFT OUTER JOIN I_EHSLocClassifier AS _EHSLocClassifier ON EHSAmountsForActivity.EHSLocationUUID = _EHSLocClassifier.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSDataClassifierForFilter AS _EHSDataClassifierForFilter ON EHSAmountsForActivity.EHSComplianceScenActivityUUID = _EHSDataClassifierForFilter.EHSComplianceScenActivityUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSSubject AS _EHSSubject ON EHSAmountsForActivity.EHSSubjectUUID = _EHSSubject.EHSSubjectUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLocation ON EHSAmountsForActivity.EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [1..*]
LEFT OUTER JOIN I_EHSLocationRoot AS _EHSLocationRoot ON EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID  -- association [1..1]
LEFT OUTER JOIN P_EHSLOCCLASSIFIERS AS _EHSLocClassifiers ON EHSLocationUUID = _EHSLocClassifiers.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN P_EHSDataClassifiers AS _EHSDataClassifiers ON EHSComplianceScenActivityUUID = _EHSDataClassifiers.EHSComplianceScenActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationGeoPoint AS _EHSLocationGeoPoint ON ehslocationid = _EHSLocationGeoPoint.EHSLocationID  -- association [1..*]
;