What is C_EWA_WasteDisposalRouteDEX in SAP S/4HANA?

C_EWA_WasteDisposalRouteDEX is a consumption CDS view in SAP S/4HANA. Data Extraction For Waste Disposal Route It contains 94 fields.

Which tables does C_EWA_WasteDisposalRouteDEX read from?

C_EWA_WasteDisposalRouteDEX reads data from: I_EWA_WasteDisposalRoute.

What VDM layer is C_EWA_WasteDisposalRouteDEX?

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

C_EWA_WasteDisposalRouteDEX

DDL: C_EWA_WASTEDISPOSALROUTEDEX Type: view_entity CONSUMPTION

94 Fields 1 Data Sources 1 Associations

Data Extraction For Waste Disposal Route

C_EWA_WasteDisposalRouteDEX (Consumption)

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

Waste Disposal Route · Utilities

C_EWA_WasteDisposalRouteDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction For Waste Disposal Route" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalRoute) and exposes 94 fields with key field EWARouteNumber. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Route
Data Category	Fact

Purpose
This CDS view allows you to fetch all routes and their details like service types, service areas, confirmation categories, and equipment. 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 must have the following authorization objects assigned: E_ROUTE (Authorization Object for Route Maintenance)

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWARouteNumber Route Attribute Planned Waste Disposal Order Route EWAWaste Waste Attribute Waste EWAServiceArea Service Area Attribute Service Area

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-WA
Capabilities	Data Source for Data Extraction
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view allows you to fetch all routes and their details like service types, service areas, confirmation categories, and equipment.</p> <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 ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA, onpremise edition — Explore SAP S/4HANA Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_EWA_WasteDisposalRoute	I_EWA_WasteDisposalRoute	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_EWA_WasteDisposalRoute	_ExtensionRoute	`$projection.EWARouteNumber = _ExtensionRoute.EWARouteNumber`

Annotations (12)

Name	Value	Level
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Data Extraction For Waste Disposal Route	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.sapObjectNodeType.name	EWA_WasteDisposalRoute	view
ObjectModel.modelingPattern	#NONE	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (94)

Key	Field	Source Field	Description
KEY	EWARouteNumber	EWARouteNumber	Planned Waste Disposal Order Route
	EWARouteDescription	EWARouteDescription	Text for route
	EWARouteStartDate	EWARouteStartDate	Date from which the route is valid
	EWAServiceArea	EWAServiceArea	Service Area
	EWAConfirmationCategory	EWAConfirmationCategory	Confirmation category
	EWAServiceArea2	EWAServiceArea2	Secondary service area
	EWAConfirmationCategory2	EWAConfirmationCategory2	Confirmation category
	EWAServiceArea3	EWAServiceArea3	Tertiary service area
	EWAConfirmationCategory3	EWAConfirmationCategory3	Confirmation category
	EWAFleetCategory	EWAFleetCategory	Fleet Object Type
	FactoryCalendar	FactoryCalendar	Factory Calendar
	EWASrvcHasNonWorkdaysCrrtn	EWASrvcHasNonWorkdaysCrrtn	Correct non-workday
	EWAWasteManagementCalendar	EWAWasteManagementCalendar	Waste Management Calendar as Template for Route
	EWAPlannedVolume	EWAPlannedVolume	Planned volume of route
	EWAPlannedVolumeUnit	EWAPlannedVolumeUnit	Volume unit
	EWATargetNumberOfPremises	EWATargetNumberOfPremises	Target Number of Premises
	EWAPlannedNumberOfContainers	EWAPlannedNumberOfContainers	Planned number of containers for route
	EWAPlannedRouteTime	EWAPlannedRouteTime	Planned duration of route
	EWADrivingTimeUnit	EWADrivingTimeUnit	Unit of measure for travelling times
	EWAPlannedDistance	EWAPlannedDistance	Planned distance of route
	EWAPlannedDistanceUnit	EWAPlannedDistanceUnit	Distance Unit of Measure
	EWAPlannedWeight	EWAPlannedWeight	Planned weight of route
	EWAPlannedWeightUnit	EWAPlannedWeightUnit	Unit of weight
	EWAPoliticalStrucElem	EWAPoliticalStrucElem	Political regional structure element
	EWAWasteDisposalOrderForm	EWAWasteDisposalOrderForm	Application Form "Waste Disposal Orders in Full"
	EWAWasteDisposalOrderItemForm	EWAWasteDisposalOrderItemForm	Application Form "Waste Disposal Order Items"
	EWAWasteDsplOrdCoverSheetForm	EWAWasteDsplOrdCoverSheetForm	Application Form "Waste Disposal Orders Cover Sheet"
	EWAShift	EWAShift	Shift
	EWARouteTargetPointValue	EWARouteTargetPointValue	Target Service Points for Route
	EWAFleetEquipment	EWAFleetEquipment	Vehicle Number (Equipment Number)
	PlannedWorkCenterInternalID	PlannedWorkCenterInternalID	Object ID of the resource
	WorkCenter	WorkCenter	Work Center
	Plant	Plant	Valuation Area
	EWAFleetEquipment2	EWAFleetEquipment2	Vehicle Number (Equipment Number)
	EWAPlndWorkCenterInternalID2	EWAPlndWorkCenterInternalID2	Object ID of the resource
	EWAWorkCenter2	EWAWorkCenter2	Work Center
	EWAPlant2	EWAPlant2	Plant
	EWAFleetEquipment3	EWAFleetEquipment3	Vehicle Number (Equipment Number)
	EWAPlndWorkCenterInternalID3	EWAPlndWorkCenterInternalID3	Object ID of the resource
	EWAWorkCenter3	EWAWorkCenter3	Work Center
	EWAPlant3	EWAPlant3	Plant
	EWARouteIsDeactivated	EWARouteIsDeactivated	Indicator to Show Whether Route Has Been Deactivated
	EWARouteDeactivationDate	EWARouteDeactivationDate	Date, From Which Route Is Inactive
	EWARouteObjectNumber	EWARouteObjectNumber	Val. Obj. No.
	EWAMaintenancePlant	EWAMaintenancePlant	Maintenance Plant
	MaintenanceObjectLocation	MaintenanceObjectLocation	Location of maintenance object
	PlantSection	PlantSection	Plant Section
	BusinessArea	BusinessArea	Business Area
	ControllingArea	ControllingArea	Controlling Area
	CostCenter	CostCenter	Cost Center
	CompanyCode	CompanyCode	Receiver Company Code
	StandingOrderNumber	StandingOrderNumber	Standing order number
	SettlementOrdForServiceProcmt	SettlementOrdForServiceProcmt	Settlement order
	EWADeliveringPlant	EWADeliveringPlant	Delivering Plant
	StorageLocation	StorageLocation	Location: Storage location in plant
	EWACostCollectorLevel	EWACostCollectorLevel	Cost Collector for Waste Disposal Order
	EWAWasteDsplOrderInitialStatus	EWAWasteDsplOrderInitialStatus	Initial Status When Creating Waste Disposal Order
	MaterialGroup	MaterialGroup	Waste Fraction
	EWAWeighingCreationOnOrdLevel	EWAWeighingCreationOnOrdLevel	Header Weighing
	EWAWeighingCreationOnItemLevel	EWAWeighingCreationOnItemLevel	Item Weighing
	EWACreatedOnDate	EWACreatedOnDate	Record Created On
	EWACreatedByName	EWACreatedByName	Name of Person Responsible for Creating the Object
	EWAChangedOnDate	EWAChangedOnDate	Last Changed On
	EWAChangedByName	EWAChangedByName	Name of Person Who Changed Object
	EWAAuthorizationGroup	EWAAuthorizationGroup	Authorization Group
	EWAIsMarkedForDeletion	EWAIsMarkedForDeletion	Deletion Indicator
	_BusinessArea	_BusinessArea
	_CompanyCode	_CompanyCode
	_ControllingArea	_ControllingArea
	_CostCenter	_CostCenter
	_EWADeliveringPlant	_EWADeliveringPlant
	_EWAFleetCategory	_EWAFleetCategory
	_EWAFleetEquipment	_EWAFleetEquipment
	_EWAFleetEquipment2	_EWAFleetEquipment2
	_EWAFleetEquipment3	_EWAFleetEquipment3
	_EWAMaintenancePlant	_EWAMaintenancePlant
	_EWAPlant2	_EWAPlant2
	_EWAPlant3	_EWAPlant3
	_EWAPlndWorkCenterInternalID2	_EWAPlndWorkCenterInternalID2
	_EWAPlndWorkCenterInternalID3	_EWAPlndWorkCenterInternalID3
	_EWAPoliticalStrucElem	_EWAPoliticalStrucElem
	_EWAServiceArea	_EWAServiceArea
	_EWAServiceArea2	_EWAServiceArea2
	_EWAServiceArea3	_EWAServiceArea3
	_EWAShift	_EWAShift
	_FactoryCalendar	_FactoryCalendar
	_MaintenanceObjectLocation	_MaintenanceObjectLocation
	_MaterialGroup	_MaterialGroup
	_PlannedWorkCenterInternalID	_PlannedWorkCenterInternalID
	_Plant	_Plant
	_PlantSection	_PlantSection
	_SettlementOrdForServiceProcmt	_SettlementOrdForServiceProcmt
	_StandingOrderNumber	_StandingOrderNumber
	_StorageLocation	_StorageLocation

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_EWA_WasteDisposalRouteDEX.
-- 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.

CREATE VIEW C_EWA_WasteDisposalRouteDEX AS
SELECT
  EWARouteNumber,
  EWARouteDescription,
  EWARouteStartDate,
  EWAServiceArea,
  EWAConfirmationCategory,
  EWAServiceArea2,
  EWAConfirmationCategory2,
  EWAServiceArea3,
  EWAConfirmationCategory3,
  EWAFleetCategory,
  FactoryCalendar,
  EWASrvcHasNonWorkdaysCrrtn,
  EWAWasteManagementCalendar,
  EWAPlannedVolume,
  EWAPlannedVolumeUnit,
  EWATargetNumberOfPremises,
  EWAPlannedNumberOfContainers,
  EWAPlannedRouteTime,
  EWADrivingTimeUnit,
  EWAPlannedDistance,
  EWAPlannedDistanceUnit,
  EWAPlannedWeight,
  EWAPlannedWeightUnit,
  EWAPoliticalStrucElem,
  EWAWasteDisposalOrderForm,
  EWAWasteDisposalOrderItemForm,
  EWAWasteDsplOrdCoverSheetForm,
  EWAShift,
  EWARouteTargetPointValue,
  EWAFleetEquipment,
  PlannedWorkCenterInternalID,
  WorkCenter,
  Plant,
  EWAFleetEquipment2,
  EWAPlndWorkCenterInternalID2,
  EWAWorkCenter2,
  EWAPlant2,
  EWAFleetEquipment3,
  EWAPlndWorkCenterInternalID3,
  EWAWorkCenter3,
  EWAPlant3,
  EWARouteIsDeactivated,
  EWARouteDeactivationDate,
  EWARouteObjectNumber,
  EWAMaintenancePlant,
  MaintenanceObjectLocation,
  PlantSection,
  BusinessArea,
  ControllingArea,
  CostCenter,
  CompanyCode,
  StandingOrderNumber,
  SettlementOrdForServiceProcmt,
  EWADeliveringPlant,
  StorageLocation,
  EWACostCollectorLevel,
  EWAWasteDsplOrderInitialStatus,
  MaterialGroup,
  EWAWeighingCreationOnOrdLevel,
  EWAWeighingCreationOnItemLevel,
  EWACreatedOnDate,
  EWACreatedByName,
  EWAChangedOnDate,
  EWAChangedByName,
  EWAAuthorizationGroup,
  EWAIsMarkedForDeletion
FROM I_EWA_WasteDisposalRoute
LEFT OUTER JOIN E_EWA_WasteDisposalRoute AS _ExtensionRoute ON EWARouteNumber = _ExtensionRoute.EWARouteNumber  -- association [0..1]
;

Depth:

C_EWA_WasteDisposalRouteDEX view_entity

I_EWA_WasteDisposalRoute view_entity