I_EWA_WasteDplOrdResourceC

DDL: I_EWA_WASTEDPLORDRESOURCEC SQL: IEWAWDORES Type: view COMPOSITE
24 Fields 1 Data Sources 1 Associations

Waste Dspl Ord Resource - Cube

I_EWA_WasteDplOrdResourceC is a Composite CDS View (Cube) that provides data about "Waste Dspl Ord Resource - Cube" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDsplOrderResource) and exposes 24 fields with key fields EWAWasteDisposalOrder, EWAResourceSequenceNumber. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Waste Disposal Order
Data CategoryCube
StatusResource Status
Purpose
This CDS view retrieves all of the resource fields, such as vehicle and staff-related, for any given waste order number. 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: B_BUP_PCPT ( Business Partner: Purpose Completed) E_ORDER (Authorization Object for Waste Disposal Order)

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 EWAResourceSequenceNumber r Sequence Number Attribute Resource Sequence Number for Waste Disposal Order Item EWAFleetEquipment Equipment Number Attribute Identification of equipment number PlannedWorkCenterInternalID Resource Object ID Attribute Identification of Object ID for Resource EWAResourceStatus Resource Status Attribute Identification of status for Vehicle or Staff ControllingDocument Resource Controlling Document Attribute Identification of resource controlling document

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_EWA_WasteDsplOrderResource EWAWasteDsplOrderResource from

Parameters (3)

NameTypeDefault
P_EWAActualDurationUnit ewa_vdm_dispdurationunit
P_EWAActualDistanceUnit ewa_vdm_dispdistanceunit
P_Language ewa_vdm_language

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EWA_WasteDisposalOrder _EWAWasteDisposalOrder $projection.EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IEWAWDORES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Waste Dspl Ord Resource - Cube view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE 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 (24)

KeyFieldSource TableSource FieldDescription
KEY EWAWasteDisposalOrder EWAWasteDisposalOrder WD Order
KEY EWAResourceSequenceNumber EWAResourceSequenceNumber Sequence Number
EWAFleetEquipment EWAFleetEquipment Equ. Nr. Vehicle
EquipmentName
PlannedWorkCenterInternalID PlannedWorkCenterInternalID WorkCtrGp plan.
PersonnelNumber PersonnelNumber Personnel No.
HCMPosition HCMPosition Position ID
HCMJob HCMJob Package ID
EWAResourceStatus EWAResourceStatus Workflow Status
EWAActualStartTime EWAActualStartTime Actual Start
EWAActualEndTime EWAActualEndTime Actual FT
EWAOrderResBreakTime EWAOrderResBreakTime Break Length
EWAActualDuration EWAActualDuration Actual Duration
EWAActualDurationUnit EWAActualDurationUnit Un/actual dur.
EWAActDurationDisplayUnit Display Duration Unit
EWADrivingDistance EWADrivingDistance Route
EWADistanceUnit EWADistanceUnit Unit of Measure
EWADistanceDisplayUnit Display Distance Unit
EWAResourceCheckDate EWAResourceCheckDate Ck Clr.Time
EWAResourceCheckTime EWAResourceCheckTime Time
ControllingDocument ControllingDocument Document Number
EWARouteNumber _EWAWasteDisposalOrder EWARouteNumber
EWARouteDescription
_EWAWasteDisposalOrder _EWAWasteDisposalOrder

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_WasteDplOrdResourceC.
-- 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: IEWAWDORES
-- Parameters: P_EWAActualDurationUnit : ewa_vdm_dispdurationunit, P_EWAActualDistanceUnit : ewa_vdm_dispdistanceunit, P_Language : ewa_vdm_language

CREATE VIEW I_EWA_WasteDplOrdResourceC AS
SELECT
  EWAWasteDisposalOrder,
  EWAResourceSequenceNumber,
  EWAFleetEquipment,
  EWAWasteDsplOrderResource._EWAFleetEquipment._EquipmentText[1: Language=$parameters.P_Language].EquipmentName AS EquipmentName,
  PlannedWorkCenterInternalID,
  PersonnelNumber,
  HCMPosition,
  HCMJob,
  EWAResourceStatus,
  EWAActualStartTime,
  EWAActualEndTime,
  EWAOrderResBreakTime,
  EWAActualDuration,
  EWAActualDurationUnit,
  $parameters.P_EWAActualDurationUnit AS EWAActDurationDisplayUnit,
  EWADrivingDistance,
  EWADistanceUnit,
  $parameters.P_EWAActualDistanceUnit AS EWADistanceDisplayUnit,
  EWAResourceCheckDate,
  EWAResourceCheckTime,
  ControllingDocument,
  _EWAWasteDisposalOrder.EWARouteNumber AS EWARouteNumber,
  _EWAWasteDisposalOrder._EWAWasteDisposalRoute.EWARouteDescription AS EWARouteDescription
FROM I_EWA_WasteDsplOrderResource AS EWAWasteDsplOrderResource
LEFT OUTER JOIN I_EWA_WasteDisposalOrder AS _EWAWasteDisposalOrder ON EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder  -- association [0..1]
;

Learn More