I_UtilsPeriodicRplcmtList

DDL: I_UTILSPERIODICRPLCMTLIST SQL: IEPERDCRPLCMTL Type: view BASIC

Periodic Replacement List

I_UtilsPeriodicRplcmtList (Basic)

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

Utilities Device Periodic Replacement List · Utilities

I_UtilsPeriodicRplcmtList is a Basic CDS View (Dimension) that provides data about "Periodic Replacement List" in SAP S/4HANA. It reads from 1 data source (egtur) and exposes 10 fields with key field UtilsEquipmentPerdcRplcmtList. It has 1 association to related views.

SAP Help Documentation

CategoryDevice Management
Data CategoryDimension
StatusC1
Purpose
This CDS view retrieves data for the IS-U periodic replacement list. 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
Not applicable.

Structure
Important fields in this view include the following: Field Name Description UtilsEquipmentPerdcRplcmtList Equipment Periodic Replacement List UtilsPerdcRplcmtYear Device Periodic Replacement Year UtilsDeviceRemovalDate Device Removal Date MaintenanceOrder Maintenance Order Number MaintenanceNotification Maintenance Notification Number MeterReadingUnit Meter Reading Unit

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-DM-IS-PR
CapabilitiesData Source in SQL Select, Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageUtilities for SAP S/4HANA
Description <p>This CDS view retrieves data for the IS-U periodic replacement list.</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
egtur egtur from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UtilsPerdcRplcmtListAndHdr _UtilsPerdcRplcmtListAndHdr $projection.UtilsPerdcRplcmtYear = _UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtYear

Annotations (17)

NameValueLevelField
EndUserText.label Periodic Replacement List view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IEPERDCRPLCMTL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey UtilsEquipmentPerdcRplcmtList view
ObjectModel.sapObjectNodeType.name UtilsPeriodicReplacementList view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY UtilsEquipmentPerdcRplcmtList equnr Equipment Number
UtilsPerdcRplcmtYear turnusj Periodic replacement year
UtilsDeviceRemovalDate ausbdat Device removal date
MaintenanceOrder auftrag Order Number
MaintenanceNotification meldung Notification Number
MeterReadingUnit ableinheit Meter Reading Unit
Material matnr Material Number
UtilitiesDivision sparte Insurance LOB
RegionalStructureGrouping regiogroup Regional structure grouping
_UtilsPerdcRplcmtListAndHdr _UtilsPerdcRplcmtListAndHdr

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_UtilsPeriodicRplcmtList.
-- 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.
-- SQL view name: IEPERDCRPLCMTL

CREATE VIEW I_UtilsPeriodicRplcmtList AS
SELECT
  equnr AS UtilsEquipmentPerdcRplcmtList,
  turnusj AS UtilsPerdcRplcmtYear,
  ausbdat AS UtilsDeviceRemovalDate,
  auftrag AS MaintenanceOrder,
  meldung AS MaintenanceNotification,
  ableinheit AS MeterReadingUnit,
  matnr AS Material,
  sparte AS UtilitiesDivision,
  regiogroup AS RegionalStructureGrouping
FROM egtur
LEFT OUTER JOIN I_UtilsPerdcRplcmtListAndHdr AS _UtilsPerdcRplcmtListAndHdr ON UtilsPerdcRplcmtYear = _UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtYear  -- association [1..1]
;