C_EWA_WasteDisposalOrderItemQ
Waste disposal order item Query
C_EWA_WasteDisposalOrderItemQ (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_WasteDisposalOrderItemQ is a Consumption CDS View that provides data about "Waste disposal order item Query" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalOrderItemC) and exposes 79 fields with key fields EWAWasteDisposalOrder, EWAWasteDisposalOrderItem. It has 2 associations to related views.
SAP Help Documentation
| Category | CDS Views for Waste Disposal Order |
|---|---|
| Data Category | Query |
Purpose
This CDS view retrieves all waste disposal orders and order items based on business partner, status, routes, waste, waste disposal facilities, service types, service areas, date range, and contract references so that unplanned and open orders can be tracked and fulfilled. 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 You can view this CDS view only in the privilege mode.
Structure
Parameters The parameters of the CDS view are as follows: P_DisplayVolumeUnit : This parameter is used to display volume in the input unit. P_DisplayWeightUnit : This parameter is used to display weight in the input unit. P_Language : This parameter is used to display descriptions in the input language. 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 WAWasteDisposalOrderItem Waste Disposal Order Item Attribute Internal Number for Waste Disposal Order Item EWARoute Planned Waste Disposal Order Route Attribute Planned Route for Waste Disposal Order EWAContainer Serial Number of Container Attribute Container Serial Number EWAServiceType Service Type Attribute Service Type EWAWaste Material Attribute Waste Material
This CDS view retrieves all waste disposal orders and order items based on business partner, status, routes, waste, waste disposal facilities, service types, service areas, date range, and contract references so that unplanned and open orders can be tracked and fulfilled. 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 You can view this CDS view only in the privilege mode.
Structure
Parameters The parameters of the CDS view are as follows: P_DisplayVolumeUnit : This parameter is used to display volume in the input unit. P_DisplayWeightUnit : This parameter is used to display weight in the input unit. P_Language : This parameter is used to display descriptions in the input language. 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 WAWasteDisposalOrderItem Waste Disposal Order Item Attribute Internal Number for Waste Disposal Order Item EWARoute Planned Waste Disposal Order Route Attribute Planned Route for Waste Disposal Order EWAContainer Serial Number of Container Attribute Container Serial Number EWAServiceType Service Type Attribute Service Type EWAWaste Material Attribute Waste Material
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 retrieves all waste disposal orders and order items based on business partner, status, routes, waste, waste disposal facilities, service types, service areas, date range, and contract references so that unplanned and open orders can be tracked and fulfilled. </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_WasteDisposalOrderItemC | I_EWA_WasteDisposalOrderItemC | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_DisplayWeightUnit | ewa_vdm_dispweightunit | |
| P_DisplayVolumeUnit | ewa_vdm_dispvolunit | |
| P_Language | ewa_vdm_language |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_EWA_WasteDisposalOrder | _ExtensionHead | $projection.EWAWasteDisposalOrder = _ExtensionHead.EWAWasteDisposalOrder |
| [0..1] | E_EWA_WasteDisposalOrderItem | _ExtensionItem | $projection.EWAWasteDisposalOrder = _ExtensionItem.EWAWasteDisposalOrder and $projection.EWAWasteDisposalOrderItem = _ExtensionItem.EWAWasteDisposalOrderItem |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CEWAWDOIQUERY | view | |
| EndUserText.label | Waste disposal order item Query | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Analytics.query | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_QUERY | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (79)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EWAWasteDisposalOrder | EWAWasteDisposalOrder | Internal Number for Identifying a Waste Disposal Order | |
| KEY | EWAWasteDisposalOrderItem | EWAWasteDisposalOrderItem | Sequence Number for Waste Disposal Order Item | |
| EWAWasteDisposalOrderItemText | EWAWasteDisposalOrderItemText | Waste Disposal Order Item Text | ||
| EWAWasteDsplOrderObjectNumber | EWAWasteDsplOrderObjectNumber | Waste Disposal Order Object Number | ||
| EWARouteNumber | EWARouteNumber | Planned Waste Disposal Order Route | ||
| EWARouteDescription | EWARouteDescription | Route Description | ||
| EWARouteSequenceValue | EWARouteSequenceValue | Number of stop in route | ||
| EWAOrderDate | EWAOrderDate | Planned Date for Execution of Waste Disposal Order | ||
| EWAWaste | EWAWaste | Waste | ||
| EWAWasteText | EWAWasteText | Product Description | ||
| Plant | Plant | Plant | ||
| PlantName | _EWAPlant | PlantName | Plant Name | |
| EWAWasteDisposalFacility | EWAWasteDisposalFacility | Identification of Waste Disposal Facility | ||
| EWAWasteDisposalFacilityDesc | EWAWasteDisposalFacilityDesc | WDO Facility Name | ||
| EWAContainer | EWAContainer | Serial Number of Container | ||
| EWAContainerCategory | EWAContainerCategory | Container Category | ||
| EWAContainerSerialNumber | EWAContainerSerialNumber | Container Serial Number | ||
| EWAContainerLocation | EWAContainerLocation | Functional Location | ||
| EWANewContainerCategory | EWANewContainerCategory | New Container Category | ||
| EWANewContainerSerialNumber | EWANewContainerSerialNumber | New Container Serial Number | ||
| EWANumberOfContainers | EWANumberOfContainers | Number of available containers | ||
| EWAContainerGroup | EWAContainerGroup | Container Group | ||
| EWAServiceType | EWAServiceType | Service Type | ||
| EWAServiceTypeDescription | EWAServiceTypeDescription | Text for Service Type | ||
| EWAServiceWindow | EWAServiceWindow | Service Window | ||
| EWAServiceNumber | EWAServiceNumber | Number of service frequency | ||
| EWAServiceNumberItem | EWAServiceNumberItem | Sequence Number of Service Frequency | ||
| EWAStartTime | EWAStartTime | Start time of a service window | ||
| EWAEndTime | EWAEndTime | End of service window | ||
| SalesContract | SalesContract | Sales Document | ||
| SalesContractItem | SalesContractItem | Item number of the SD document | ||
| EWAAddressID | EWAAddressID | Address Number | ||
| EWAPlannedOrderDate | EWAPlannedOrderDate | Planned Date for Execution of Waste Disposal Order | ||
| BusinessPartner | BusinessPartner | Business Partner Number | ||
| ShipToParty | ShipToParty | Ship To Party | ||
| EWACapacityNumber | EWACapacityNumber | Capacity Number | ||
| EWAWasteDsplOrdProcessingType | EWAWasteDsplOrdProcessingType | Processing of Waste Disposal Order | ||
| EWANumberOfGroupedContainers | EWANumberOfGroupedContainers | Number of Containers in Container Group | ||
| EWANewContainerGroup | EWANewContainerGroup | New Container Group | ||
| MaterialDocument | MaterialDocument | Number of Material Document | ||
| DebitMemoRequest | DebitMemoRequest | Subsequent Sales and Distribution Document | ||
| EWAWasteDsplOrdItmObjectNumber | EWAWasteDsplOrdItmObjectNumber | Waste disposal order item object number | ||
| EWAPlannedTime | EWAPlannedTime | Planned Time | ||
| EWASubcontrgPurchaseOrder | EWASubcontrgPurchaseOrder | Purchasing Document Number | ||
| EWASubcontrgPurchaseOrderItem | EWASubcontrgPurchaseOrderItem | Item Number of Purchasing Document | ||
| EWASubcontrgMaterialDocument | EWASubcontrgMaterialDocument | Number of Material Document | ||
| EWASubcontrgMaterialDocYear | EWASubcontrgMaterialDocYear | Subcont Material Doc Year | ||
| EWASubcontrgSalesOrder | EWASubcontrgSalesOrder | Sales Document | ||
| EWASubcontrgSalesOrderItem | EWASubcontrgSalesOrderItem | Sales Document Item | ||
| EWAConfirmedContainerCategory | EWAConfirmedContainerCategory | Confirmed Container Category | ||
| EWANumberOfConfirmedContainers | EWANumberOfConfirmedContainers | Confirmed Number of Containers | ||
| EWAWasteWeight | EWAWasteWeight | Weight of Waste Measured when Container Emptied | ||
| EWAWeightUnit | EWAWeightUnit | Unit of weight | ||
| DisplayWeightUnit | DisplayWeightUnit | Display Unit of Weight. | ||
| EWADisplayWasteWeight | EWADisplayWasteWeight | Waste Weight Display | ||
| EWAGrossWeight | EWAGrossWeight | Container weight including waste | ||
| EWADisplayGrossWeight | EWADisplayGrossWeight | Gross Weight Display | ||
| EWAEmptyWeight | EWAEmptyWeight | Weight of empty container | ||
| EWADisplayEmptyWeight | EWADisplayEmptyWeight | Gross Weight Display | ||
| EWAWasteVolume | EWAWasteVolume | Waste Volume Measured when Container Emptied | ||
| EWAVolumeUnit | EWAVolumeUnit | Volume Unit | ||
| EWAWasteDsplOrdItmCompltnTime | EWAWasteDsplOrdItmCompltnTime | WDOI Completion Time | ||
| EWAConfirmationNote1 | EWAConfirmationNote1 | Confirmation note | ||
| EWAFirstConfNoteDesc | EWAFirstConfNoteDesc | Text for confirmation note | ||
| EWAConfirmationNote2 | EWAConfirmationNote2 | Confirmation note | ||
| EWASecondConfNoteDesc | EWASecondConfNoteDesc | Text for confirmation note | ||
| EWAConfirmationNote3 | EWAConfirmationNote3 | Confirmation note | ||
| EWAThirdConfNoteDesc | EWAThirdConfNoteDesc | Text for confirmation note | ||
| EWANumberOfWeighingNotes | EWANumberOfWeighingNotes | Consecutive Number of Weighing Data Record | ||
| EWARefWasteDisposalOrder | EWARefWasteDisposalOrder | Number of Waste Disposal Order for Weighing Data Record | ||
| EWABillingQuantityValue | EWABillingQuantityValue | Billing quantity | ||
| EWAOrderDateYear | EWAOrderDateYear | Year of Creation | ||
| EWAOrderDateYearQuarter | EWAOrderDateYearQuarter | Year/Quarter of Creation | ||
| EWAOrderDateYearMonth | EWAOrderDateYearMonth | Year/Month of Creation | ||
| EWAWasteDsplOrderHeadStatus | EWAWasteDsplOrderHeadStatus | System status | ||
| EWAWasteDsplOrderStatusText | EWAWasteDsplOrderStatusText | Individual Status of an Object | ||
| EWAWasteDsplOrderItemStatus | EWAWasteDsplOrderItemStatus | WDO Item Status | ||
| EWAWasteDsplOrdItemStatusText | EWAWasteDsplOrdItemStatusText | Individual Status of an Object | ||
| EWAWasteDsplOrderNumberOfItems | EWAWasteDsplOrderNumberOfItems | Number of Order Items |
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_WasteDisposalOrderItemQ.
-- 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: CEWAWDOIQUERY
-- Parameters: P_DisplayWeightUnit : ewa_vdm_dispweightunit, P_DisplayVolumeUnit : ewa_vdm_dispvolunit, P_Language : ewa_vdm_language
CREATE VIEW C_EWA_WasteDisposalOrderItemQ AS
SELECT
EWAWasteDisposalOrder,
EWAWasteDisposalOrderItem,
EWAWasteDisposalOrderItemText,
EWAWasteDsplOrderObjectNumber,
EWARouteNumber,
EWARouteDescription,
EWARouteSequenceValue,
EWAOrderDate,
EWAWaste,
EWAWasteText,
Plant,
_EWAPlant.PlantName AS PlantName,
EWAWasteDisposalFacility,
EWAWasteDisposalFacilityDesc,
EWAContainer,
EWAContainerCategory,
EWAContainerSerialNumber,
EWAContainerLocation,
EWANewContainerCategory,
EWANewContainerSerialNumber,
EWANumberOfContainers,
EWAContainerGroup,
EWAServiceType,
EWAServiceTypeDescription,
EWAServiceWindow,
EWAServiceNumber,
EWAServiceNumberItem,
EWAStartTime,
EWAEndTime,
SalesContract,
SalesContractItem,
EWAAddressID,
EWAPlannedOrderDate,
BusinessPartner,
ShipToParty,
EWACapacityNumber,
EWAWasteDsplOrdProcessingType,
EWANumberOfGroupedContainers,
EWANewContainerGroup,
MaterialDocument,
DebitMemoRequest,
EWAWasteDsplOrdItmObjectNumber,
EWAPlannedTime,
EWASubcontrgPurchaseOrder,
EWASubcontrgPurchaseOrderItem,
EWASubcontrgMaterialDocument,
EWASubcontrgMaterialDocYear,
EWASubcontrgSalesOrder,
EWASubcontrgSalesOrderItem,
EWAConfirmedContainerCategory,
EWANumberOfConfirmedContainers,
EWAWasteWeight,
EWAWeightUnit,
DisplayWeightUnit,
EWADisplayWasteWeight,
EWAGrossWeight,
EWADisplayGrossWeight,
EWAEmptyWeight,
EWADisplayEmptyWeight,
EWAWasteVolume,
EWAVolumeUnit,
EWAWasteDsplOrdItmCompltnTime,
EWAConfirmationNote1,
EWAFirstConfNoteDesc,
EWAConfirmationNote2,
EWASecondConfNoteDesc,
EWAConfirmationNote3,
EWAThirdConfNoteDesc,
EWANumberOfWeighingNotes,
EWARefWasteDisposalOrder,
EWABillingQuantityValue,
EWAOrderDateYear,
EWAOrderDateYearQuarter,
EWAOrderDateYearMonth,
EWAWasteDsplOrderHeadStatus,
EWAWasteDsplOrderStatusText,
EWAWasteDsplOrderItemStatus,
EWAWasteDsplOrdItemStatusText,
EWAWasteDsplOrderNumberOfItems
FROM I_EWA_WasteDisposalOrderItemC
LEFT OUTER JOIN E_EWA_WasteDisposalOrder AS _ExtensionHead ON EWAWasteDisposalOrder = _ExtensionHead.EWAWasteDisposalOrder -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteDisposalOrderItem AS _ExtensionItem ON EWAWasteDisposalOrder = _ExtensionItem.EWAWasteDisposalOrder AND EWAWasteDisposalOrderItem = _ExtensionItem.EWAWasteDisposalOrderItem -- 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