I_EHSAmountsCube
Environmental Data - Cube
I_EHSAmountsCube (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.
Cross Applications
I_EHSAmountsCube is a Composite CDS View (Cube) that provides data about "Environmental Data - Cube" in SAP S/4HANA. It reads from 1 data source (I_EHSAmountsForActivity) and exposes 65 fields with key fields EHSAmountUUID, EHSMainLocationID, EHSDataClassifierID, EHSLocClassifierID. It has 10 associations to related views. Part of development package EHENV_CNS_EMISSION_INVENTORY.
SAP Help Documentation
| Category | Environmental Data – Analytical Query |
|---|---|
| Data Category | Cube |
| Status | Amount status |
Purpose
This CDS view provides the data to answer the following business questions: What amount of a specific pollutant has been released for a given location over a certain period of time? Which locations in the company produce the most emissions? What is the highest sampled value of a pollutant? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: Environment Management - Environmental Data Explorer Environment Management - Import Data Environment Management - Manage Compliance Scenario Environment Management - Missing Data Issues Environment Management - Monitor Data Environment Management - Data Issues Environment Management - My Data Collections Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: Access Restrictions to EHS Compliance Scenario These restriction types are edited in the Maintain Business Roles app.
Structure
Parameters The parameters of the CDS view are as follows: P_Date used to calculate the relevant revision of locations and the location hierarchy. By default, it is set to Today . P_Language used to specify the language in which translatable texts are shown. By default, it is set to the logon language of the user. Fields used for filtering The main filters are as follows: EHSAmountUTCDateTime used to filter by the timestamp of each amount EHSDataClassifierID used to filter by a data classifier assigned to the compliance scenario activity EHSLocClassifierID used to filter by a location classifier assigned to the location EHSMainLocationID used to filter by a main location identifier The results list displays all data records that are associated to the selected location or one of its sublocations. Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EHSAmountUUID Amount key Attribute If this field is used, the results list displays data records individually without aggregating them. EHSAmountSourceType Source type Attribute Available options are Collected Data (02), Calculated Data (04), Sampled Data (05) and Aggregated Data (06). EHSAmountUTCDate Amount date Attribute EHSAmountUTCYearMonth Amount year and month Attribute EHSAmountUTCYear Amount year Attribute EHSAmountValue Amount value Measure Doesn’t aggregate amount values. A value is displayed only if all available values are the same. UnitOfMeasure Unit of measurement Attribute UnitOfMeasureDimension Dimension of the unit of measurement Attribute EHSAmountIsReplaced Substituted value indicator Attribute EHSAmountDeviationID Deviation identifier Attribute EHSAmountIsPreliminary Preliminary result indicator Attribute EHSAmountStatus Amount status Attribute Available options are New (00), Approved (02) and Not Valid (01). EHSAmountExternalSource External source Attribute Field is relevant only for source type Data Collection . EHSComplianceScenActivityID Identifier of a compliance scenario activity Attribute Compliance scenario activities of a different type may have the same identifier. Use this field together with the EHSAmountSourceType field. EHSComplianceScenActivityName Name of a compliance scenario activity Attribute EHSComplianceScenActivityTitle Title of a compliance scenario activity Attribute Calculation definitions with multiple results have a separate title for each result. Samplings with
This CDS view provides the data to answer the following business questions: What amount of a specific pollutant has been released for a given location over a certain period of time? Which locations in the company produce the most emissions? What is the highest sampled value of a pollutant? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: Environment Management - Environmental Data Explorer Environment Management - Import Data Environment Management - Manage Compliance Scenario Environment Management - Missing Data Issues Environment Management - Monitor Data Environment Management - Data Issues Environment Management - My Data Collections Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: Access Restrictions to EHS Compliance Scenario These restriction types are edited in the Maintain Business Roles app.
Structure
Parameters The parameters of the CDS view are as follows: P_Date used to calculate the relevant revision of locations and the location hierarchy. By default, it is set to Today . P_Language used to specify the language in which translatable texts are shown. By default, it is set to the logon language of the user. Fields used for filtering The main filters are as follows: EHSAmountUTCDateTime used to filter by the timestamp of each amount EHSDataClassifierID used to filter by a data classifier assigned to the compliance scenario activity EHSLocClassifierID used to filter by a location classifier assigned to the location EHSMainLocationID used to filter by a main location identifier The results list displays all data records that are associated to the selected location or one of its sublocations. Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EHSAmountUUID Amount key Attribute If this field is used, the results list displays data records individually without aggregating them. EHSAmountSourceType Source type Attribute Available options are Collected Data (02), Calculated Data (04), Sampled Data (05) and Aggregated Data (06). EHSAmountUTCDate Amount date Attribute EHSAmountUTCYearMonth Amount year and month Attribute EHSAmountUTCYear Amount year Attribute EHSAmountValue Amount value Measure Doesn’t aggregate amount values. A value is displayed only if all available values are the same. UnitOfMeasure Unit of measurement Attribute UnitOfMeasureDimension Dimension of the unit of measurement Attribute EHSAmountIsReplaced Substituted value indicator Attribute EHSAmountDeviationID Deviation identifier Attribute EHSAmountIsPreliminary Preliminary result indicator Attribute EHSAmountStatus Amount status Attribute Available options are New (00), Approved (02) and Not Valid (01). EHSAmountExternalSource External source Attribute Field is relevant only for source type Data Collection . EHSComplianceScenActivityID Identifier of a compliance scenario activity Attribute Compliance scenario activities of a different type may have the same identifier. Use this field together with the EHSAmountSourceType field. EHSComplianceScenActivityName Name of a compliance scenario activity Attribute EHSComplianceScenActivityTitle Title of a compliance scenario activity Attribute Calculation definitions with multiple results have a separate title for each result. Samplings with
SAP API Hub
| Category | Composite |
|---|---|
| State | C1 |
| Line of Business | Cross Applications |
| Application Component | EHS-SUS-EM |
| Capabilities | Data Provider for Analytical Queries |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Not Released |
| Package | Cross Applications for SAP S/4HANA Cloud Public Edition |
| Description | This CDS view provides the data to answer the following business questions:<ul> <li> <p>What amount of a specific pollutant has been released for a given location over a certain period of time?</p> </li> <li> <p>Which locations in the company produce the most emissions?</p> </li> <li> <p>What is the highest sampled value of a pollutant?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_EHSAmountsForActivity | EHSAmountsForActivity | from |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| P_Date | sydatum | |
| P_Language | sylangu |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..*] | I_EHSLocationForFiltering | _EHSLocationForFiltering | EHSAmountsForActivity.EHSLocationUUID = _EHSLocationForFiltering.EHSLocationUUID |
| [1..*] | I_EHSLocationByIdentifier | _EHSLocationByIdentifier | $projection.EHSMainLocationID = _EHSLocationByIdentifier.EHSLocationID |
| [0..*] | I_EHSLocClassifier | _EHSLocClassifier | EHSAmountsForActivity.EHSLocationUUID = _EHSLocClassifier.EHSLocationUUID |
| [0..*] | I_EHSDataClassifierForFilter | _EHSDataClassifierForFilter | EHSAmountsForActivity.EHSComplianceScenActivityUUID = _EHSDataClassifierForFilter.EHSComplianceScenActivityUUID |
| [0..1] | I_EHSSubject | _EHSSubject | EHSAmountsForActivity.EHSSubjectUUID = _EHSSubject.EHSSubjectUUID |
| [1..*] | I_EHSLocationRevision | _EHSLocation | EHSAmountsForActivity.EHSLocationUUID = _EHSLocation.EHSLocationUUID |
| [1..1] | I_EHSLocationRoot | _EHSLocationRoot | $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID |
| [0..1] | P_EHSLOCCLASSIFIERS | _EHSLocClassifiers | $projection.EHSLocationUUID = _EHSLocClassifiers.EHSLocationUUID |
| [0..1] | P_EHSDataClassifiers | _EHSDataClassifiers | $projection.EHSComplianceScenActivityUUID = _EHSDataClassifiers.EHSComplianceScenActivityUUID |
| [1..*] | I_EHSLocationGeoPoint | _EHSLocationGeoPoint | $projection.ehslocationid = _EHSLocationGeoPoint.EHSLocationID |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IEHSAMNTCUBE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Environmental Data - Cube | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.internalName | #LOCAL | view | |
| VDM.viewType | #COMPOSITE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view |
Fields (65)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EHSAmountUUID | I_EHSAmountsForActivity | EHSAmountUUID | Amount Key |
| KEY | EHSMainLocationID | Main Location ID | ||
| KEY | EHSDataClassifierID | _EHSDataClassifierForFilter | EHSDataClassifierID | Data Classifier for Location Aggregation |
| KEY | EHSLocClassifierID | Location Classifier ID | ||
| EHSMainLocationName | Main Location Name | |||
| EHSAmountSourceType | I_EHSAmountsForActivity | EHSAmountSourceType | Data Source Type | |
| EHSSubjectType | I_EHSAmountsForActivity | EHSSubjectType | Subject Type | |
| EHSSubjectUUID | I_EHSAmountsForActivity | EHSSubjectUUID | Reference to Subject Type BO Root Node ID | |
| EHSAmountUTCDateTime | I_EHSAmountsForActivity | EHSAmountUTCDateTime | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |
| EHSAmountUTCDate | Date | |||
| EHSAmountUTCYearMonth | Calendar Year and Month | |||
| EHSAmountUTCYear | Year | |||
| EHSAmountValue | I_EHSAmountsForActivity | EHSAmountValue | Amount Value | |
| UnitOfMeasure | I_EHSAmountsForActivity | UnitOfMeasure | Measure Units of Various Types | |
| UnitOfMeasureDimension | I_EHSAmountsForActivity | UnitOfMeasureDimension | Physical Dimension | |
| EHSAmountIsReplaced | I_EHSAmountsForActivity | EHSAmountIsReplaced | Substituted Value | |
| EHSAmountDeviationID | I_EHSAmountsForActivity | EHSAmountDeviationID | Business Object ID | |
| EHSAmountIsPreliminary | I_EHSAmountsForActivity | EHSAmountIsPreliminary | Preliminary Result | |
| EHSAmountStatus | I_EHSAmountsForActivity | EHSAmountStatus | Amount Status | |
| EHSAmountExternalSource | I_EHSAmountsForActivity | EHSAmountExternalSource | External Source | |
| EHSComplianceScenActivityUUID | I_EHSAmountsForActivity | EHSComplianceScenActivityUUID | Activity Key | |
| EHSComplianceScenActivityID | I_EHSAmountsForActivity | EHSComplianceScenActivityID | Data Collection Definition ID | |
| EHSComplianceScenActivityName | I_EHSAmountsForActivity | EHSComplianceScenActivityName | Data Collection Definition Name | |
| EHSComplianceScenActivityTitle | I_EHSAmountsForActivity | EHSComplianceScenActivityTitle | Description (Long) | |
| DataUsagePeriodicity | I_EHSAmountsForActivity | DataUsagePeriodicity | Data Period of Data Collection Definition | |
| EHSLocationUUID | I_EHSAmountsForActivity | EHSLocationUUID | Location Key | |
| EHSAmountIssueType | I_EHSAmountsForActivity | EHSAmountIssueType | Amount Issue Type Values | |
| EHSAmountSourceTypeName | Data Source Type Name | |||
| UnitOfMeasureName | Unit of Measurement Short Text with a 10-Character Maximum | |||
| UnitOfMeasureDimensionName | Dimension Text | |||
| EHSAmountStatusName | Short Text for Fixed Values | |||
| EHSDataPeriodText | Short Text for Fixed Values | |||
| EHSAmountIssueTypeText | Short Text for Fixed Values | |||
| EHSLocationName | Location Name | |||
| EHSLocationType | Location Type | |||
| EHSLocationRevisionUUID | EHS Location - Revision UUID | |||
| EHSLocationTypeText | Location Type Name | |||
| Country | Country/Region | |||
| CountryName | Country/Region Name | |||
| Region | Region | |||
| RegionName | Region Name | |||
| Plant | Plant ID | |||
| PlantName | Plant Name | |||
| OrganizationalUnit | Organizational Unit ID | |||
| OrganizationalUnitName | Short Text of Organizational Unit | |||
| ControllingArea | Controlling Area | |||
| ControllingAreaName | Controlling Area Name | |||
| CostCenter | Cost Center | |||
| CostCenterName | Cost Center Name | |||
| CompanyCode | Company Code | |||
| CompanyCodeName | Name of Company Code or Company | |||
| EHSLocationStatus | Location Status | |||
| EHSLocationAuthorizationGroup | Location Authorization Group | |||
| BusinessArea | Business Area | |||
| EHSLocationID | _EHSLocationRoot | EHSLocationID | Location ID | |
| EHSLocClassifiersText | List of Classifiers (Comma Separated) - short | |||
| EHSDataClassifiersText | _EHSDataClassifiers | Classifiers | Data Classifiers | |
| EHSSubjectID | _EHSSubject | EHSSubjectID | Subject ID | |
| CASNumber | _EHSSubject | CASNumber | CAS Number | |
| EHSSubjectText | Subject Name | |||
| NumberOfRecords | 0 | Number of Records | ||
| EHSAmountDataMaxQuantity | I_EHSAmountsForActivity | EHSAmountValue | Maximum Amount | |
| EHSAmountDataMinQuantity | I_EHSAmountsForActivity | EHSAmountValue | Minimum Amount | |
| _EHSLocationGeoPoint | _EHSLocationGeoPoint | |||
| _EHSLocationByIdentifier | _EHSLocationByIdentifier |
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_Langu: $parameters.P_Language).Classifiers AS EHSLocClassifiersText,
_EHSDataClassifiers.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..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA