C_EWA_WasteDisposalRouteQ
Waste Disposal Route - Query
C_EWA_WasteDisposalRouteQ (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Utilities
C_EWA_WasteDisposalRouteQ is a Consumption CDS View that provides data about "Waste Disposal Route - Query" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalRouteCube) and exposes 115 fields with key fields EWARouteNumber, EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate. It has 1 association to related views.
SAP Help Documentation
| Category | CDS Views for Route |
|---|---|
| Data Category | Query |
Purpose
This CDS view allows you to fetch all routes and their details based on specific regions, service types, service areas, and container categories so that routes with their sequencing can be tracked. You can also enable the retrieval of route identification along with equipment, service number item details with its service location, interval type, and category, and resources related to the 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 need to access it via another CDS view (privileged mode).
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 EWARouteNumber Route Number Attribute Route Number 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
This CDS view allows you to fetch all routes and their details based on specific regions, service types, service areas, and container categories so that routes with their sequencing can be tracked. You can also enable the retrieval of route identification along with equipment, service number item details with its service location, interval type, and category, and resources related to the 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 need to access it via another CDS view (privileged mode).
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 EWARouteNumber Route Number Attribute Route Number 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
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Utilities |
| Application Component | IS-U-WA |
| Capabilities | Analytical Query |
| Package | Utilities for SAP S/4HANA |
| Description | <p>This CDS view allows you to fetch all routes and their details based on specific regions, service types, service areas, and container categories so that routes with their sequencing can be tracked. You can also enable the retrieval of route identification along with equipment, service number item details with its service location, interval type, and category, and resources related to the 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_WasteDisposalRouteCube | I_EWA_WasteDisposalRouteCube | 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 | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CEWAROUTEQ | view | |
| EndUserText.label | Waste Disposal Route - Query | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Analytics.query | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_QUERY | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (115)
| 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 | ||
| EWARouteDescription | EWARouteDescription | Route Description | ||
| EWARouteObjectNumber | EWARouteObjectNumber | Route Object Number | ||
| EWARouteStartDate | EWARouteStartDate | Date from which the route is valid | ||
| EWARouteStartYear | EWARouteStartYear | Route Start Year | ||
| EWARouteStartYearQuarter | EWARouteStartYearQuarter | Route Start Year Quarter | ||
| EWARouteStartYearMonth | EWARouteStartYearMonth | Route Start Year Month | ||
| EWANmbrOfRoute | EWANmbrOfRoute | Number of routes | ||
| EWANmbrOfService | EWANmbrOfService | Number of Services | ||
| EWANmbrOfServiceItem | EWANmbrOfServiceItem | Number of Service Items | ||
| 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 | ||
| EWAServiceArea | EWAServiceArea | Service Area 1 | ||
| EWAServiceAreaDescription | EWAServiceAreaDescription | Service Area 1 Description | ||
| EWAConfirmationCategory | EWAConfirmationCategory | Confirmation Category | ||
| 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 | ||
| EWADisplayPlannedDistance | EWADisplayPlannedDistance | Display Planned Distance | ||
| EWADistanceDisplayUnit | EWADistanceDisplayUnit | Display Planned Distance Unit | ||
| EWAPlannedWeight | EWAPlannedWeight | Planned weight of route | ||
| EWAPlannedWeightUnit | EWAPlannedWeightUnit | Planned Weight Unit | ||
| EWADisplayPlannedWeight | EWADisplayPlannedWeight | Display Planned Weight | ||
| EWADisplayPlannedWeightUnit | EWADisplayPlannedWeightUnit | Display Planned Weight Unit | ||
| EWARouteTargetPointValue | EWARouteTargetPointValue | Target Service Points for Route | ||
| EWAShift | EWAShift | Shift | ||
| EWAShiftDescription | EWAShiftDescription | Shift Description | ||
| EWAFleetCategory | EWAFleetCategory | Fleet Object Type | ||
| EWAFleetObjectNumber | EWAFleetObjectNumber | Object number | ||
| EWAFleetEquipmentGrossWeight | EWAFleetEquipmentGrossWeight | Vehicle Gross Weight | ||
| EWAFleetEquipmentWeightUnit | EWAFleetEquipmentWeightUnit | Vehicle Weight Unit | ||
| EWADisplayFleetEquipGrossWgt | EWADisplayFleetEquipGrossWgt | Display Vehicle Gross Weight | ||
| EWADisplayFleetEquipWeightUnit | EWADisplayFleetEquipWeightUnit | Display Vehicle Weight Unit | ||
| EWAFleetEquipMaxLoadingWeight | EWAFleetEquipMaxLoadingWeight | Vehicle Max Loading Weight | ||
| EWAFleetEquipLoadingWgtUnit | EWAFleetEquipLoadingWgtUnit | Unit of weight | ||
| EWADspFleetEquipMaxLoadingWgt | EWADspFleetEquipMaxLoadingWgt | Display Vehicle Max Loading Weight | ||
| EWADspFleetEquipLoadingWgtUnit | EWADspFleetEquipLoadingWgtUnit | Display Loading Weight Unit | ||
| EWAVehicleLoadVolume | EWAVehicleLoadVolume | Vehicle Load Volume | ||
| EWAFleetEquipLoadingVolUnit | EWAFleetEquipLoadingVolUnit | Loading Volume Unit | ||
| EWADspFleetEquipLoadingVolume | EWADspFleetEquipLoadingVolume | Display Vehicle Load Volume | ||
| EWADspFleetEquipLoadingVolUnit | EWADspFleetEquipLoadingVolUnit | Display Loading Volume Unit | ||
| WorkCenter | WorkCenter | Work Center | ||
| PlannedWorkCenterInternalID | PlannedWorkCenterInternalID | Planned Work Center Internal ID | ||
| PlannedWorkCenterDesc | PlannedWorkCenterDesc | Planned Work Center Internal ID 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 | ||
| EWAFleetEquipment | EWAFleetEquipment | Vehicle Number (Equipment Number) | ||
| EWAFleetEquipmentDesc | EWAFleetEquipmentDesc | Description of technical object | ||
| EWAFleetEquipment2 | EWAFleetEquipment2 | Vehicle Number (Equipment Number) | ||
| EWAFleetEquipment2Desc | EWAFleetEquipment2Desc | Description of technical object | ||
| EWAWorkCenter2 | EWAWorkCenter2 | Work Center 2 | ||
| 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 | ||
| EWAWorkCenter3 | EWAWorkCenter3 | Work Center 3 | ||
| 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 | ||
| EWAWasteManagementCalendar | EWAWasteManagementCalendar | Waste Management Calendar as Template for Route | ||
| FactoryCalendar | FactoryCalendar | Factory Calendar | ||
| 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 | ||
| AddressID | AddressID | Address Number | ||
| 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 | ||
| 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 | ||
| 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 | ||
| MaintenanceObjectList | MaintenanceObjectList | Maintenance Object List | ||
| MaintenanceObjectListItem | MaintenanceObjectListItem | Maintenance Object List Item | ||
| EWAServiceType | EWAServiceType | Service Type | ||
| EWAServiceTypeDescription | EWAServiceTypeDescription | Service Type Description | ||
| EWAServiceCategory | EWAServiceCategory | Service Category | ||
| EWAServiceIntervalTypeDesc | EWAServiceIntervalTypeDesc | Service Interval Type | ||
| EWAServiceIntervalDuration | EWAServiceIntervalDuration | Service Interval Duration | ||
| EWARouteSequenceValue | EWARouteSequenceValue | Number of stop in route | ||
| EWARouteServiceSequence | EWARouteServiceSequence | Consecutive Number of Service for Route |
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_WasteDisposalRouteQ.
-- 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: CEWAROUTEQ
-- Parameters: P_EWAActualDistanceUnit : ewa_vdm_dispdistanceunit, P_EWAActualWeightUnit : ewa_vdm_dispweightunit, P_EWAActualVolumeUnit : ewa_vdm_dispvolunit, P_Language : ewa_vdm_language
CREATE VIEW C_EWA_WasteDisposalRouteQ AS
SELECT
EWARouteNumber,
EWAServiceNumber,
EWAServiceNumberItem,
EWAValidToDate,
EWAValidFromDate,
EWARouteDescription,
EWARouteObjectNumber,
EWARouteStartDate,
EWARouteStartYear,
EWARouteStartYearQuarter,
EWARouteStartYearMonth,
EWANmbrOfRoute,
EWANmbrOfService,
EWANmbrOfServiceItem,
EWAServiceValidToYear,
EWAServiceValidToYearQuarter,
EWAServiceValidToYearMonth,
EWAServiceValidFromYear,
EWAServiceValidFromYearQuarter,
EWAServiceValidFromYearMonth,
EWAServiceArea,
EWAServiceAreaDescription,
EWAConfirmationCategory,
EWAServiceArea2,
EWAServiceArea2Desc,
EWAConfirmationCategory2,
EWAServiceArea3,
EWAServiceArea3Desc,
EWAConfirmationCategory3,
EWAPlannedRouteTime,
EWADrivingTimeUnit,
EWAPlannedDistance,
EWAPlannedDistanceUnit,
EWADisplayPlannedDistance,
EWADistanceDisplayUnit,
EWAPlannedWeight,
EWAPlannedWeightUnit,
EWADisplayPlannedWeight,
EWADisplayPlannedWeightUnit,
EWARouteTargetPointValue,
EWAShift,
EWAShiftDescription,
EWAFleetCategory,
EWAFleetObjectNumber,
EWAFleetEquipmentGrossWeight,
EWAFleetEquipmentWeightUnit,
EWADisplayFleetEquipGrossWgt,
EWADisplayFleetEquipWeightUnit,
EWAFleetEquipMaxLoadingWeight,
EWAFleetEquipLoadingWgtUnit,
EWADspFleetEquipMaxLoadingWgt,
EWADspFleetEquipLoadingWgtUnit,
EWAVehicleLoadVolume,
EWAFleetEquipLoadingVolUnit,
EWADspFleetEquipLoadingVolume,
EWADspFleetEquipLoadingVolUnit,
WorkCenter,
PlannedWorkCenterInternalID,
PlannedWorkCenterDesc,
Plant,
PlantName,
EWAPlant2,
EWAPlant2Name,
EWAPlant3,
EWAPlant3Name,
EWAFleetEquipment,
EWAFleetEquipmentDesc,
EWAFleetEquipment2,
EWAFleetEquipment2Desc,
EWAWorkCenter2,
EWAPlndWorkCenterInternalID2,
EWAPlndWorkCenterIntID2Desc,
EWAFleetEquipment3,
EWAFleetEquipment3Desc,
EWAWorkCenter3,
EWAPlndWorkCenterInternalID3,
EWAPlndWorkCenterIntID3Desc,
EWARouteIsDeactivated,
EWARouteDeactivationDate,
EWAWasteManagementCalendar,
FactoryCalendar,
EWAWasteDisposalOrderForm,
EWAWasteDisposalOrderItemForm,
EWAWasteDisposalFacility,
EWAWasteDisposalFacilityDesc,
AddressID,
EWAPoliticalStrucElem,
BusinessArea,
BusinessAreaName,
ControllingArea,
ControllingAreaName,
StorageLocation,
StorageLocationName,
StreetName,
VillageName,
CityName,
DistrictName,
Region,
RegionName,
Country,
EWAPlannedNumberOfContainers,
EWANumberOfContainers,
EWAContainer,
EWAContainerCategory,
EWAContainerGroup,
EWAContainerLocation,
MaintenanceObjectList,
MaintenanceObjectListItem,
EWAServiceType,
EWAServiceTypeDescription,
EWAServiceCategory,
EWAServiceIntervalTypeDesc,
EWAServiceIntervalDuration,
EWARouteSequenceValue,
EWARouteServiceSequence
FROM I_EWA_WasteDisposalRouteCube
LEFT OUTER JOIN E_EWA_WasteDisposalRoute AS _ExtensionRoute ON EWARouteNumber = _ExtensionRoute.EWARouteNumber -- association [0..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