What is C_UtilsDvcePerdcRplcmntListQ in SAP S/4HANA?

C_UtilsDvcePerdcRplcmntListQ is a consumption CDS view in SAP S/4HANA. Device Periodic Replacement List Query It contains 70 fields.

Which tables does C_UtilsDvcePerdcRplcmntListQ read from?

C_UtilsDvcePerdcRplcmntListQ reads data from: I_UtilsDvcePerdcRplcmntList.

What VDM layer is C_UtilsDvcePerdcRplcmntListQ?

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

C_UtilsDvcePerdcRplcmntListQ

DDL: C_UTILSDVCEPERDCRPLCMNTLISTQ SQL: CEDVCEPERDCRLQ Type: view CONSUMPTION

70 Fields 1 Data Sources

Device Periodic Replacement List Query

C_UtilsDvcePerdcRplcmntListQ (Consumption)

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

Utilities

C_UtilsDvcePerdcRplcmntListQ is a Consumption CDS View that provides data about "Device Periodic Replacement List Query" in SAP S/4HANA. It reads from 1 data source (I_UtilsDvcePerdcRplcmntList) and exposes 70 fields.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM-IS-PR
Capabilities	Analytical Query
Package	Utilities for SAP S/4HANA

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_UtilsDvcePerdcRplcmntList	I_UtilsDvcePerdcRplcmntList	from

Parameters (2)

Name	Type	Default
P_Language	sylangu
P_KeyDate	e_keydate_vdm

Annotations (12)

Name	Value	Level
EndUserText.label	Device Periodic Replacement List Query	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CEDVCEPERDCRLQ	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view

Fields (70)

Field	Source Table	Source Field	Description
UtilsPerdcRplcmtYear	I_UtilsDvcePerdcRplcmntList	UtilsPerdcRplcmtYear	Periodic replacement year
UtilitiesDeviceCategory	I_UtilsDvcePerdcRplcmntList	UtilitiesDeviceCategory	Device Category
UtilsDeviceFunctionClass	I_UtilsDvcePerdcRplcmntList	UtilsDeviceFunctionClass	Function class
UtilsDeviceFunctionClassName			Text for function class
UtilsDeviceConstructionClass	I_UtilsDvcePerdcRplcmntList	UtilsDeviceConstructionClass	Construction class
UtilsDvceConstructionClassName			Text (30 Characters)
Division	I_UtilsDvcePerdcRplcmntList	Division	Internal Division ID
DivisionName			Division Description
MaintenancePlant	I_UtilsDvcePerdcRplcmntList	MaintenancePlant	Maintenance Plant
UtilsDeviceCategoryDescription	I_UtilsDvcePerdcRplcmntList	UtilsDeviceCategoryDescription	Device Category Name
UtilsDeviceCertfnRqmtType	I_UtilsDvcePerdcRplcmntList	UtilsDeviceCertfnRqmtType	Type of certification requirement
UtilsDeviceCertfnRqmtTypeName			Short Text for Fixed Values
UtilsDvceCalibrnValdtylnYears	I_UtilsDvcePerdcRplcmntList	UtilsDvceCalibrnValdtylnYears	Calibration validity (yrs) for ext. devs subject to certif.
UtilsDvceCalcNextRplcmtInYears	I_UtilsDvcePerdcRplcmntList	UtilsDvceCalcNextRplcmtInYears	Old cal. validity/int. cert. period (yrs) until prod. year
UtilsDvceIntCertfnPerdInYears	I_UtilsDvcePerdcRplcmntList	UtilsDvceIntCertfnPerdInYears	Internal certification period (years)
UtilsDeviceOldCertfnInYears	I_UtilsDvcePerdcRplcmntList	UtilsDeviceOldCertfnInYears	Prod. yr until which old calib. valid./int.insp.per.is valid
UtilsDeviceMeasurementType	I_UtilsDvcePerdcRplcmntList	UtilsDeviceMeasurementType	Type of measurement
UtilsDeviceMeasurementTypeName			Short Text for Fixed Values
AssetManufacturerName	I_UtilsDvcePerdcRplcmntList	AssetManufacturerName	Manufacturer of Asset
ManufacturerCountry	I_UtilsDvcePerdcRplcmntList	ManufacturerCountry	Country/Region of Manufacture
ManufacturerPartTypeName	I_UtilsDvcePerdcRplcmntList	ManufacturerPartTypeName	Manufacturer model number
ConstructionYear	I_UtilsDvcePerdcRplcmntList	ConstructionYear	Device Construction Year
SerialNumber	I_UtilsDvcePerdcRplcmntList	SerialNumber	Serial Number
UtilsDeviceBscCatCombination	I_UtilsDvcePerdcRplcmntList	UtilsDeviceBscCatCombination	Combination of a device category
UtilsDeviceInstallationDate	I_UtilsDvcePerdcRplcmntList	UtilsDeviceInstallationDate	Installation date
UtilsDeviceLocation	I_UtilsDvcePerdcRplcmntList	UtilsDeviceLocation	Device Location
UtilsDeviceGroup	I_UtilsDvcePerdcRplcmntList	UtilsDeviceGroup	Device group
UtilitiesPrepaymentMeterType	I_UtilsDvcePerdcRplcmntList	UtilitiesPrepaymentMeterType	Prepayment Meter
AdvancedMeteringSystem	I_UtilsDvcePerdcRplcmntList	AdvancedMeteringSystem	Advanced Metering System
UtilsDeviceInOutGroup	I_UtilsDvcePerdcRplcmntList	UtilsDeviceInOutGroup	Input/output group
UtilsDeviceSampleLot	I_UtilsDvcePerdcRplcmntList	UtilsDeviceSampleLot	Sample lot
UtilsDeviceInspRelevanceCode	I_UtilsDvcePerdcRplcmntList	UtilsDeviceInspRelevanceCode	Inspection relevance of device
UtilsDeviceCertificationYear	I_UtilsDvcePerdcRplcmntList	UtilsDeviceCertificationYear	Certification Year
UtilsDeviceAdvncRplcmtYear	I_UtilsDvcePerdcRplcmntList	UtilsDeviceAdvncRplcmtYear	Advance replacement year
UtilsDeviceCertfnStatus	I_UtilsDvcePerdcRplcmntList	UtilsDeviceCertfnStatus	Certification status
UtilsDeviceCertfnStatusName			Short Text for Fixed Values
UtilsDeviceCalibrnValdtyIsUsed	I_UtilsDvcePerdcRplcmntList	UtilsDeviceCalibrnValdtyIsUsed	Use calibration validity
InstdUtilsDeviceIsCertifiable	I_UtilsDvcePerdcRplcmntList	InstdUtilsDeviceIsCertifiable	Certify installed devices
UtilsDeviceInspectionNumber	I_UtilsDvcePerdcRplcmntList	UtilsDeviceInspectionNumber	Device inspection number
DvceIndivCertfnValdtyInYrs	I_UtilsDvcePerdcRplcmntList	DvceIndivCertfnValdtyInYrs	Individual cal. validity (years) of dev. subject to certif.
UtilsDeviceRemovalDate	I_UtilsDvcePerdcRplcmntList	UtilsDeviceRemovalDate	Device removal date
UtilitiesDevice	I_UtilsDvcePerdcRplcmntList	UtilitiesDevice	Equipment Number
UtilsDeviceLastLeadSealingDate	I_UtilsDvcePerdcRplcmntList	UtilsDeviceLastLeadSealingDate	Date of last lead sealing
MaintObjectLocAcctAssgmtNmbr	I_UtilsDvcePerdcRplcmntList	MaintObjectLocAcctAssgmtNmbr	Location and account assignment for technical object
MaintenanceObjectLocation	I_UtilsDvcePerdcRplcmntList	MaintenanceObjectLocation	Location of maintenance object
FunctionalLocation	I_UtilsDvcePerdcRplcmntList	FunctionalLocation	Functional Location
CityName	I_UtilsDvcePerdcRplcmntList	CityName	Name
District	I_UtilsDvcePerdcRplcmntList	District	District Court
DistrictName	I_UtilsDvcePerdcRplcmntList	DistrictName	District
HomeCityName	I_UtilsDvcePerdcRplcmntList	HomeCityName	City (different from postal city)
PostalCode	I_UtilsDvcePerdcRplcmntList	PostalCode	City postal code
StreetName	I_UtilsDvcePerdcRplcmntList	StreetName	Street
HouseNumber	I_UtilsDvcePerdcRplcmntList	HouseNumber	House Number
HouseNumberSupplementText	I_UtilsDvcePerdcRplcmntList	HouseNumberSupplementText	House number supplement
Country	I_UtilsDvcePerdcRplcmntList	Country	Country/Region Key
CountryName			Country/Region Name
Region	I_UtilsDvcePerdcRplcmntList	Region	Region (State, Province, County)
RegionName			Description
CityNumber	I_UtilsDvcePerdcRplcmntList	CityNumber	City code for city/street file
_PostalCity	I_UtilsDvcePerdcRplcmntList	_PostalCity
UtilsPerdcRplcmtCreatedByUser	I_UtilsDvcePerdcRplcmntList	UtilsPerdcRplcmtCreatedByUser	Name of Person Responsible for Creating the Object
UtilsPerdcRplcmtCreationDate	I_UtilsDvcePerdcRplcmntList	UtilsPerdcRplcmtCreationDate	Record Created On
UtilsPerdcRplcmtLastChangeDate	I_UtilsDvcePerdcRplcmntList	UtilsPerdcRplcmtLastChangeDate	Last Changed On
UtilsPerdcRplcmtLastChgdByUser	I_UtilsDvcePerdcRplcmntList	UtilsPerdcRplcmtLastChgdByUser	Name of Person Who Changed Object
MaintenanceOrder	I_UtilsDvcePerdcRplcmntList	MaintenanceOrder	Order Number
MaintenanceNotification	I_UtilsDvcePerdcRplcmntList	MaintenanceNotification	Notification Number
MeterReadingUnit	I_UtilsDvcePerdcRplcmntList	MeterReadingUnit	Meter Reading Unit
RegionalStructureGrouping	I_UtilsDvcePerdcRplcmntList	RegionalStructureGrouping	Regional structure grouping
NmbrOfDevicesToBeReplaced	I_UtilsDvcePerdcRplcmntList	NmbrOfDevicesToBeReplaced	Number of Devices to be Replaced
NmbrOfRemovedDevices	I_UtilsDvcePerdcRplcmntList	NmbrOfRemovedDevices	Number of Removed Devices

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_UtilsDvcePerdcRplcmntListQ.
-- 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: CEDVCEPERDCRLQ
-- Parameters: P_Language : sylangu, P_KeyDate : e_keydate_vdm

CREATE VIEW C_UtilsDvcePerdcRplcmntListQ AS
SELECT
  I_UtilsDvcePerdcRplcmntList.UtilsPerdcRplcmtYear AS UtilsPerdcRplcmtYear,
  I_UtilsDvcePerdcRplcmntList.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceFunctionClass AS UtilsDeviceFunctionClass,
  I_UtilsDvcePerdcRplcmntList._UtilsDeviceFunctionClass._UtilsDeviceFunctionClassText[1: Language=$parameters.P_Language].UtilsDeviceFunctionClassName AS UtilsDeviceFunctionClassName,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceConstructionClass AS UtilsDeviceConstructionClass,
  I_UtilsDvcePerdcRplcmntList._UtilsDvceConstructionClass._UtilsDvceConstructionClassT[1: Language=$parameters.P_Language].UtilsDvceConstructionClassName AS UtilsDvceConstructionClassName,
  I_UtilsDvcePerdcRplcmntList.Division AS Division,
  I_UtilsDvcePerdcRplcmntList._Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  I_UtilsDvcePerdcRplcmntList.MaintenancePlant AS MaintenancePlant,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceCertfnRqmtType AS UtilsDeviceCertfnRqmtType,
  I_UtilsDvcePerdcRplcmntList._UtilsDvceCertfnRqmtType._UtilsDvceCertfnRqmtTypeText[1: Language=$parameters.P_Language].UtilsDeviceCertfnRqmtTypeName AS UtilsDeviceCertfnRqmtTypeName,
  I_UtilsDvcePerdcRplcmntList.UtilsDvceCalibrnValdtylnYears AS UtilsDvceCalibrnValdtylnYears,
  I_UtilsDvcePerdcRplcmntList.UtilsDvceCalcNextRplcmtInYears AS UtilsDvceCalcNextRplcmtInYears,
  I_UtilsDvcePerdcRplcmntList.UtilsDvceIntCertfnPerdInYears AS UtilsDvceIntCertfnPerdInYears,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceOldCertfnInYears AS UtilsDeviceOldCertfnInYears,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceMeasurementType AS UtilsDeviceMeasurementType,
  I_UtilsDvcePerdcRplcmntList._UtilsDeviceMsmtType._UtilsDeviceMsmtTypeText[1: Language=$parameters.P_Language].UtilsDeviceMeasurementTypeName AS UtilsDeviceMeasurementTypeName,
  I_UtilsDvcePerdcRplcmntList.AssetManufacturerName AS AssetManufacturerName,
  I_UtilsDvcePerdcRplcmntList.ManufacturerCountry AS ManufacturerCountry,
  I_UtilsDvcePerdcRplcmntList.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilsDvcePerdcRplcmntList.ConstructionYear AS ConstructionYear,
  I_UtilsDvcePerdcRplcmntList.SerialNumber AS SerialNumber,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilsDvcePerdcRplcmntList.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsDvcePerdcRplcmntList.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilsDvcePerdcRplcmntList._UtilsDeviceCertfnStatus._UtilsDeviceCertfnStatusText[1: Language=$parameters.P_Language].UtilsDeviceCertfnStatusName AS UtilsDeviceCertfnStatusName,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilsDvcePerdcRplcmntList.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilsDvcePerdcRplcmntList.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilsDvcePerdcRplcmntList.UtilitiesDevice AS UtilitiesDevice,
  I_UtilsDvcePerdcRplcmntList.UtilsDeviceLastLeadSealingDate AS UtilsDeviceLastLeadSealingDate,
  I_UtilsDvcePerdcRplcmntList.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_UtilsDvcePerdcRplcmntList.MaintenanceObjectLocation AS MaintenanceObjectLocation,
  I_UtilsDvcePerdcRplcmntList.FunctionalLocation AS FunctionalLocation,
  I_UtilsDvcePerdcRplcmntList.CityName AS CityName,
  I_UtilsDvcePerdcRplcmntList.District AS District,
  I_UtilsDvcePerdcRplcmntList.DistrictName AS DistrictName,
  I_UtilsDvcePerdcRplcmntList.HomeCityName AS HomeCityName,
  I_UtilsDvcePerdcRplcmntList.PostalCode AS PostalCode,
  I_UtilsDvcePerdcRplcmntList.StreetName AS StreetName,
  I_UtilsDvcePerdcRplcmntList.HouseNumber AS HouseNumber,
  I_UtilsDvcePerdcRplcmntList.HouseNumberSupplementText AS HouseNumberSupplementText,
  I_UtilsDvcePerdcRplcmntList.Country AS Country,
  I_UtilsDvcePerdcRplcmntList._Country._Text[1: Language=$parameters.P_Language].CountryName AS CountryName,
  I_UtilsDvcePerdcRplcmntList.Region AS Region,
  I_UtilsDvcePerdcRplcmntList._Region._RegionText[1: Language=$parameters.P_Language].RegionName AS RegionName,
  I_UtilsDvcePerdcRplcmntList.CityNumber AS CityNumber,
  I_UtilsDvcePerdcRplcmntList._PostalCity AS _PostalCity,
  I_UtilsDvcePerdcRplcmntList.UtilsPerdcRplcmtCreatedByUser AS UtilsPerdcRplcmtCreatedByUser,
  I_UtilsDvcePerdcRplcmntList.UtilsPerdcRplcmtCreationDate AS UtilsPerdcRplcmtCreationDate,
  I_UtilsDvcePerdcRplcmntList.UtilsPerdcRplcmtLastChangeDate AS UtilsPerdcRplcmtLastChangeDate,
  I_UtilsDvcePerdcRplcmntList.UtilsPerdcRplcmtLastChgdByUser AS UtilsPerdcRplcmtLastChgdByUser,
  I_UtilsDvcePerdcRplcmntList.MaintenanceOrder AS MaintenanceOrder,
  I_UtilsDvcePerdcRplcmntList.MaintenanceNotification AS MaintenanceNotification,
  I_UtilsDvcePerdcRplcmntList.MeterReadingUnit AS MeterReadingUnit,
  I_UtilsDvcePerdcRplcmntList.RegionalStructureGrouping AS RegionalStructureGrouping,
  I_UtilsDvcePerdcRplcmntList.NmbrOfDevicesToBeReplaced AS NmbrOfDevicesToBeReplaced,
  I_UtilsDvcePerdcRplcmntList.NmbrOfRemovedDevices AS NmbrOfRemovedDevices
FROM I_UtilsDvcePerdcRplcmntList
;

Depth:

C_UtilsDvcePerdcRplcmntListQ view

I_UtilsDvcePerdcRplcmntList view