What is C_EWA_ServiceFrequencyDEX in SAP S/4HANA?

C_EWA_ServiceFrequencyDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Service Frequency It contains 75 fields.

Which tables does C_EWA_ServiceFrequencyDEX read from?

C_EWA_ServiceFrequencyDEX reads data from: I_EWA_ServiceFrqcyTimeSlice.

What VDM layer is C_EWA_ServiceFrequencyDEX?

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

C_EWA_ServiceFrequencyDEX

DDL: C_EWA_SERVICEFREQUENCYDEX Type: view_entity CONSUMPTION

75 Fields 1 Data Sources 2 Associations

Data Extraction for Service Frequency

C_EWA_ServiceFrequencyDEX (Consumption)

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

EWA_ServiceFrequencyItem · Utilities

C_EWA_ServiceFrequencyDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Service Frequency" in SAP S/4HANA. It reads from 1 data source (I_EWA_ServiceFrqcyTimeSlice) and exposes 75 fields with key fields EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Container Allocation
Data Category	Fact

Purpose
This CDS view retrieves service frequency-related data to SAP Business 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_SERVFREQ (Authorization Object for Service Frequency ) Configuration

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWAServiceNumber Object Number Attribute Number of service frequency EWAServiceNumberItem Service number Attribute Sequence Number of Service Frequency EWAValidToDate Valid To Attribute Date at Which a Time Slice Expires EWAWaste Waste Attribute Waste EWAServiceArea Service Area Atrribute Service Area

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 retrieves service frequency-related data to SAP Business 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_ServiceFrqcyTimeSlice	EWA_SF	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	E_EWA_ServiceFrequency	_ExtensionSF	`$projection.EWAServiceNumber = _ExtensionSF.EWAServiceNumber`
[0..1]	E_EWA_ServiceFrequencyItem	_ExtensionSFItem	`$projection.EWAServiceNumber = _ExtensionSFItem.EWAServiceNumber and $projection.EWAServiceNumberItem = _ExtensionSFItem.EWAServiceNumberItem and $projection.EWAValidToDate = _ExtensionSFItem.EWAValidToDate`

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Data Extraction for Service Frequency	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.sapObjectNodeType.name	EWA_ServiceFrequencyItem	view
ObjectModel.modelingPattern	#NONE	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view

Fields (75)

Key	Field	Source Table	Source Field	Description
KEY	EWAServiceNumber	I_EWA_ServiceFrqcyTimeSlice	EWAServiceNumber	Number of service frequency
KEY	EWAServiceNumberItem	I_EWA_ServiceFrqcyTimeSlice	EWAServiceNumberItem	Sequence Number of Service Frequency
KEY	EWAValidToDate	I_EWA_ServiceFrqcyTimeSlice	EWAValidToDate	Date at Which a Time Slice Expires
	MaintenanceObjectList	EWA_SFHead	MaintenanceObjectList	Object list number
	MaintenanceObjectListItem	EWA_SFHead	MaintenanceObjectListItem	Object list counters
	UtilitiesInstallation	EWA_SFHead	UtilitiesInstallation	Installation
	UtilsBillingOperand	EWA_SFHead	UtilsBillingOperand	Operand
	EWABillingOperandSequence	EWA_SFHead	EWABillingOperandSequence	Consecutive number of an operand
	EWAContainerLocation	EWA_SFHead	EWAContainerLocation	Functional Location
	Material	EWA_SFHead	Material	Material Number
	EWAContainer	EWA_SFHead	EWAContainer	Equipment Number
	AddressID	EWA_SFHead	AddressID	Ship-to address
	EWACtnCategoryIsReplaceable	EWA_SFHead	EWACtnCategoryIsReplaceable	Container category can be replaced
	EWAServiceArea	EWA_SFHead	EWAServiceArea	Service Area
	EWAWaste	EWA_SFHead	EWAWaste	Waste
	EWAContainerCategory	EWA_SFHead	EWAContainerCategory	Container category
	EWARouteNumber	EWA_SFHead	EWARouteNumber	Planned Waste Disposal Order Route
	UtilitiesLogicalDeviceNumber	EWA_SFHead	UtilitiesLogicalDeviceNumber	Logical device number
	EWAContainerGroup	EWA_SFHead	EWAContainerGroup	Container Group
	EWABillingFactor	EWA_SFHead	EWABillingFactor	Waste Billing Factor
	EWACleaningObject	EWA_SFHead	EWACleaningObject	Cleaning Object
	EWAWinterMaintenanceLevel	EWA_SFHead	EWAWinterMaintenanceLevel	Winter Maintenance Level
	EWAPoliticalStrucElem	EWA_SFHead	EWAPoliticalStrucElem	Political regional structure element
	Country	EWA_SFHead	Country	Country/Region Key
	EWAWasteDisposalFacility	EWA_SFHead	EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	Plant	EWA_SFHead	Plant	Valuation Area
	EWATargetStorageLocation	EWA_SFHead	EWATargetStorageLocation	Destination: Storage location in plant
	EWAInstalledBase	EWA_SFHead	EWAInstalledBase	IBase: Number of the Installed Base/IBase
	StorageLocation	EWA_SFHead	StorageLocation	Storage Location
	EWACreatedOnDate	EWA_SFHead	EWACreatedOnDate	Record Created On
	EWACreatedByName	EWA_SFHead	EWACreatedByName	Name of Person Responsible for Creating the Object
	EWAChangedOnDate	EWA_SFHead	EWAChangedOnDate	Last Changed On
	EWAChangedByName	EWA_SFHead	EWAChangedByName	Name of Person Who Changed Object
	EWAAuthorizationGroup	EWA_SFHead	EWAAuthorizationGroup	Authorization Group
	EWAIsMarkedForDeletion	EWA_SFHead	EWAIsMarkedForDeletion	Deletion Indicator
	EWAValidFromDate	I_EWA_ServiceFrqcyTimeSlice	EWAValidFromDate	Date from which time slice is valid
	EWAServiceWindow	I_EWA_ServiceFrqcyTimeSlice	EWAServiceWindow	Service window
	EWAServiceDateIsChangeable	I_EWA_ServiceFrqcyTimeSlice	EWAServiceDateIsChangeable	Service frequency can be changed
	EWAServiceActivationStatus	I_EWA_ServiceFrqcyTimeSlice	EWAServiceActivationStatus	Service Status
	EWAServiceCustomerStatus	I_EWA_ServiceFrqcyTimeSlice	EWAServiceCustomerStatus	Customer Status
	EWAStartTime	I_EWA_ServiceFrqcyTimeSlice	EWAStartTime	Start time of a service window
	EWAEndTime	I_EWA_ServiceFrqcyTimeSlice	EWAEndTime	End of service window
	EWANumberOfContainers	I_EWA_ServiceFrqcyTimeSlice	EWANumberOfContainers	Number of available containers
	EWARouteSequenceValue	I_EWA_ServiceFrqcyTimeSlice	EWARouteSequenceValue	Number of stop in route
	EWASeasonStartValue	I_EWA_ServiceFrqcyTimeSlice	EWASeasonStartValue	Start of Season for Waste Disposal Service.
	EWASeasonEndValue	I_EWA_ServiceFrqcyTimeSlice	EWASeasonEndValue	End of Season for Waste Disposal Service.
	FactoryCalendar	I_EWA_ServiceFrqcyTimeSlice	FactoryCalendar	Factory Calendar
	EWARouteServicesAreChangeable	I_EWA_ServiceFrqcyTimeSlice	EWARouteServicesAreChangeable	Indicator: override route using service frequency
	EWAServiceType	I_EWA_ServiceFrqcyTimeSlice	EWAServiceType	Type of Ext. Service
	EWAServiceIntervalGrouping	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIntervalGrouping	Service Interval Grouping
	EWAWasteDisposalOrderCreation	I_EWA_ServiceFrqcyTimeSlice	EWAWasteDisposalOrderCreation	Order Relevance
	EWARouteServiceSequence	I_EWA_ServiceFrqcyTimeSlice	EWARouteServiceSequence	Consecutive Number of Service for Route
	EWARouteServiceToDate	I_EWA_ServiceFrqcyTimeSlice	EWARouteServiceToDate	To Date of Service for Route
	EWACapacityCategory	I_EWA_ServiceFrqcyTimeSlice	EWACapacityCategory	Capacity Category
	EWAServiceGroup	I_EWA_ServiceFrqcyTimeSlice	EWAServiceGroup	Service Grouping
	EWAPlannedTime	I_EWA_ServiceFrqcyTimeSlice	EWAPlannedTime	Time Planned
	EWAPlannedServiceFreqTime	I_EWA_ServiceFrqcyTimeSlice	EWAPlannedServiceFreqTime	Service Duration
	EWAServiceItemUUID	I_EWA_ServiceFrqcyTimeSlice	EWAServiceItemUUID	Link GUID
	EWAServiceWeeklyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceWeeklyInterval	Weekly Service Interval
	EWAServiceWeekOfMonth	I_EWA_ServiceFrqcyTimeSlice	EWAServiceWeekOfMonth	Day in Month for Service
	EWAServiceMonthlyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceMonthlyInterval	Frequency of Service in Months
	EWADailyServiceType	I_EWA_ServiceFrqcyTimeSlice	EWADailyServiceType	Type of Daily Service (Single/Periodic)
	EWAServiceHasDailyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceHasDailyInterval	Service for service frequency occurs daily
	EWAServiceHasWeeklyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceHasWeeklyInterval	Service for service frequency occurs weekly
	EWAServiceHasMonthlyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceHasMonthlyInterval	Service for service frequency occurs monthly
	EWAServiceIsExecutedMonday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedMonday	Text field length 1
	EWAServiceIsExecutedTuesday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedTuesday	Tr. Evaluation
	EWAServiceIsExecutedWednesday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedWednesday	Text field length 1
	EWAServiceIsExecutedThursday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedThursday	Usage in the OWN Authorization Context
	EWAServiceIsExecutedFriday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedFriday	Usage in Privileged BDEF Mode
	EWAServiceIsExecutedSaturday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedSaturday	Indicators
	EWAServiceIsExecutedSunday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceIsExecutedSunday	Indicators
	EWAServiceFromDate	I_EWA_ServiceFrqcyTimeSlice	EWAServiceFromDate	Date on Which Waste Disposal Service Begins
	EWAServiceWeekday	I_EWA_ServiceFrqcyTimeSlice	EWAServiceWeekday	Weekday of Service
	EWAServiceDailyInterval	I_EWA_ServiceFrqcyTimeSlice	EWAServiceDailyInterval	Reminder Frequency

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_ServiceFrequencyDEX.
-- 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_ServiceFrequencyDEX AS
SELECT
  EWA_SF.EWAServiceNumber AS EWAServiceNumber,
  EWA_SF.EWAServiceNumberItem AS EWAServiceNumberItem,
  EWA_SF.EWAValidToDate AS EWAValidToDate,
  EWA_SFHead.MaintenanceObjectList AS MaintenanceObjectList,
  EWA_SFHead.MaintenanceObjectListItem AS MaintenanceObjectListItem,
  EWA_SFHead.UtilitiesInstallation AS UtilitiesInstallation,
  EWA_SFHead.UtilsBillingOperand AS UtilsBillingOperand,
  EWA_SFHead.EWABillingOperandSequence AS EWABillingOperandSequence,
  EWA_SFHead.EWAContainerLocation AS EWAContainerLocation,
  EWA_SFHead.Material AS Material,
  EWA_SFHead.EWAContainer AS EWAContainer,
  EWA_SFHead.AddressID AS AddressID,
  EWA_SFHead.EWACtnCategoryIsReplaceable AS EWACtnCategoryIsReplaceable,
  EWA_SFHead.EWAServiceArea AS EWAServiceArea,
  EWA_SFHead.EWAWaste AS EWAWaste,
  EWA_SFHead.EWAContainerCategory AS EWAContainerCategory,
  EWA_SFHead.EWARouteNumber AS EWARouteNumber,
  EWA_SFHead.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  EWA_SFHead.EWAContainerGroup AS EWAContainerGroup,
  EWA_SFHead.EWABillingFactor AS EWABillingFactor,
  EWA_SFHead.EWACleaningObject AS EWACleaningObject,
  EWA_SFHead.EWAWinterMaintenanceLevel AS EWAWinterMaintenanceLevel,
  EWA_SFHead.EWAPoliticalStrucElem AS EWAPoliticalStrucElem,
  EWA_SFHead.Country AS Country,
  EWA_SFHead.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  EWA_SFHead.Plant AS Plant,
  EWA_SFHead.EWATargetStorageLocation AS EWATargetStorageLocation,
  EWA_SFHead.EWAInstalledBase AS EWAInstalledBase,
  EWA_SFHead.StorageLocation AS StorageLocation,
  EWA_SFHead.EWACreatedOnDate AS EWACreatedOnDate,
  EWA_SFHead.EWACreatedByName AS EWACreatedByName,
  EWA_SFHead.EWAChangedOnDate AS EWAChangedOnDate,
  EWA_SFHead.EWAChangedByName AS EWAChangedByName,
  EWA_SFHead.EWAAuthorizationGroup AS EWAAuthorizationGroup,
  EWA_SFHead.EWAIsMarkedForDeletion AS EWAIsMarkedForDeletion,
  EWA_SF.EWAValidFromDate AS EWAValidFromDate,
  EWA_SF.EWAServiceWindow AS EWAServiceWindow,
  EWA_SF.EWAServiceDateIsChangeable AS EWAServiceDateIsChangeable,
  EWA_SF.EWAServiceActivationStatus AS EWAServiceActivationStatus,
  EWA_SF.EWAServiceCustomerStatus AS EWAServiceCustomerStatus,
  EWA_SF.EWAStartTime AS EWAStartTime,
  EWA_SF.EWAEndTime AS EWAEndTime,
  EWA_SF.EWANumberOfContainers AS EWANumberOfContainers,
  EWA_SF.EWARouteSequenceValue AS EWARouteSequenceValue,
  EWA_SF.EWASeasonStartValue AS EWASeasonStartValue,
  EWA_SF.EWASeasonEndValue AS EWASeasonEndValue,
  EWA_SF.FactoryCalendar AS FactoryCalendar,
  EWA_SF.EWARouteServicesAreChangeable AS EWARouteServicesAreChangeable,
  EWA_SF.EWAServiceType AS EWAServiceType,
  EWA_SF.EWAServiceIntervalGrouping AS EWAServiceIntervalGrouping,
  EWA_SF.EWAWasteDisposalOrderCreation AS EWAWasteDisposalOrderCreation,
  EWA_SF.EWARouteServiceSequence AS EWARouteServiceSequence,
  EWA_SF.EWARouteServiceToDate AS EWARouteServiceToDate,
  EWA_SF.EWACapacityCategory AS EWACapacityCategory,
  EWA_SF.EWAServiceGroup AS EWAServiceGroup,
  EWA_SF.EWAPlannedTime AS EWAPlannedTime,
  EWA_SF.EWAPlannedServiceFreqTime AS EWAPlannedServiceFreqTime,
  EWA_SF.EWAServiceItemUUID AS EWAServiceItemUUID,
  EWA_SF.EWAServiceWeeklyInterval AS EWAServiceWeeklyInterval,
  EWA_SF.EWAServiceWeekOfMonth AS EWAServiceWeekOfMonth,
  EWA_SF.EWAServiceMonthlyInterval AS EWAServiceMonthlyInterval,
  EWA_SF.EWADailyServiceType AS EWADailyServiceType,
  EWA_SF.EWAServiceHasDailyInterval AS EWAServiceHasDailyInterval,
  EWA_SF.EWAServiceHasWeeklyInterval AS EWAServiceHasWeeklyInterval,
  EWA_SF.EWAServiceHasMonthlyInterval AS EWAServiceHasMonthlyInterval,
  EWA_SF.EWAServiceIsExecutedMonday AS EWAServiceIsExecutedMonday,
  EWA_SF.EWAServiceIsExecutedTuesday AS EWAServiceIsExecutedTuesday,
  EWA_SF.EWAServiceIsExecutedWednesday AS EWAServiceIsExecutedWednesday,
  EWA_SF.EWAServiceIsExecutedThursday AS EWAServiceIsExecutedThursday,
  EWA_SF.EWAServiceIsExecutedFriday AS EWAServiceIsExecutedFriday,
  EWA_SF.EWAServiceIsExecutedSaturday AS EWAServiceIsExecutedSaturday,
  EWA_SF.EWAServiceIsExecutedSunday AS EWAServiceIsExecutedSunday,
  EWA_SF.EWAServiceFromDate AS EWAServiceFromDate,
  EWA_SF.EWAServiceWeekday AS EWAServiceWeekday,
  EWA_SF.EWAServiceDailyInterval AS EWAServiceDailyInterval
FROM I_EWA_ServiceFrqcyTimeSlice AS EWA_SF
LEFT OUTER JOIN E_EWA_ServiceFrequency AS _ExtensionSF ON EWAServiceNumber = _ExtensionSF.EWAServiceNumber  -- association [0..1]
LEFT OUTER JOIN E_EWA_ServiceFrequencyItem AS _ExtensionSFItem ON EWAServiceNumber = _ExtensionSFItem.EWAServiceNumber AND EWAServiceNumberItem = _ExtensionSFItem.EWAServiceNumberItem AND EWAValidToDate = _ExtensionSFItem.EWAValidToDate  -- association [0..1]
;

Depth:

C_EWA_ServiceFrequencyDEX view_entity

I_EWA_ServiceFrqcyTimeSlice view_entity