What is C_EWA_WasteDisposalOrderDEX in SAP S/4HANA?

C_EWA_WasteDisposalOrderDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Waste Disposal Order It contains 52 fields.

Which tables does C_EWA_WasteDisposalOrderDEX read from?

C_EWA_WasteDisposalOrderDEX reads data from: I_EWA_WasteDisposalOrder.

What VDM layer is C_EWA_WasteDisposalOrderDEX?

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

C_EWA_WasteDisposalOrderDEX

DDL: C_EWA_WASTEDISPOSALORDERDEX Type: view_entity CONSUMPTION

52 Fields 1 Data Sources 1 Associations

Data Extraction for Waste Disposal Order

C_EWA_WasteDisposalOrderDEX (Consumption)

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

EWA_WasteDisposalOrder · Utilities

C_EWA_WasteDisposalOrderDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Waste Disposal Order" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalOrder) and exposes 52 fields with key field EWAWasteDisposalOrder. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Waste Disposal Order

Purpose
This CDS view extracts waste order document header data to SAP Business Information Warehouse (SAP BW) or other external systems. 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_ORDER (Authorization Object for Waste Disposal Order )

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWAWasteDisposalOrder Waste Disposal Order Attribute Internal Number for Identifying a Waste Disposal Order EWARoute Planned Route Attribute Planned Route Number EWAWaste Material Attribute Material EWAWasteDisposalFacility Waste Disposal Facility Attribute Plant

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 extracts waste order document header data to SAP Business Information Warehouse (SAP BW) or other external systems. </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_WasteDisposalOrder	EWA_WasteDisposalOrder	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_EWA_WasteDisposalOrder	_ExtensionHead	`$projection.EWAWasteDisposalOrder = _ExtensionHead.EWAWasteDisposalOrder`

Annotations (12)

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

Fields (52)

Key	Field	Source Table	Source Field	Description
KEY	EWAWasteDisposalOrder	I_EWA_WasteDisposalOrder	EWAWasteDisposalOrder	Internal Number for Identifying a Waste Disposal Order
	EWAActualRoute	I_EWA_WasteDisposalOrder	EWAActualRoute	Actual Route of Waste Disposal Order
	EWAPurchaseContract	I_EWA_WasteDisposalOrder	EWAPurchaseContract	Number of principal purchase agreement
	EWAWasteDisposalOrderDate	I_EWA_WasteDisposalOrder	EWAWasteDisposalOrderDate	Planned Date for Execution of Waste Disposal Order
	EWAPlannedStartTime	I_EWA_WasteDisposalOrder	EWAPlannedStartTime	Planned Start Time of Waste Disposal Order
	EWAPlannedEndTime	I_EWA_WasteDisposalOrder	EWAPlannedEndTime	Planned Finish Time of Waste Disposal Order
	EWACapacityNumber	I_EWA_WasteDisposalOrder	EWACapacityNumber	Capacity Number
	EWARouteNumber	I_EWA_WasteDisposalOrder	EWARouteNumber	Planned Waste Disposal Order Route
	EWAWaste	I_EWA_WasteDisposalOrder	EWAWaste	Waste
	EWATargetNumberOfPremises	I_EWA_WasteDisposalOrder	EWATargetNumberOfPremises	Target Number of Premises
	EWAPlannedVolume	I_EWA_WasteDisposalOrder	EWAPlannedVolume	Planned volume of waste disposal order
	EWAPlannedVolumeUnit	I_EWA_WasteDisposalOrder	EWAPlannedVolumeUnit	Volume unit
	EWAPlannedNumberOfContainers	I_EWA_WasteDisposalOrder	EWAPlannedNumberOfContainers	Planned number of containers in waste disposal order
	EWAPlannedOrderTime	I_EWA_WasteDisposalOrder	EWAPlannedOrderTime	Planned duration of waste disposal order
	EWADrivingTimesUnit	I_EWA_WasteDisposalOrder	EWADrivingTimesUnit	Unit of measure for travelling times
	EWAPlannedDistance	I_EWA_WasteDisposalOrder	EWAPlannedDistance	Planned distance of waste disposal order
	EWAPlannedDistanceUnit	I_EWA_WasteDisposalOrder	EWAPlannedDistanceUnit	Distance Unit of Measure
	EWAPlannedWeight	I_EWA_WasteDisposalOrder	EWAPlannedWeight	Planned weight of waste disposal order
	EWAPlannedWeightUnit	I_EWA_WasteDisposalOrder	EWAPlannedWeightUnit	Unit of weight
	EWAWinterMaintenanceLevel	I_EWA_WasteDisposalOrder	EWAWinterMaintenanceLevel	Winter Maintenance Level
	EWAWasteManagementNote	I_EWA_WasteDisposalOrder	EWAWasteManagementNote	Waste Management Note
	EWAWasteDsplOrderObjectNumber	I_EWA_WasteDisposalOrder	EWAWasteDsplOrderObjectNumber	Object number
	EWAWasteDisposalFacility	I_EWA_WasteDisposalOrder	EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	Plant	I_EWA_WasteDisposalOrder	Plant	Valuation Area
	StorageLocation	I_EWA_WasteDisposalOrder	StorageLocation	Destination: Storage location in plant
	EWAWasteDisposalOrderText	I_EWA_WasteDisposalOrder	EWAWasteDisposalOrderText	Order Text
	EWASubcontrgPurchaseOrder	I_EWA_WasteDisposalOrder	EWASubcontrgPurchaseOrder	Purchasing Document Number
	EWASubcontrgPurchaseOrderItem	I_EWA_WasteDisposalOrder	EWASubcontrgPurchaseOrderItem	Item Number of Purchasing Document
	EWASubcontrgMaterialDocument	I_EWA_WasteDisposalOrder	EWASubcontrgMaterialDocument	Number of Material Document
	EWASubcontrgMaterialDocYear	I_EWA_WasteDisposalOrder	EWASubcontrgMaterialDocYear	Material Document Year
	EWASubcontrgSalesOrder	I_EWA_WasteDisposalOrder	EWASubcontrgSalesOrder	Sales Document
	EWASubcontrgSalesOrderItem	I_EWA_WasteDisposalOrder	EWASubcontrgSalesOrderItem	Sales Document Item
	EWAActualOrderDate	I_EWA_WasteDisposalOrder	EWAActualOrderDate	Actual Date of Waste Disposal Order
	EWAActualStartTime	I_EWA_WasteDisposalOrder	EWAActualStartTime	Actual Start Time for Waste Disposal Order
	EWAActualEndTime	I_EWA_WasteDisposalOrder	EWAActualEndTime	Actual Finish Fime for Waste Disposal Order
	EWAOrderHeadBreakTime	I_EWA_WasteDisposalOrder	EWAOrderHeadBreakTime	Total Length of Breaks
	EWAWasteDisposalOrder1stText	I_EWA_WasteDisposalOrder	EWAWasteDisposalOrder1stText	Vertikalization Text
	EWAWasteDisposalOrder2ndText	I_EWA_WasteDisposalOrder	EWAWasteDisposalOrder2ndText	Vertikalization Text
	EWAActualVolume	I_EWA_WasteDisposalOrder	EWAActualVolume	Actual volume of waste disposal order
	EWAVolumeUnit	I_EWA_WasteDisposalOrder	EWAVolumeUnit	Volume unit
	EWAActualNumberOfContainers	I_EWA_WasteDisposalOrder	EWAActualNumberOfContainers	Actual number of container in waste disposal order
	EWAActualWasteDisposalOrdTime	I_EWA_WasteDisposalOrder	EWAActualWasteDisposalOrdTime	Actual Duration of Waste Disposal Order
	EWAActualDistance	I_EWA_WasteDisposalOrder	EWAActualDistance	Actual distance of waste disposal order
	EWAActualDistanceUnit	I_EWA_WasteDisposalOrder	EWAActualDistanceUnit	Distance Unit of Measure
	EWAActualWeight	I_EWA_WasteDisposalOrder	EWAActualWeight	Actual weight of waste disposal order
	EWAActualWeightUnit	I_EWA_WasteDisposalOrder	EWAActualWeightUnit	Unit of weight
	EWAPurchaseContractItem	I_EWA_WasteDisposalOrder	EWAPurchaseContractItem	Item Number of Principal Purchase Agreement
	EWAPurchaseOrderQuantity	I_EWA_WasteDisposalOrder	EWAPurchaseOrderQuantity	Purchase Order Quantity
	EWAPurchaseOrderUnit	I_EWA_WasteDisposalOrder	EWAPurchaseOrderUnit	Purchase Order Unit of Measure
	EWAAltPurchaseContract	I_EWA_WasteDisposalOrder	EWAAltPurchaseContract	Subcontr. Handl.: Number of Sales Contract
	EWAAltPurchaseContractItem	I_EWA_WasteDisposalOrder	EWAAltPurchaseContractItem	Subcontr. Handl.: Number of Sales Contract
	EWAIsMarkedForDeletion	I_EWA_WasteDisposalOrder	EWAIsMarkedForDeletion	Deletion Indicator

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_WasteDisposalOrderDEX.
-- 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_WasteDisposalOrderDEX AS
SELECT
  EWA_WasteDisposalOrder.EWAWasteDisposalOrder AS EWAWasteDisposalOrder,
  EWA_WasteDisposalOrder.EWAActualRoute AS EWAActualRoute,
  EWA_WasteDisposalOrder.EWAPurchaseContract AS EWAPurchaseContract,
  EWA_WasteDisposalOrder.EWAWasteDisposalOrderDate AS EWAWasteDisposalOrderDate,
  EWA_WasteDisposalOrder.EWAPlannedStartTime AS EWAPlannedStartTime,
  EWA_WasteDisposalOrder.EWAPlannedEndTime AS EWAPlannedEndTime,
  EWA_WasteDisposalOrder.EWACapacityNumber AS EWACapacityNumber,
  EWA_WasteDisposalOrder.EWARouteNumber AS EWARouteNumber,
  EWA_WasteDisposalOrder.EWAWaste AS EWAWaste,
  EWA_WasteDisposalOrder.EWATargetNumberOfPremises AS EWATargetNumberOfPremises,
  EWA_WasteDisposalOrder.EWAPlannedVolume AS EWAPlannedVolume,
  EWA_WasteDisposalOrder.EWAPlannedVolumeUnit AS EWAPlannedVolumeUnit,
  EWA_WasteDisposalOrder.EWAPlannedNumberOfContainers AS EWAPlannedNumberOfContainers,
  EWA_WasteDisposalOrder.EWAPlannedOrderTime AS EWAPlannedOrderTime,
  EWA_WasteDisposalOrder.EWADrivingTimesUnit AS EWADrivingTimesUnit,
  EWA_WasteDisposalOrder.EWAPlannedDistance AS EWAPlannedDistance,
  EWA_WasteDisposalOrder.EWAPlannedDistanceUnit AS EWAPlannedDistanceUnit,
  EWA_WasteDisposalOrder.EWAPlannedWeight AS EWAPlannedWeight,
  EWA_WasteDisposalOrder.EWAPlannedWeightUnit AS EWAPlannedWeightUnit,
  EWA_WasteDisposalOrder.EWAWinterMaintenanceLevel AS EWAWinterMaintenanceLevel,
  EWA_WasteDisposalOrder.EWAWasteManagementNote AS EWAWasteManagementNote,
  EWA_WasteDisposalOrder.EWAWasteDsplOrderObjectNumber AS EWAWasteDsplOrderObjectNumber,
  EWA_WasteDisposalOrder.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  EWA_WasteDisposalOrder.Plant AS Plant,
  EWA_WasteDisposalOrder.StorageLocation AS StorageLocation,
  EWA_WasteDisposalOrder.EWAWasteDisposalOrderText AS EWAWasteDisposalOrderText,
  EWA_WasteDisposalOrder.EWASubcontrgPurchaseOrder AS EWASubcontrgPurchaseOrder,
  EWA_WasteDisposalOrder.EWASubcontrgPurchaseOrderItem AS EWASubcontrgPurchaseOrderItem,
  EWA_WasteDisposalOrder.EWASubcontrgMaterialDocument AS EWASubcontrgMaterialDocument,
  EWA_WasteDisposalOrder.EWASubcontrgMaterialDocYear AS EWASubcontrgMaterialDocYear,
  EWA_WasteDisposalOrder.EWASubcontrgSalesOrder AS EWASubcontrgSalesOrder,
  EWA_WasteDisposalOrder.EWASubcontrgSalesOrderItem AS EWASubcontrgSalesOrderItem,
  EWA_WasteDisposalOrder.EWAActualOrderDate AS EWAActualOrderDate,
  EWA_WasteDisposalOrder.EWAActualStartTime AS EWAActualStartTime,
  EWA_WasteDisposalOrder.EWAActualEndTime AS EWAActualEndTime,
  EWA_WasteDisposalOrder.EWAOrderHeadBreakTime AS EWAOrderHeadBreakTime,
  EWA_WasteDisposalOrder.EWAWasteDisposalOrder1stText AS EWAWasteDisposalOrder1stText,
  EWA_WasteDisposalOrder.EWAWasteDisposalOrder2ndText AS EWAWasteDisposalOrder2ndText,
  EWA_WasteDisposalOrder.EWAActualVolume AS EWAActualVolume,
  EWA_WasteDisposalOrder.EWAVolumeUnit AS EWAVolumeUnit,
  EWA_WasteDisposalOrder.EWAActualNumberOfContainers AS EWAActualNumberOfContainers,
  EWA_WasteDisposalOrder.EWAActualWasteDisposalOrdTime AS EWAActualWasteDisposalOrdTime,
  EWA_WasteDisposalOrder.EWAActualDistance AS EWAActualDistance,
  EWA_WasteDisposalOrder.EWAActualDistanceUnit AS EWAActualDistanceUnit,
  EWA_WasteDisposalOrder.EWAActualWeight AS EWAActualWeight,
  EWA_WasteDisposalOrder.EWAActualWeightUnit AS EWAActualWeightUnit,
  EWA_WasteDisposalOrder.EWAPurchaseContractItem AS EWAPurchaseContractItem,
  EWA_WasteDisposalOrder.EWAPurchaseOrderQuantity AS EWAPurchaseOrderQuantity,
  EWA_WasteDisposalOrder.EWAPurchaseOrderUnit AS EWAPurchaseOrderUnit,
  EWA_WasteDisposalOrder.EWAAltPurchaseContract AS EWAAltPurchaseContract,
  EWA_WasteDisposalOrder.EWAAltPurchaseContractItem AS EWAAltPurchaseContractItem,
  EWA_WasteDisposalOrder.EWAIsMarkedForDeletion AS EWAIsMarkedForDeletion
FROM I_EWA_WasteDisposalOrder AS EWA_WasteDisposalOrder
LEFT OUTER JOIN E_EWA_WasteDisposalOrder AS _ExtensionHead ON EWAWasteDisposalOrder = _ExtensionHead.EWAWasteDisposalOrder  -- association [0..1]
;

Depth:

C_EWA_WasteDisposalOrderDEX view_entity

I_EWA_WasteDisposalOrder view_entity