I_EWA_WasteDisposalRouteCmpst
Waste Disposal Route Composite
I_EWA_WasteDisposalRouteCmpst is a Composite CDS View that provides data about "Waste Disposal Route Composite" in SAP S/4HANA. It reads from 1 data source (I_EWA_WasteDisposalRoute) and exposes 162 fields with key fields EWARouteNumber, EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_EWA_WasteDisposalRoute | EWARoute | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_Language | sylangu |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_EWA_WasteDisposalVehicle | _EWAWasteDisposalVehicle | $projection.EWAFleetObjectNumber = _EWAWasteDisposalVehicle.EWAFleetObjectNumber |
| [0..1] | I_CalendarDate | _CalendarValidTo | $projection.EWAValidToDate = _CalendarValidTo.CalendarDate |
| [0..1] | I_CalendarDate | _CalendarValidFrom | $projection.EWAValidFromDate = _CalendarValidFrom.CalendarDate |
| [0..1] | I_CalendarDate | _CalendarRoute | $projection.EWARouteStartDate = _CalendarRoute.CalendarDate |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Waste Disposal Route Composite | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| VDM.viewType | #COMPOSITE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (162)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EWARouteNumber | I_EWA_WasteDisposalRoute | EWARouteNumber | Vehicle route |
| KEY | EWAServiceNumber | EWAService | EWAServiceNumber | |
| KEY | EWAServiceNumberItem | EWAService | EWAServiceNumberItem | |
| KEY | EWAValidToDate | EWAService | EWAValidToDate | |
| EWAValidFromDate | EWAService | EWAValidFromDate | ||
| MaintenanceObjectList | ||||
| MaintenanceObjectListItem | ||||
| EWARouteDescription | I_EWA_WasteDisposalRoute | EWARouteDescription | Text for route | |
| EWARouteStartDate | I_EWA_WasteDisposalRoute | EWARouteStartDate | Valid from | |
| EWARouteObjectNumber | I_EWA_WasteDisposalRoute | EWARouteObjectNumber | Val. Obj. No. | |
| EWASrvcHasNonWorkdaysCrrtn | I_EWA_WasteDisposalRoute | EWASrvcHasNonWorkdaysCrrtn | Correct Non-WD | |
| EWAPlannedVolume | I_EWA_WasteDisposalRoute | EWAPlannedVolume | Planned volume | |
| EWAPlannedVolumeUnit | I_EWA_WasteDisposalRoute | EWAPlannedVolumeUnit | Volume unit | |
| EWATargetNumberOfPremises | I_EWA_WasteDisposalRoute | EWATargetNumberOfPremises | Targ. No. Prem. | |
| EWAWasteDsplOrdCoverSheetForm | I_EWA_WasteDisposalRoute | EWAWasteDsplOrdCoverSheetForm | Cov. Sheet Form | |
| EWAMaintenancePlant | I_EWA_WasteDisposalRoute | EWAMaintenancePlant | MaintPlant | |
| MaintenanceObjectLocation | I_EWA_WasteDisposalRoute | MaintenanceObjectLocation | Location | |
| PlantSection | I_EWA_WasteDisposalRoute | PlantSection | Plant Section | |
| CostCenter | I_EWA_WasteDisposalRoute | CostCenter | Cost Center | |
| CompanyCode | I_EWA_WasteDisposalRoute | CompanyCode | Receiver Company Code | |
| StandingOrderNumber | I_EWA_WasteDisposalRoute | StandingOrderNumber | StandgOrder | |
| SettlementOrdForServiceProcmt | I_EWA_WasteDisposalRoute | SettlementOrdForServiceProcmt | SettlementOrder | |
| EWADeliveringPlant | I_EWA_WasteDisposalRoute | EWADeliveringPlant | Plant | |
| EWACostCollectorLevel | I_EWA_WasteDisposalRoute | EWACostCollectorLevel | Cost Coll. WDO. | |
| EWAWasteDsplOrderInitialStatus | I_EWA_WasteDisposalRoute | EWAWasteDsplOrderInitialStatus | Initial Status | |
| MaterialGroup | I_EWA_WasteDisposalRoute | MaterialGroup | Product Group | |
| EWAWeighingCreationOnOrdLevel | I_EWA_WasteDisposalRoute | EWAWeighingCreationOnOrdLevel | Header Weighing | |
| EWAWeighingCreationOnItemLevel | I_EWA_WasteDisposalRoute | EWAWeighingCreationOnItemLevel | Item Weighing | |
| EWACreatedOnDate | I_EWA_WasteDisposalRoute | EWACreatedOnDate | Entered On | |
| EWACreatedByName | I_EWA_WasteDisposalRoute | EWACreatedByName | Created By | |
| EWAChangedOnDate | I_EWA_WasteDisposalRoute | EWAChangedOnDate | Obsolete | |
| EWAChangedByName | I_EWA_WasteDisposalRoute | EWAChangedByName | Changed By | |
| EWAAuthorizationGroup | I_EWA_WasteDisposalRoute | EWAAuthorizationGroup | AuthorizGroup | |
| EWAIsMarkedForDeletion | I_EWA_WasteDisposalRoute | EWAIsMarkedForDeletion | End Contract | |
| EWAServiceValidToYear | ||||
| EWAServiceValidToYearQuarter | ||||
| EWAServiceValidToYearMonth | ||||
| EWAServiceValidFromYear | ||||
| EWAServiceValidFromYearQuarter | ||||
| EWAServiceValidFromYearMonth | ||||
| EWARouteSequenceValue | EWAService | EWARouteSequenceValue | ||
| EWARouteServiceSequence | EWAService | EWARouteServiceSequence | ||
| EWARouteServiceToDate | EWAService | EWARouteServiceToDate | ||
| EWAServiceArea | I_EWA_WasteDisposalRoute | EWAServiceArea | Service Area | |
| EWAServiceAreaDescription | ||||
| EWAConfirmationCategory | I_EWA_WasteDisposalRoute | EWAConfirmationCategory | Confirmtn cat. | |
| EWAServiceArea2 | I_EWA_WasteDisposalRoute | EWAServiceArea2 | Secondary SA | |
| EWAServiceArea2Desc | ||||
| EWAConfirmationCategory2 | I_EWA_WasteDisposalRoute | EWAConfirmationCategory2 | Confirmtn cat. | |
| EWAServiceArea3 | I_EWA_WasteDisposalRoute | EWAServiceArea3 | Tertiary SA | |
| EWAServiceArea3Desc | ||||
| EWAConfirmationCategory3 | I_EWA_WasteDisposalRoute | EWAConfirmationCategory3 | Confirmtn cat. | |
| EWAPlannedRouteTime | I_EWA_WasteDisposalRoute | EWAPlannedRouteTime | Pld duration | |
| EWADrivingTimeUnit | I_EWA_WasteDisposalRoute | EWADrivingTimeUnit | Trav. times | |
| EWAPlannedDistance | I_EWA_WasteDisposalRoute | EWAPlannedDistance | Pld distance | |
| EWAPlannedDistanceUnit | I_EWA_WasteDisposalRoute | EWAPlannedDistanceUnit | UoM-Distance | |
| EWAPlannedWeight | I_EWA_WasteDisposalRoute | EWAPlannedWeight | Planned weight | |
| EWAPlannedWeightUnit | I_EWA_WasteDisposalRoute | EWAPlannedWeightUnit | Weight Unit | |
| EWARouteTargetPointValue | I_EWA_WasteDisposalRoute | EWARouteTargetPointValue | Targ.Ser.Points | |
| EWAShift | I_EWA_WasteDisposalRoute | EWAShift | Shift | |
| EWAShiftDescription | ||||
| EWAFleetEquipment | I_EWA_WasteDisposalRoute | EWAFleetEquipment | Equ. Nr. Vehicle | |
| EWAFleetEquipmentDesc | ||||
| EWAFleetCategory | I_EWA_WasteDisposalRoute | EWAFleetCategory | Fleet Obj. Type | |
| EWAFleetObjectNumber | ||||
| EWAFleetEquipmentGrossWeight | ||||
| EWAFleetEquipmentWeightUnit | ||||
| WorkCenter | I_EWA_WasteDisposalRoute | WorkCenter | Work Center | |
| PlannedWorkCenterInternalID | I_EWA_WasteDisposalRoute | PlannedWorkCenterInternalID | Object ID | |
| PlannedWorkCenterDesc | ||||
| Plant | I_EWA_WasteDisposalRoute | Plant | Valuation Area | |
| PlantName | ||||
| EWAPlant2 | I_EWA_WasteDisposalRoute | EWAPlant2 | Plant | |
| EWAPlant2Name | ||||
| EWAPlant3 | I_EWA_WasteDisposalRoute | EWAPlant3 | Plant | |
| EWAPlant3Name | ||||
| EWAFleetEquipment2 | I_EWA_WasteDisposalRoute | EWAFleetEquipment2 | Vehicle | |
| EWAFleetEquipment2Desc | ||||
| EWAWorkCenter2 | I_EWA_WasteDisposalRoute | EWAWorkCenter2 | ||
| EWAPlndWorkCenterInternalID2 | I_EWA_WasteDisposalRoute | EWAPlndWorkCenterInternalID2 | Object ID | |
| EWAPlndWorkCenterIntID2Desc | ||||
| EWAFleetEquipment3 | I_EWA_WasteDisposalRoute | EWAFleetEquipment3 | Vehicle | |
| EWAFleetEquipment3Desc | ||||
| EWAWorkCenter3 | I_EWA_WasteDisposalRoute | EWAWorkCenter3 | ||
| EWAPlndWorkCenterInternalID3 | I_EWA_WasteDisposalRoute | EWAPlndWorkCenterInternalID3 | Object ID | |
| EWAPlndWorkCenterIntID3Desc | ||||
| EWARouteIsDeactivated | I_EWA_WasteDisposalRoute | EWARouteIsDeactivated | WO Locked | |
| EWARouteDeactivationDate | I_EWA_WasteDisposalRoute | EWARouteDeactivationDate | Inactive Date | |
| EWAWasteManagementCalendar | I_EWA_WasteDisposalRoute | EWAWasteManagementCalendar | Waste Man. Cal. | |
| FactoryCalendar | I_EWA_WasteDisposalRoute | FactoryCalendar | Factory Calendar | |
| EWAWasteDisposalOrderForm | I_EWA_WasteDisposalRoute | EWAWasteDisposalOrderForm | WD Order Form | |
| EWAWasteDisposalOrderItemForm | I_EWA_WasteDisposalRoute | EWAWasteDisposalOrderItemForm | Order Item Form | |
| EWAWasteDisposalFacility | ||||
| EWAWasteDisposalFacilityDesc | ||||
| EWAPoliticalStrucElem | I_EWA_WasteDisposalRoute | EWAPoliticalStrucElem | Structure Group | |
| BusinessArea | I_EWA_WasteDisposalRoute | BusinessArea | Business Area | |
| BusinessAreaName | ||||
| ControllingArea | I_EWA_WasteDisposalRoute | ControllingArea | Controlling Area | |
| ControllingAreaName | ||||
| StorageLocation | I_EWA_WasteDisposalRoute | StorageLocation | StorageLocation | |
| StorageLocationName | ||||
| EWAPlannedNumberOfContainers | I_EWA_WasteDisposalRoute | EWAPlannedNumberOfContainers | Plnd no. cont. | |
| EWANumberOfContainers | EWAService | EWANumberOfContainers | ||
| EWAContainer | ||||
| EWAContainerCategory | ||||
| EWAContainerGroup | ||||
| EWAContainerLocation | ||||
| AddressID | ||||
| OrganizationName1 | ||||
| StreetName | ||||
| VillageName | ||||
| CityName | ||||
| DistrictName | ||||
| Region | ||||
| RegionName | ||||
| Country | ||||
| EWAServiceType | EWAService | EWAServiceType | ||
| EWAServiceTypeDescription | ||||
| EWAServiceCategory | ||||
| EWAServiceGroup | EWAService | EWAServiceGroup | ||
| EWAServiceHasDailyInterval | EWAService | EWAServiceHasDailyInterval | ||
| EWAServiceHasWeeklyInterval | EWAService | EWAServiceHasWeeklyInterval | ||
| EWAServiceHasMonthlyInterval | EWAService | EWAServiceHasMonthlyInterval | ||
| EWAServiceDailyInterval | EWAService | EWAServiceDailyInterval | ||
| EWAServiceWeeklyInterval | EWAService | EWAServiceWeeklyInterval | ||
| EWAServiceMonthlyInterval | EWAService | EWAServiceMonthlyInterval | ||
| EWAServiceWeekOfMonth | EWAService | EWAServiceWeekOfMonth | ||
| EWADailyServiceType | EWAService | EWADailyServiceType | ||
| EWAServiceWeekday | EWAService | EWAServiceWeekday | ||
| _EWAServiceType | EWAService | _EWAServiceType | ||
| _EWAWasteDisposalVehicle | _EWAWasteDisposalVehicle | |||
| _CalendarValidTo | _CalendarValidTo | |||
| _CalendarValidFrom | _CalendarValidFrom | |||
| _CalendarRoute | _CalendarRoute | |||
| _BusinessArea | I_EWA_WasteDisposalRoute | _BusinessArea | ||
| _CompanyCode | I_EWA_WasteDisposalRoute | _CompanyCode | ||
| _ControllingArea | I_EWA_WasteDisposalRoute | _ControllingArea | ||
| _CostCenter | I_EWA_WasteDisposalRoute | _CostCenter | ||
| _EWADeliveringPlant | I_EWA_WasteDisposalRoute | _EWADeliveringPlant | ||
| _EWAFleetCategory | I_EWA_WasteDisposalRoute | _EWAFleetCategory | ||
| _EWAFleetEquipment | I_EWA_WasteDisposalRoute | _EWAFleetEquipment | ||
| _EWAFleetEquipment2 | I_EWA_WasteDisposalRoute | _EWAFleetEquipment2 | ||
| _EWAFleetEquipment3 | I_EWA_WasteDisposalRoute | _EWAFleetEquipment3 | ||
| _EWAMaintenancePlant | I_EWA_WasteDisposalRoute | _EWAMaintenancePlant | ||
| _EWAPlant2 | I_EWA_WasteDisposalRoute | _EWAPlant2 | ||
| _EWAPlant3 | I_EWA_WasteDisposalRoute | _EWAPlant3 | ||
| _EWAPlndWorkCenterInternalID2 | I_EWA_WasteDisposalRoute | _EWAPlndWorkCenterInternalID2 | ||
| _EWAPlndWorkCenterInternalID3 | I_EWA_WasteDisposalRoute | _EWAPlndWorkCenterInternalID3 | ||
| _EWAPoliticalStrucElem | I_EWA_WasteDisposalRoute | _EWAPoliticalStrucElem | ||
| _EWAServiceArea | I_EWA_WasteDisposalRoute | _EWAServiceArea | ||
| _EWAServiceArea2 | I_EWA_WasteDisposalRoute | _EWAServiceArea2 | ||
| _EWAServiceArea3 | I_EWA_WasteDisposalRoute | _EWAServiceArea3 | ||
| _EWAShift | I_EWA_WasteDisposalRoute | _EWAShift | ||
| _FactoryCalendar | I_EWA_WasteDisposalRoute | _FactoryCalendar | ||
| _MaintenanceObjectLocation | I_EWA_WasteDisposalRoute | _MaintenanceObjectLocation | ||
| _MaterialGroup | I_EWA_WasteDisposalRoute | _MaterialGroup | ||
| _PlannedWorkCenterInternalID | I_EWA_WasteDisposalRoute | _PlannedWorkCenterInternalID | ||
| _Plant | I_EWA_WasteDisposalRoute | _Plant | ||
| _PlantSection | I_EWA_WasteDisposalRoute | _PlantSection | ||
| _SettlementOrdForServiceProcmt | I_EWA_WasteDisposalRoute | _SettlementOrdForServiceProcmt | ||
| _StandingOrderNumber | I_EWA_WasteDisposalRoute | _StandingOrderNumber | ||
| _StorageLocation | I_EWA_WasteDisposalRoute | _StorageLocation |
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_WasteDisposalRouteCmpst.
-- 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_Language : sylangu
CREATE VIEW I_EWA_WasteDisposalRouteCmpst AS
SELECT
EWARoute.EWARouteNumber AS EWARouteNumber,
EWAService.EWAServiceNumber AS EWAServiceNumber,
EWAService.EWAServiceNumberItem AS EWAServiceNumberItem,
EWAService.EWAValidToDate AS EWAValidToDate,
EWAService.EWAValidFromDate AS EWAValidFromDate,
EWAService._EWAServiceNumber.MaintenanceObjectList AS MaintenanceObjectList,
EWAService._EWAServiceNumber.MaintenanceObjectListItem AS MaintenanceObjectListItem,
EWARoute.EWARouteDescription AS EWARouteDescription,
EWARoute.EWARouteStartDate AS EWARouteStartDate,
EWARoute.EWARouteObjectNumber AS EWARouteObjectNumber,
EWARoute.EWASrvcHasNonWorkdaysCrrtn AS EWASrvcHasNonWorkdaysCrrtn,
EWARoute.EWAPlannedVolume AS EWAPlannedVolume,
EWARoute.EWAPlannedVolumeUnit AS EWAPlannedVolumeUnit,
EWARoute.EWATargetNumberOfPremises AS EWATargetNumberOfPremises,
EWARoute.EWAWasteDsplOrdCoverSheetForm AS EWAWasteDsplOrdCoverSheetForm,
EWARoute.EWAMaintenancePlant AS EWAMaintenancePlant,
EWARoute.MaintenanceObjectLocation AS MaintenanceObjectLocation,
EWARoute.PlantSection AS PlantSection,
EWARoute.CostCenter AS CostCenter,
EWARoute.CompanyCode AS CompanyCode,
EWARoute.StandingOrderNumber AS StandingOrderNumber,
EWARoute.SettlementOrdForServiceProcmt AS SettlementOrdForServiceProcmt,
EWARoute.EWADeliveringPlant AS EWADeliveringPlant,
EWARoute.EWACostCollectorLevel AS EWACostCollectorLevel,
EWARoute.EWAWasteDsplOrderInitialStatus AS EWAWasteDsplOrderInitialStatus,
EWARoute.MaterialGroup AS MaterialGroup,
EWARoute.EWAWeighingCreationOnOrdLevel AS EWAWeighingCreationOnOrdLevel,
EWARoute.EWAWeighingCreationOnItemLevel AS EWAWeighingCreationOnItemLevel,
EWARoute.EWACreatedOnDate AS EWACreatedOnDate,
EWARoute.EWACreatedByName AS EWACreatedByName,
EWARoute.EWAChangedOnDate AS EWAChangedOnDate,
EWARoute.EWAChangedByName AS EWAChangedByName,
EWARoute.EWAAuthorizationGroup AS EWAAuthorizationGroup,
EWARoute.EWAIsMarkedForDeletion AS EWAIsMarkedForDeletion,
cast(_CalendarValidTo.CalendarYear as valid_to_year) AS EWAServiceValidToYear,
cast(_CalendarValidTo.YearQuarter as creation_date_year_quarter) AS EWAServiceValidToYearQuarter,
cast(_CalendarValidTo.YearMonth as creation_date_year_month) AS EWAServiceValidToYearMonth,
cast(_CalendarValidFrom.CalendarYear as creation_date_year) AS EWAServiceValidFromYear,
cast(_CalendarValidFrom.YearQuarter as creation_date_year_quarter) AS EWAServiceValidFromYearQuarter,
cast(_CalendarValidFrom.YearMonth as creation_date_year_month) AS EWAServiceValidFromYearMonth,
EWAService.EWARouteSequenceValue AS EWARouteSequenceValue,
EWAService.EWARouteServiceSequence AS EWARouteServiceSequence,
EWAService.EWARouteServiceToDate AS EWARouteServiceToDate,
EWARoute.EWAServiceArea AS EWAServiceArea,
EWARoute._EWAServiceArea._EWAServiceAreaText[1: Language=$parameters.P_Language].EWAServiceAreaDescription AS EWAServiceAreaDescription,
EWARoute.EWAConfirmationCategory AS EWAConfirmationCategory,
EWARoute.EWAServiceArea2 AS EWAServiceArea2,
EWARoute._EWAServiceArea2._EWAServiceAreaText[1: Language=$parameters.P_Language].EWAServiceAreaDescription AS EWAServiceArea2Desc,
EWARoute.EWAConfirmationCategory2 AS EWAConfirmationCategory2,
EWARoute.EWAServiceArea3 AS EWAServiceArea3,
EWARoute._EWAServiceArea3._EWAServiceAreaText[1: Language=$parameters.P_Language].EWAServiceAreaDescription AS EWAServiceArea3Desc,
EWARoute.EWAConfirmationCategory3 AS EWAConfirmationCategory3,
EWARoute.EWAPlannedRouteTime AS EWAPlannedRouteTime,
EWARoute.EWADrivingTimeUnit AS EWADrivingTimeUnit,
EWARoute.EWAPlannedDistance AS EWAPlannedDistance,
EWARoute.EWAPlannedDistanceUnit AS EWAPlannedDistanceUnit,
EWARoute.EWAPlannedWeight AS EWAPlannedWeight,
EWARoute.EWAPlannedWeightUnit AS EWAPlannedWeightUnit,
EWARoute.EWARouteTargetPointValue AS EWARouteTargetPointValue,
EWARoute.EWAShift AS EWAShift,
EWARoute._EWAShift.EWAShiftDescription AS EWAShiftDescription,
EWARoute.EWAFleetEquipment AS EWAFleetEquipment,
EWARoute._EWAFleetEquipment._EquipmentText[1: Language=$parameters.P_Language].EquipmentName AS EWAFleetEquipmentDesc,
EWARoute.EWAFleetCategory AS EWAFleetCategory,
EWARoute._EWAFleetEquipment.MaintObjectInternalID AS EWAFleetObjectNumber,
EWARoute._EWAFleetEquipment.GrossWeight AS EWAFleetEquipmentGrossWeight,
EWARoute._EWAFleetEquipment.GrossWeightUnit AS EWAFleetEquipmentWeightUnit,
EWARoute.WorkCenter AS WorkCenter,
EWARoute.PlannedWorkCenterInternalID AS PlannedWorkCenterInternalID,
EWARoute._PlannedWorkCenterInternalID._Text[1: Language=$parameters.P_Language].WorkCenterText AS PlannedWorkCenterDesc,
EWARoute.Plant AS Plant,
EWARoute._Plant.PlantName AS PlantName,
EWARoute.EWAPlant2 AS EWAPlant2,
EWARoute._EWAPlant2.PlantName AS EWAPlant2Name,
EWARoute.EWAPlant3 AS EWAPlant3,
EWARoute._EWAPlant3.PlantName AS EWAPlant3Name,
EWARoute.EWAFleetEquipment2 AS EWAFleetEquipment2,
EWARoute._EWAFleetEquipment2._EquipmentText[1: Language=$parameters.P_Language].EquipmentName AS EWAFleetEquipment2Desc,
EWARoute.EWAWorkCenter2 AS EWAWorkCenter2,
EWARoute.EWAPlndWorkCenterInternalID2 AS EWAPlndWorkCenterInternalID2,
EWARoute._EWAPlndWorkCenterInternalID2._Text[1: Language=$parameters.P_Language].WorkCenterText AS EWAPlndWorkCenterIntID2Desc,
EWARoute.EWAFleetEquipment3 AS EWAFleetEquipment3,
EWARoute._EWAFleetEquipment3._EquipmentText[1: Language=$parameters.P_Language].EquipmentName AS EWAFleetEquipment3Desc,
EWARoute.EWAWorkCenter3 AS EWAWorkCenter3,
EWARoute.EWAPlndWorkCenterInternalID3 AS EWAPlndWorkCenterInternalID3,
EWARoute._EWAPlndWorkCenterInternalID3._Text[1: Language=$parameters.P_Language].WorkCenterText AS EWAPlndWorkCenterIntID3Desc,
EWARoute.EWARouteIsDeactivated AS EWARouteIsDeactivated,
EWARoute.EWARouteDeactivationDate AS EWARouteDeactivationDate,
EWARoute.EWAWasteManagementCalendar AS EWAWasteManagementCalendar,
EWARoute.FactoryCalendar AS FactoryCalendar,
EWARoute.EWAWasteDisposalOrderForm AS EWAWasteDisposalOrderForm,
EWARoute.EWAWasteDisposalOrderItemForm AS EWAWasteDisposalOrderItemForm,
EWAService._EWAServiceNumber.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
EWAService._EWAServiceNumber._EWAWasteDisposalFacility.EWAWasteDisposalFacilityDesc AS EWAWasteDisposalFacilityDesc,
EWARoute.EWAPoliticalStrucElem AS EWAPoliticalStrucElem,
EWARoute.BusinessArea AS BusinessArea,
EWARoute._BusinessArea._Text[1: Language=$parameters.P_Language].BusinessAreaName AS BusinessAreaName,
EWARoute.ControllingArea AS ControllingArea,
EWARoute._ControllingArea.ControllingAreaName AS ControllingAreaName,
EWARoute.StorageLocation AS StorageLocation,
EWARoute._StorageLocation.StorageLocationName AS StorageLocationName,
EWARoute.EWAPlannedNumberOfContainers AS EWAPlannedNumberOfContainers,
EWAService.EWANumberOfContainers AS EWANumberOfContainers,
EWAService._EWAServiceNumber.EWAContainer AS EWAContainer,
EWAService._EWAServiceNumber.EWAContainerCategory AS EWAContainerCategory,
EWAService._EWAServiceNumber.EWAContainerGroup AS EWAContainerGroup,
EWAService._EWAServiceNumber.EWAContainerLocation AS EWAContainerLocation,
EWAService._EWAServiceNumber.AddressID AS AddressID,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].OrganizationName1 AS OrganizationName1,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].StreetName AS StreetName,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].VillageName AS VillageName,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].CityName AS CityName,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].DistrictName AS DistrictName,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].Region AS Region,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language]._Region._RegionText[1: Language=$parameters.P_Language].RegionName AS RegionName,
EWAService._EWAServiceNumber._Address[1:CorrespondenceLanguage=$parameters.P_Language].Country AS Country,
EWAService.EWAServiceType AS EWAServiceType,
EWAService._EWAServiceType._EWAServiceTypeText.EWAServiceTypeDescription AS EWAServiceTypeDescription,
EWAService._EWAServiceType.EWAServiceCategory AS EWAServiceCategory,
EWAService.EWAServiceGroup AS EWAServiceGroup,
EWAService.EWAServiceHasDailyInterval AS EWAServiceHasDailyInterval,
EWAService.EWAServiceHasWeeklyInterval AS EWAServiceHasWeeklyInterval,
EWAService.EWAServiceHasMonthlyInterval AS EWAServiceHasMonthlyInterval,
EWAService.EWAServiceDailyInterval AS EWAServiceDailyInterval,
EWAService.EWAServiceWeeklyInterval AS EWAServiceWeeklyInterval,
EWAService.EWAServiceMonthlyInterval AS EWAServiceMonthlyInterval,
EWAService.EWAServiceWeekOfMonth AS EWAServiceWeekOfMonth,
EWAService.EWADailyServiceType AS EWADailyServiceType,
EWAService.EWAServiceWeekday AS EWAServiceWeekday,
EWAService._EWAServiceType AS _EWAServiceType,
EWARoute._BusinessArea AS _BusinessArea,
EWARoute._CompanyCode AS _CompanyCode,
EWARoute._ControllingArea AS _ControllingArea,
EWARoute._CostCenter AS _CostCenter,
EWARoute._EWADeliveringPlant AS _EWADeliveringPlant,
EWARoute._EWAFleetCategory AS _EWAFleetCategory,
EWARoute._EWAFleetEquipment AS _EWAFleetEquipment,
EWARoute._EWAFleetEquipment2 AS _EWAFleetEquipment2,
EWARoute._EWAFleetEquipment3 AS _EWAFleetEquipment3,
EWARoute._EWAMaintenancePlant AS _EWAMaintenancePlant,
EWARoute._EWAPlant2 AS _EWAPlant2,
EWARoute._EWAPlant3 AS _EWAPlant3,
EWARoute._EWAPlndWorkCenterInternalID2 AS _EWAPlndWorkCenterInternalID2,
EWARoute._EWAPlndWorkCenterInternalID3 AS _EWAPlndWorkCenterInternalID3,
EWARoute._EWAPoliticalStrucElem AS _EWAPoliticalStrucElem,
EWARoute._EWAServiceArea AS _EWAServiceArea,
EWARoute._EWAServiceArea2 AS _EWAServiceArea2,
EWARoute._EWAServiceArea3 AS _EWAServiceArea3,
EWARoute._EWAShift AS _EWAShift,
EWARoute._FactoryCalendar AS _FactoryCalendar,
EWARoute._MaintenanceObjectLocation AS _MaintenanceObjectLocation,
EWARoute._MaterialGroup AS _MaterialGroup,
EWARoute._PlannedWorkCenterInternalID AS _PlannedWorkCenterInternalID,
EWARoute._Plant AS _Plant,
EWARoute._PlantSection AS _PlantSection,
EWARoute._SettlementOrdForServiceProcmt AS _SettlementOrdForServiceProcmt,
EWARoute._StandingOrderNumber AS _StandingOrderNumber,
EWARoute._StorageLocation AS _StorageLocation
FROM I_EWA_WasteDisposalRoute AS EWARoute
LEFT OUTER JOIN I_EWA_WasteDisposalVehicle AS _EWAWasteDisposalVehicle ON EWAFleetObjectNumber = _EWAWasteDisposalVehicle.EWAFleetObjectNumber -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarValidTo ON EWAValidToDate = _CalendarValidTo.CalendarDate -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarValidFrom ON EWAValidFromDate = _CalendarValidFrom.CalendarDate -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarRoute ON EWARouteStartDate = _CalendarRoute.CalendarDate -- 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