What is C_EWA_SrvcFreqSDSubitemDEX in SAP S/4HANA?

C_EWA_SrvcFreqSDSubitemDEX is a consumption CDS view in SAP S/4HANA. Data Extraction of ServFreq SalesSubitem It contains 5 fields.

Which tables does C_EWA_SrvcFreqSDSubitemDEX read from?

C_EWA_SrvcFreqSDSubitemDEX reads data from: I_EWA_ServiceFrqcySalesSubitem.

What VDM layer is C_EWA_SrvcFreqSDSubitemDEX?

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

C_EWA_SrvcFreqSDSubitemDEX

DDL: C_EWA_SRVCFREQSDSUBITEMDEX Type: view_entity CONSUMPTION

5 Fields 1 Data Sources

Data Extraction of ServFreq SalesSubitem

C_EWA_SrvcFreqSDSubitemDEX (Consumption)

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

EWA_ServiceFreqSDSubitem · Utilities

C_EWA_SrvcFreqSDSubitemDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction of ServFreq SalesSubitem" in SAP S/4HANA. It reads from 1 data source (I_EWA_ServiceFrqcySalesSubitem) and exposes 5 fields with key fields EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate, Material.

SAP Help Documentation

Category	CDS Views for Container Allocation
Data Category	Fact

Purpose
This CDS view extracts data related to subitem of Sales Document for Service Type 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 )

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 Material Material Attribute Material Number

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 data related to subitem of Sales Document for Service Type to SAP Business Warehouse (SAP BW) or other external systems.  </p> <p>  </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_ServiceFrqcySalesSubitem	I_EWA_ServiceFrqcySalesSubitem	from

Annotations (11)

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

Fields (5)

Key	Field	Source Field	Description
KEY	EWAServiceNumber	EWAServiceNumber	Number of service frequency
KEY	EWAServiceNumberItem	EWAServiceNumberItem	Sequence Number of Service Frequency
KEY	EWAValidToDate	EWAValidToDate	Date at Which a Time Slice Expires
KEY	Material	Material	Material Number
	EWAServiceItemUUID	EWAServiceItemUUID	Link GUID

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_SrvcFreqSDSubitemDEX.
-- 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_SrvcFreqSDSubitemDEX AS
SELECT
  EWAServiceNumber,
  EWAServiceNumberItem,
  EWAValidToDate,
  Material,
  EWAServiceItemUUID
FROM I_EWA_ServiceFrqcySalesSubitem
;

Depth:

C_EWA_SrvcFreqSDSubitemDEX view_entity

I_EWA_ServiceFrqcySalesSubitem view_entity