What is C_WasteAnalyticsQuery in SAP S/4HANA?

C_WasteAnalyticsQuery is a consumption CDS view in SAP S/4HANA. Waste Data Analytics - Query It contains 44 fields.

Which tables does C_WasteAnalyticsQuery read from?

C_WasteAnalyticsQuery reads data from: I_WasteAnalyticsCube.

What VDM layer is C_WasteAnalyticsQuery?

C_WasteAnalyticsQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_WasteAnalyticsQuery

DDL: C_WASTEANALYTICSQUERY Type: view CONSUMPTION Package: EHEWA_CNS_ANALYTICS

44 Fields 1 Data Sources 1 Fiori Apps

Waste Data Analytics - Query

C_WasteAnalyticsQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_WasteAnalyticsQuery is a Consumption CDS View that provides data about "Waste Data Analytics - Query" in SAP S/4HANA. It reads from 1 data source (I_WasteAnalyticsCube) and exposes 44 fields with key fields EnvrmtWasteTranspDocUUID, EnvWstTranspDocMatlAssgdUUID, EnvrmtWasteCodeUUID, WasteStreamRgtyCode, WasteStreamRgtyCodeValue. It is used in 1 Fiori application: Waste Analytics. Part of development package EHEWA_CNS_ANALYTICS.

SAP Help Documentation

Category	CDS Views for Waste Management
Data Category	Query
Status	Status of Waste Transfer Request

Purpose
This CDS view retrieves the outgoing and confirmed quantities of waste products that are part of waste transportation documents, along with the corresponding units of measure. This CDS view provides the data to answer the following business questions: How much waste has been transported and disposed of during a certain period? How much waste is still pending transportation? How much waste has been tracked in the My Waste Transportation Documents app for a specific product, waste code, disposal facility, and so on. 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 Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Parameters The parameters of the CDS view are as follows: P_Date : This parameter is used to calculate the relevant revision of locations and the location hierarchy. By default, it is set to the current date. P_Language : This parameter is used to specify the language in which translatable texts are displayed. By default, it is set to the logon language of the user. Fields Used for Filtering The main filters are as follows: EnvWstTranspDocHandoverDate : This field is used to restrict the result set (aggregation) by the handover date of a waste transportation document. Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute EnvrmtWasteTranspDocUUID Waste Transportation Document UUID Attribute EnvWstTranspDocMatlAssgdUUID Waste Transportation Document Material Assigned Attribute EnvrmtWasteCodeUUID Node ID Attribute WasteStreamRgtyCode Waste Stream Regulatory Code Attribute WasteStreamRgtyCodeValue Waste Stream Regulatory Code Value Attribute EnvrmtWastePartnerNmbr Business Partner Number Attribute EHSMainLocationID Location ID Attribute EHSMainLocationName Location Attribute CmplRqVersUUID Compliance Requirement UUID Attribute ClassifiedAsDangerousGood Classified As Attribute WasteTranspDocID Transportation Document ID Attribute EnvrmtWasteTranspDocType Transportation Document Type Attribute EnvrmtWasteTranspDocStatus Transportation Document Status Attribute CmplRqVersPermitNumber Permit Number Attribute EnvWstTranspDocPrintedDate Sent Date Attribute EnvWstTranspDocHandoverDate Handover Date Attribute EnvWstTranspDocTakeAcceptDate Transporter Date Attribute EnvrmtWasteTransptrRegnID Transporter Registration Number Attribute BusinessPartner Disposer Attribute EnvWstTranspDocDisposerDate Disposer Date Attribute EnvrmtWasteGnrtrID Waste Generator ID Attribute WasteRegistrationNumber Waste Generator Registration Number Attribute WasteTransferRequestNumber Waste Transfer Request Number Attribute EHSLocationID Point of Waste Generation Attribute WasteTransfReqStatus Status of Waste Transfer Request Attribute CostCenter Cost Center Attribute WasteDisposalChannelNumber Disposal Channel Number Attribute WasteDisposalChannelName Disposal Channel Name Attribute EnvrmtWasteFcltyRegistrationID Disposal Facility Registration ID Attribute EnvrmtWastePartFcltyName Disposal Facility Name Attribute Material Product Attribute WasteStreamContainerType Container Type Attribute EnvrmtWasteMgmtMethCode R&D Code Attribute EnvrmtWasteCode Waste Code Attribute EnvrmtWasteCodeShortDesc Waste Code Description Attribute EnvrmtWasteHazardCharcID Waste Type Attribute CmplRqVers Regulation Attribute CmplRqVersName Regulation Name Attribute WasteStreamRgtyCodeValueText Regulatory Code Value Text Attribute EnvrmtWasteOutgoingQuantity Outgoing Quantity Measure EnvrmtWasteConfirmedQuantity Confirmed Quantity Measure Env

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Cross Applications
Application Component	EHS-SUS-WA
Capabilities	Analytical Query
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	<p>This CDS view retrieves the outgoing and confirmed quantities of waste products that are part of waste transportation documents, along with the corresponding units of measure.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>How much waste has been transported and disposed of during a certain period?</p></li> <li><p>How much waste is still pending transportation?</p></li> <li><p>How much waste has been tracked in the My Waste Transportation Documents app for a specific product, waste code, disposal facility, and so on. </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_WasteAnalyticsCube	I_WasteAnalyticsCube	from

Parameters (2)

Name	Type	Default
P_Date	sydatum
P_Language	sylangu

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CWANALYTSQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.query	true	view
OData.publish	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
EndUserText.label	Waste Data Analytics - Query	view

Fiori Apps (1)

App ID	App Name	Type	Description
F6956	Waste Analytics	Transactional	An application to aggregate data from Waste Transportation documents and create dynamic reports using different dimensions

Waste Analytics

Business Role: Environmental Manager

With this app, you can aggregate, analyze, and compare data from waste transportation documents and corresponding data sets with reference information.

Fields (44)

Key	Field	Source Field	Description
KEY	EnvrmtWasteTranspDocUUID	EnvrmtWasteTranspDocUUID	Waste Transportation Document UUID
KEY	EnvWstTranspDocMatlAssgdUUID	EnvWstTranspDocMatlAssgdUUID	Waste Transportation Document Material Assigned
KEY	EnvrmtWasteCodeUUID	EnvrmtWasteCodeUUID	Waste Code
KEY	WasteStreamRgtyCode	WasteStreamRgtyCode	Waste Stream Regulatory Code
KEY	WasteStreamRgtyCodeValue	WasteStreamRgtyCodeValue	Waste Stream Regulatory Code Value
KEY	EnvrmtWastePartnerNmbr	EnvrmtWastePartnerNmbr	Business Partner Number
KEY	EHSMainLocationID	EHSMainLocationID	Location ID
	EHSMainLocationName	EHSMainLocationName	Location
	CmplRqVersUUID	CmplRqVersUUID	Compliance Requirement UUID
	ClassifiedAsDangerousGood	ClassifiedAsDangerousGood	Classified As
	WasteTranspDocID	WasteTranspDocID	ID of Waste Transportation Document
	EnvrmtWasteTranspDocType	EnvrmtWasteTranspDocType	Waste Transportation Document Type ID
	EnvrmtWasteTranspDocStatus	EnvrmtWasteTranspDocStatus	Waste Transportation Document Status
	CmplRqVersPermitNumber	CmplRqVersPermitNumber	Permit Number
	EnvWstTranspDocPrintedDate	EnvWstTranspDocPrintedDate	Waste Transportation Document Print Date
	EnvWstTranspDocHandoverDate	EnvWstTranspDocHandoverDate	Waste Transportation Document Handover Date
	EnvWstTranspDocTakeAcceptDate	EnvWstTranspDocTakeAcceptDate	Transportation Document Take/Accept date
	EnvrmtWasteTransptrRegnID	EnvrmtWasteTransptrRegnID	Transporter Registration Number
	BusinessPartner	BusinessPartner	Business Partner Number
	EnvWstTranspDocDisposerDate	EnvWstTranspDocDisposerDate	Transportation Document Take/Accept date
	EnvrmtWasteGnrtrUUID	EnvrmtWasteGnrtrUUID	Waste Generator UUID
	EnvrmtWasteGnrtrID	EnvrmtWasteGnrtrID	Waste Generator ID
	WasteRegistrationNumber	WasteRegistrationNumber	Waste Generator Registration Number
	WasteTransferRequestNumber	WasteTransferRequestNumber	Number of Waste Transfer Request
	EHSLocationID	EHSLocationID	Point of Waste Generation
	WasteTransfReqStatus	WasteTransfReqStatus	Status of Waste Transfer Request
	CostCenter	CostCenter	Cost Center
	WasteDisposalChannelNumber	WasteDisposalChannelNumber	Disposal Channel Number
	WasteDisposalChannelName	WasteDisposalChannelName	Disposal Channel Name
	EnvrmtWasteFcltyRegistrationID	EnvrmtWasteFcltyRegistrationID	Disposal Facility Registration ID
	EnvrmtWastePartFcltyName	EnvrmtWastePartFcltyName	Waste Disposal Facility Name
	Material	Material	Product
	WasteStreamContainerType	WasteStreamContainerType	Waste Stream Container Type
	EnvrmtWasteMgmtMethCode	EnvrmtWasteMgmtMethCode	Waste Management Method Code
	EnvrmtWasteCode	EnvrmtWasteCode	Waste Code
	EnvrmtWasteCodeShortDesc	EnvrmtWasteCodeShortDesc	Normalized text used for searching
	EnvrmtWasteHazardCharcID	EnvrmtWasteHazardCharcID	Waste Type ID
	CmplRqVers	CmplRqVers	Compliance Requirement Version ID
	CmplRqVersName	CmplRqVersName	Name of the Compliance Requirement Version
	WasteStreamRgtyCodeValueText	WasteStreamRgtyCodeValueText	Regulatory Code Value Text
	EnvrmtWasteOutgoingQuantity	1	Outgoing Quantity
	EnvrmtWasteConfirmedQuantity	1	Confirmed Quantity
	EnvrmtWasteOutgoingQtyCode	EnvrmtWasteOutgoingQtyCode	Outgoing Quantity Unit of Measure
	EnvrmtWasteConfirmedQtyCode	EnvrmtWasteConfirmedQtyCode	Confirmed Quantity Unit of Measure

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 C_WasteAnalyticsQuery.
-- 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_Date : sydatum, P_Language : sylangu

CREATE VIEW C_WasteAnalyticsQuery AS
SELECT
  EnvrmtWasteTranspDocUUID,
  EnvWstTranspDocMatlAssgdUUID,
  EnvrmtWasteCodeUUID,
  WasteStreamRgtyCode,
  WasteStreamRgtyCodeValue,
  EnvrmtWastePartnerNmbr,
  EHSMainLocationID,
  EHSMainLocationName,
  CmplRqVersUUID,
  ClassifiedAsDangerousGood,
  WasteTranspDocID,
  EnvrmtWasteTranspDocType,
  EnvrmtWasteTranspDocStatus,
  CmplRqVersPermitNumber,
  EnvWstTranspDocPrintedDate,
  EnvWstTranspDocHandoverDate,
  EnvWstTranspDocTakeAcceptDate,
  EnvrmtWasteTransptrRegnID,
  BusinessPartner,
  EnvWstTranspDocDisposerDate,
  EnvrmtWasteGnrtrUUID,
  EnvrmtWasteGnrtrID,
  WasteRegistrationNumber,
  WasteTransferRequestNumber,
  EHSLocationID,
  WasteTransfReqStatus,
  CostCenter,
  WasteDisposalChannelNumber,
  WasteDisposalChannelName,
  EnvrmtWasteFcltyRegistrationID,
  EnvrmtWastePartFcltyName,
  Material,
  WasteStreamContainerType,
  EnvrmtWasteMgmtMethCode,
  EnvrmtWasteCode,
  EnvrmtWasteCodeShortDesc,
  EnvrmtWasteHazardCharcID,
  CmplRqVers,
  CmplRqVersName,
  WasteStreamRgtyCodeValueText,
  1 AS EnvrmtWasteOutgoingQuantity,
  1 AS EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteOutgoingQtyCode,
  EnvrmtWasteConfirmedQtyCode
FROM I_WasteAnalyticsCube
;

Depth:

C_WasteAnalyticsQuery view

I_WasteAnalyticsCube view