I_EWA_ServiceFrequencyNote

DDL: I_EWA_SERVICEFREQUENCYNOTE Type: view_entity BASIC
7 Fields 1 Data Sources 1 Associations

Note of Service Frequency

I_EWA_ServiceFrequencyNote is a Basic CDS View that provides data about "Note of Service Frequency" in SAP S/4HANA. It reads from 1 data source (ewaobjh_diffcult) and exposes 7 fields with key fields EWAServiceNumber, EWAServiceNumberItem, EWAValidToDate, EWAWasteManagementNote. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ewaobjh_diffcult ewaobjh_diffcult from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EWA_WasteManagementNote _EWAWasteManagementNote $projection.EWAWasteManagementNote = _EWAWasteManagementNote.EWAWasteManagementNote

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Note of Service Frequency view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EWAServiceNumber objnr Val. Obj. No.
KEY EWAServiceNumberItem laufnr Service number
KEY EWAValidToDate bis Value
KEY EWAWasteManagementNote diffcult Note
EWAWasteManagementNoteDesc diffctxt Text
EWAServiceItemUUID tsl_guid Link GUID
_EWAWasteManagementNote _EWAWasteManagementNote

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_ServiceFrequencyNote.
-- 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 I_EWA_ServiceFrequencyNote AS
SELECT
  objnr AS EWAServiceNumber,
  laufnr AS EWAServiceNumberItem,
  bis AS EWAValidToDate,
  diffcult AS EWAWasteManagementNote,
  diffctxt AS EWAWasteManagementNoteDesc,
  tsl_guid AS EWAServiceItemUUID
FROM ewaobjh_diffcult
LEFT OUTER JOIN I_EWA_WasteManagementNote AS _EWAWasteManagementNote ON EWAWasteManagementNote = _EWAWasteManagementNote.EWAWasteManagementNote  -- association [0..1]
;

Learn More