What is I_EWA_WasteDisposalRouteCube in SAP S/4HANA?

I_EWA_WasteDisposalRouteCube is a composite CDS view in SAP S/4HANA. Waste Disposal Route - Cube It contains 117 fields.

Which tables does I_EWA_WasteDisposalRouteCube read from?

I_EWA_WasteDisposalRouteCube reads data from: I_EWA_WasteDisposalRouteCmpst.

What VDM layer is I_EWA_WasteDisposalRouteCube?

I_EWA_WasteDisposalRouteCube is classified as a Composite view that combines data from multiple basic views.

I_EWA_WasteDisposalRouteCube

DDL: I_EWA_WASTEDISPOSALROUTECUBE Type: view_entity COMPOSITE

117 Fields 1 Data Sources 1 Associations

Waste Disposal Route - Cube

I_EWA_WasteDisposalRouteCube (Composite)

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

Utilities

I_EWA_WasteDisposalRouteCube is a Composite CDS View (Cube) that provides data about "Waste Disposal Route - Cube" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalRouteCmpst) and exposes 117 fields with key fields EWARouteNumber, EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Route

Purpose
This CDS view allows you to fetch all routes and details of service item linked to route. It also fetches details like region, service types, service area and container categories so that routes with its sequencing can be tracked. It enables the retrieval of route identification along with equipment, service number item details with its service location, interval type, category and resources related to route. 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
Parameters The parameters of the CDS view are as follows: P_EWAActualDistanceUnit : This parameter is used to display unit of distance. P_EWAActualWeightUnit : This parameter is used to display unit of weight. P_EWAActualVolumeUnit : This parameter is used to display unit of volume. P_Language : This parameter is used to display language. Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWAServiceNumber Service Number Attribute Number of service frequency EWAServiceNumberItem Service Number Item Attribute Sequence Number of Service Frequency EWAValidToDate Service Valid To Date Attribute Date at Which a Time Slice Expires EWARouteNumber Route Number Attribute Planned Waste Disposal Order Route

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-WA
Capabilities	Data Provider for Analytical Queries, Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view allows you to fetch all routes and details of service item linked to route. It also fetches details like region, service types, service area and container categories so that routes with its sequencing can be tracked. It enables the retrieval of route identification along with equipment, service number item details with its service location, interval type, category and resources related to route.</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_WasteDisposalRouteCmpst	I_EWA_WasteDisposalRouteCmpst	from

Parameters (4)

Name	Type	Default
P_EWAActualDistanceUnit	ewa_vdm_dispdistanceunit
P_EWAActualWeightUnit	ewa_vdm_dispweightunit
P_EWAActualVolumeUnit	ewa_vdm_dispvolunit
P_Language	ewa_vdm_language

Associations (1)

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

Annotations (12)

Name	Value	Level
EndUserText.label	Waste Disposal Route - Cube	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
Analytics.internalName	#LOCAL	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (117)

Key	Field	Source Table	Source Field	Description
KEY	EWARouteNumber		EWARouteNumber	Planned Waste Disposal Order Route
KEY	EWAServiceNumber		EWAServiceNumber	Number of service frequency
KEY	EWAServiceNumberItem		EWAServiceNumberItem	Sequence Number of Service Frequency
KEY	EWAValidToDate		EWAValidToDate	Date at Which a Time Slice Expires
	EWAValidFromDate		EWAValidFromDate	Date from which time slice is valid
	MaintenanceObjectList		MaintenanceObjectList	Maintenance Object List
	MaintenanceObjectListItem		MaintenanceObjectListItem	Maintenance Object List Item
	EWAServiceValidToYear		EWAServiceValidToYear	Service Valid To Year
	EWAServiceValidToYearQuarter		EWAServiceValidToYearQuarter	Service Valid To Year Quarter
	EWAServiceValidToYearMonth		EWAServiceValidToYearMonth	Service Valid To Year Month
	EWAServiceValidFromYear		EWAServiceValidFromYear	Service Valid From Year
	EWAServiceValidFromYearQuarter		EWAServiceValidFromYearQuarter	Service Valid From Year Quarter
	EWAServiceValidFromYearMonth		EWAServiceValidFromYearMonth	Service Valid From Year Month
	EWARouteDescription		EWARouteDescription	Route Description
	EWARouteStartDate		EWARouteStartDate	Date from which the route is valid
	EWARouteObjectNumber		EWARouteObjectNumber	Route Object Number
	EWARouteStartYear			Route Start Year
	EWARouteStartYearQuarter			Route Start Year Quarter
	EWARouteStartYearMonth			Route Start Year Month
	EWANmbrOfRoute			Number of routes
	int4asEWANmbrOfService			Number of Services
	EWANmbrOfServiceItem		EWANmbrOfServiceItem	Number of Service Items
	EWARouteSequenceValue		EWARouteSequenceValue	Number of stop in route
	EWARouteServiceSequence		EWARouteServiceSequence	Consecutive Number of Service for Route
	EWARouteServiceToDate		EWARouteServiceToDate	To Date of Service for Route
	EWAServiceArea		EWAServiceArea	Service Area 1
	EWAServiceAreaDescription		EWAServiceAreaDescription	Service Area 1 Description
	EWAConfirmationCategory		EWAConfirmationCategory	Confirmation Category 1
	EWAServiceArea2		EWAServiceArea2	Secondary service area
	EWAServiceArea2Desc		EWAServiceArea2Desc	Service Area 2 Description
	EWAConfirmationCategory2		EWAConfirmationCategory2	Confirmation Category 2
	EWAServiceArea3		EWAServiceArea3	Tertiary service area
	EWAServiceArea3Desc		EWAServiceArea3Desc	Service Area 3 Description
	EWAConfirmationCategory3		EWAConfirmationCategory3	Confirmation Category 3
	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
	EWADistanceDisplayUnit			Display Planned Distance Unit
	EWAPlannedWeight		EWAPlannedWeight	Planned weight of route
	EWAPlannedWeightUnit		EWAPlannedWeightUnit	Planned Weight Unit
	EWADisplayPlannedWeightUnit			Display Planned Weight Unit
	EWARouteTargetPointValue		EWARouteTargetPointValue	Target Service Points for Route
	EWAShift		EWAShift	Shift
	EWAShiftDescription		EWAShiftDescription	Shift Description
	EWAFleetEquipment		EWAFleetEquipment	Vehicle Number (Equipment Number)
	EWAFleetEquipmentDesc		EWAFleetEquipmentDesc	Description of technical object
	EWAFleetCategory		EWAFleetCategory	Vehicle 1 Category
	EWAFleetObjectNumber		EWAFleetObjectNumber	Object number
	EWAFleetEquipmentGrossWeight		EWAFleetEquipmentGrossWeight	Vehicle 1 Gross Weight
	EWAFleetEquipmentWeightUnit		EWAFleetEquipmentWeightUnit	Vehicle 1 Weight Unit
	EWADisplayFleetEquipWeightUnit			Display Fleet Equipment Weight Unit
	EWAFleetEquipMaxLoadingWeight	_EWAWasteDisposalVehicle	EWAMaximumLoadingWeight	Vehicle 1 Max Loading Weight
	EWAFleetEquipLoadingWgtUnit	_EWAWasteDisposalVehicle	EWAWeightUnit	Unit of weight
	EWADspFleetEquipLoadingWgtUnit			Display Loading Weight Unit
	EWAVehicleLoadVolume	_EWAWasteDisposalVehicle	EWAVehicleLoadVolume	Display Vehicle 1 Max Loading Weight
	EWAFleetEquipLoadingVolUnit	_EWAWasteDisposalVehicle	EWAVolumeUnit	Display Loading Weight Unit
	EWADspFleetEquipLoadingVolUnit			Display Loading Volume Unit
	PlannedWorkCenterInternalID		PlannedWorkCenterInternalID	Planned Work Center Internal ID
	PlannedWorkCenterDesc		PlannedWorkCenterDesc	Planned Work Center Text
	Plant		Plant	Plant 1
	PlantName		PlantName	Plant Name
	EWAPlant2		EWAPlant2	Plant 2
	EWAPlant2Name		EWAPlant2Name	Plant 2 Name
	EWAPlant3		EWAPlant3	Plant 3
	EWAPlant3Name		EWAPlant3Name	Plant 3 Name
	EWAFleetEquipment2		EWAFleetEquipment2	Vehicle Number (Equipment Number)
	EWAFleetEquipment2Desc		EWAFleetEquipment2Desc	Description of technical object
	EWAPlndWorkCenterInternalID2		EWAPlndWorkCenterInternalID2	Planned Work Center Internal ID 2
	EWAPlndWorkCenterIntID2Desc		EWAPlndWorkCenterIntID2Desc	Planned Work Center Internal ID2 Text
	EWAFleetEquipment3		EWAFleetEquipment3	Vehicle Number (Equipment Number)
	EWAFleetEquipment3Desc		EWAFleetEquipment3Desc	Description of technical object
	EWAPlndWorkCenterInternalID3		EWAPlndWorkCenterInternalID3	Planned Work Center Internal ID 3
	EWAPlndWorkCenterIntID3Desc		EWAPlndWorkCenterIntID3Desc	Planned Work Center Internal ID3 Text
	EWARouteIsDeactivated		EWARouteIsDeactivated	Indicator to Show Whether Route Has Been Deactivated
	EWARouteDeactivationDate		EWARouteDeactivationDate	Date, From Which Route Is Inactive
	FactoryCalendar		FactoryCalendar	Factory Calendar
	EWAWasteManagementCalendar		EWAWasteManagementCalendar	Waste Management Calendar as Template for Route
	EWAWasteDisposalOrderForm		EWAWasteDisposalOrderForm	Application Form "Waste Disposal Orders in Full"
	EWAWasteDisposalOrderItemForm		EWAWasteDisposalOrderItemForm	Application Form "Waste Disposal Order Items"
	EWAWasteDisposalFacility		EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	EWAWasteDisposalFacilityDesc		EWAWasteDisposalFacilityDesc	Waste Disposal Facility Description
	EWAPoliticalStrucElem		EWAPoliticalStrucElem	Political regional structure element
	BusinessArea		BusinessArea	Business Area
	BusinessAreaName		BusinessAreaName	Business Area Description
	ControllingArea		ControllingArea	Controlling Area
	ControllingAreaName		ControllingAreaName	Controlling Area Description
	StorageLocation		StorageLocation	Location: Storage location in plant
	StorageLocationName		StorageLocationName	Storage Location Description
	EWAPlannedNumberOfContainers		EWAPlannedNumberOfContainers	Planned number of containers for route
	EWANumberOfContainers		EWANumberOfContainers	Number of available containers
	EWAContainer		EWAContainer	Equipment Number
	EWAContainerCategory		EWAContainerCategory	Container Category
	EWAContainerGroup		EWAContainerGroup	Container Group
	EWAContainerLocation		EWAContainerLocation	Functional Location
	AddressID		AddressID	Address Number
	OrganizationName1		OrganizationName1	Organization Name 1
	StreetName		StreetName	Street Name
	VillageName		VillageName	City (different from postal city)
	CityName		CityName	City Name
	DistrictName		DistrictName	District Name
	Region		Region	Region (State, Province, County)
	RegionName		RegionName	Region Name
	Country		Country	Country/Region Key
	EWAServiceType		EWAServiceType	Service Type
	EWAServiceTypeDescription		EWAServiceTypeDescription	Service Type Description
	EWAServiceCategory		EWAServiceCategory	Service Category
	EWAServiceGroup		EWAServiceGroup	Service Grouping
	numc3endasEWAServiceIntervalDuration			Service Interval Duration
	WorkCenter		WorkCenter	Work Center 1
	EWAWorkCenter2		EWAWorkCenter2	Work Center 2
	EWAWorkCenter3		EWAWorkCenter3	Work Center 3
	_EWAServiceType		_EWAServiceType
	_EWAWasteDisposalVehicle		_EWAWasteDisposalVehicle
	_CalendarValidTo		_CalendarValidTo
	_CalendarValidFrom		_CalendarValidFrom
	_CalendarRoute		_CalendarRoute

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_EWA_WasteDisposalRouteCube.
-- 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_EWAActualDistanceUnit : ewa_vdm_dispdistanceunit, P_EWAActualWeightUnit : ewa_vdm_dispweightunit, P_EWAActualVolumeUnit : ewa_vdm_dispvolunit, P_Language : ewa_vdm_language

CREATE VIEW I_EWA_WasteDisposalRouteCube AS
SELECT
  EWARouteNumber,
  EWAServiceNumber,
  EWAServiceNumberItem,
  EWAValidToDate,
  EWAValidFromDate,
  MaintenanceObjectList,
  MaintenanceObjectListItem,
  EWAServiceValidToYear,
  EWAServiceValidToYearQuarter,
  EWAServiceValidToYearMonth,
  EWAServiceValidFromYear,
  EWAServiceValidFromYearQuarter,
  EWAServiceValidFromYearMonth,
  EWARouteDescription,
  EWARouteStartDate,
  EWARouteObjectNumber,
  cast(_CalendarRoute.CalendarYear as creation_date_year) AS EWARouteStartYear,
  cast(_CalendarRoute.YearQuarter as creation_date_year_quarter) AS EWARouteStartYearQuarter,
  cast(_CalendarRoute.YearMonth as creation_date_year_month) AS EWARouteStartYearMonth,
  cast (1 as abap.int4) AS EWANmbrOfRoute,
  cast(case when EWAServiceNumber is null then 0 else 1 end as abap.int4) as EWANmbrOfService AS int4asEWANmbrOfService,
  EWANmbrOfServiceItem,
  EWARouteSequenceValue,
  EWARouteServiceSequence,
  EWARouteServiceToDate,
  EWAServiceArea,
  EWAServiceAreaDescription,
  EWAConfirmationCategory,
  EWAServiceArea2,
  EWAServiceArea2Desc,
  EWAConfirmationCategory2,
  EWAServiceArea3,
  EWAServiceArea3Desc,
  EWAConfirmationCategory3,
  EWAPlannedRouteTime,
  EWADrivingTimeUnit,
  EWAPlannedDistance,
  EWAPlannedDistanceUnit,
  $parameters.P_EWAActualDistanceUnit AS EWADistanceDisplayUnit,
  EWAPlannedWeight,
  EWAPlannedWeightUnit,
  $parameters.P_EWAActualWeightUnit AS EWADisplayPlannedWeightUnit,
  EWARouteTargetPointValue,
  EWAShift,
  EWAShiftDescription,
  EWAFleetEquipment,
  EWAFleetEquipmentDesc,
  EWAFleetCategory,
  EWAFleetObjectNumber,
  EWAFleetEquipmentGrossWeight,
  EWAFleetEquipmentWeightUnit,
  $parameters.P_EWAActualWeightUnit AS EWADisplayFleetEquipWeightUnit,
  _EWAWasteDisposalVehicle.EWAMaximumLoadingWeight AS EWAFleetEquipMaxLoadingWeight,
  _EWAWasteDisposalVehicle.EWAWeightUnit AS EWAFleetEquipLoadingWgtUnit,
  $parameters.P_EWAActualWeightUnit AS EWADspFleetEquipLoadingWgtUnit,
  _EWAWasteDisposalVehicle.EWAVehicleLoadVolume AS EWAVehicleLoadVolume,
  _EWAWasteDisposalVehicle.EWAVolumeUnit AS EWAFleetEquipLoadingVolUnit,
  $parameters.P_EWAActualVolumeUnit AS EWADspFleetEquipLoadingVolUnit,
  PlannedWorkCenterInternalID,
  PlannedWorkCenterDesc,
  Plant,
  PlantName,
  EWAPlant2,
  EWAPlant2Name,
  EWAPlant3,
  EWAPlant3Name,
  EWAFleetEquipment2,
  EWAFleetEquipment2Desc,
  EWAPlndWorkCenterInternalID2,
  EWAPlndWorkCenterIntID2Desc,
  EWAFleetEquipment3,
  EWAFleetEquipment3Desc,
  EWAPlndWorkCenterInternalID3,
  EWAPlndWorkCenterIntID3Desc,
  EWARouteIsDeactivated,
  EWARouteDeactivationDate,
  FactoryCalendar,
  EWAWasteManagementCalendar,
  EWAWasteDisposalOrderForm,
  EWAWasteDisposalOrderItemForm,
  EWAWasteDisposalFacility,
  EWAWasteDisposalFacilityDesc,
  EWAPoliticalStrucElem,
  BusinessArea,
  BusinessAreaName,
  ControllingArea,
  ControllingAreaName,
  StorageLocation,
  StorageLocationName,
  EWAPlannedNumberOfContainers,
  EWANumberOfContainers,
  EWAContainer,
  EWAContainerCategory,
  EWAContainerGroup,
  EWAContainerLocation,
  AddressID,
  OrganizationName1,
  StreetName,
  VillageName,
  CityName,
  DistrictName,
  Region,
  RegionName,
  Country,
  EWAServiceType,
  EWAServiceTypeDescription,
  EWAServiceCategory,
  EWAServiceGroup,
  case when EWAServiceHasDailyInterval = 'X' then EWAServiceDailyInterval when EWAServiceHasWeeklyInterval = 'X' then cast( EWAServiceWeeklyInterval as abap.numc(3)) when EWAServiceHasMonthlyInterval = 'X' then cast( EWAServiceMonthlyInterval as abap.numc(3)) else cast( '' as abap.numc(3)) end as EWAServiceIntervalDuration AS numc3endasEWAServiceIntervalDuration,
  WorkCenter,
  EWAWorkCenter2,
  EWAWorkCenter3
FROM I_EWA_WasteDisposalRouteCmpst
LEFT OUTER JOIN E_EWA_WasteDisposalRoute AS _ExtensionRoute ON EWARouteNumber = _ExtensionRoute.EWARouteNumber  -- association [0..1]
;

Depth:

I_EWA_WasteDisposalRouteCube view_entity

I_EWA_WasteDisposalRouteCmpst view_entity

C_EWA_WasteDisposalRouteQ view