C_EWA_ServiceFreqDatesDEX

DDL: C_EWA_SERVICEFREQDATESDEX Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

Data Extraction of Changed date ServFreq

C_EWA_ServiceFreqDatesDEX (Consumption)

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

EWA_ServiceFrequencyDates · Utilities

C_EWA_ServiceFreqDatesDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction of Changed date ServFreq" in SAP S/4HANA. It reads from 1 data source (I_EWA_ServiceFrqcyExmpDates) and exposes 10 fields with key fields EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate, EWAValidFromDate, EWAPlannedDate.

SAP Help Documentation

CategoryCDS Views for Container Allocation
Data CategoryFact
Purpose
This CDS view extracts the changed date for 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 )

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 s EWAValidToDate Valid to Attribute Date at Which a Time Slice Expires EWAValidFromDate Valid from Attribute Date from which time slice is valid EWAPlannedDate Planned Date Attribute Planned Service Date

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

StateC1
Line of BusinessUtilities
Application ComponentIS-U-WA
CapabilitiesData Source for Data Extraction
PackageUtilities for SAP S/4HANA
Description <p>This CDS view extracts the changed date for service frequency-related data to SAP Business Warehouse (SAP BW) or other external systems.&nbsp;</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

Data Sources (1)

SourceAliasJoin Type
I_EWA_ServiceFrqcyExmpDates I_EWA_ServiceFrqcyExmpDates from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Data Extraction of Changed date ServFreq view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name EWA_ServiceFrequencyDates view
ObjectModel.modelingPattern #NONE view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (10)

KeyFieldSource TableSource FieldDescription
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 EWAValidFromDate EWAValidFromDate Date from which time slice is valid
KEY EWAPlannedDate EWAPlannedDate Planned Service Date
EWANewServiceDate EWANewServiceDate New service date
EWAServiceDateCorrectionMode EWAServiceDateCorrectionMode Correction of the service date
SalesContract SalesContract Sales and Distribution Document Number
SalesContractItem SalesContractItem Item number of the SD document
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_ServiceFreqDatesDEX.
-- 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_ServiceFreqDatesDEX AS
SELECT
  EWAServiceNumber,
  EWAServiceNumberItem,
  EWAValidToDate,
  EWAValidFromDate,
  EWAPlannedDate,
  EWANewServiceDate,
  EWAServiceDateCorrectionMode,
  SalesContract,
  SalesContractItem,
  EWAServiceItemUUID
FROM I_EWA_ServiceFrqcyExmpDates
;

Learn More