I_UTILSDVCEPERDCRPLCMNTLIST

CDS View
62 Fields 1 CDS Views

Device Periodic Replacement List

I_UTILSDVCEPERDCRPLCMNTLIST is a CDS View in S/4HANA. Device Periodic Replacement List. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_UtilsDvcePerdcRplcmntListQ view from CONSUMPTION Device Periodic Replacement List Query

Fields (62)

KeyField CDS FieldsUsed in Views
_PostalCity _PostalCity 1
AdvancedMeteringSystem AdvancedMeteringSystem 1
AssetManufacturerName AssetManufacturerName 1
CityName CityName 1
CityNumber CityNumber 1
ConstructionYear ConstructionYear 1
Country Country 1
District District 1
DistrictName DistrictName 1
Division Division 1
DvceIndivCertfnValdtyInYrs DvceIndivCertfnValdtyInYrs 1
FunctionalLocation FunctionalLocation 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
InstdUtilsDeviceIsCertifiable InstdUtilsDeviceIsCertifiable 1
MaintenanceNotification MaintenanceNotification 1
MaintenanceObjectLocation MaintenanceObjectLocation 1
MaintenanceOrder MaintenanceOrder 1
MaintenancePlant MaintenancePlant 1
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1
ManufacturerCountry ManufacturerCountry 1
ManufacturerPartTypeName ManufacturerPartTypeName 1
MeterReadingUnit MeterReadingUnit 1
NmbrOfDevicesToBeReplaced NmbrOfDevicesToBeReplaced 1
NmbrOfRemovedDevices NmbrOfRemovedDevices 1
PostalCode PostalCode 1
Region Region 1
RegionalStructureGrouping RegionalStructureGrouping 1
SerialNumber SerialNumber 1
StreetName StreetName 1
UtilitiesDevice UtilitiesDevice 1
UtilitiesDeviceCategory UtilitiesDeviceCategory 1
UtilitiesPrepaymentMeterType UtilitiesPrepaymentMeterType 1
UtilsDeviceAdvncRplcmtYear UtilsDeviceAdvncRplcmtYear 1
UtilsDeviceBscCatCombination UtilsDeviceBscCatCombination 1
UtilsDeviceCalibrnValdtyIsUsed UtilsDeviceCalibrnValdtyIsUsed 1
UtilsDeviceCategoryDescription UtilsDeviceCategoryDescription 1
UtilsDeviceCertfnRqmtType UtilsDeviceCertfnRqmtType 1
UtilsDeviceCertfnStatus UtilsDeviceCertfnStatus 1
UtilsDeviceCertificationYear UtilsDeviceCertificationYear 1
UtilsDeviceConstructionClass UtilsDeviceConstructionClass 1
UtilsDeviceFunctionClass UtilsDeviceFunctionClass 1
UtilsDeviceGroup UtilsDeviceGroup 1
UtilsDeviceInOutGroup UtilsDeviceInOutGroup 1
UtilsDeviceInspectionNumber UtilsDeviceInspectionNumber 1
UtilsDeviceInspRelevanceCode UtilsDeviceInspRelevanceCode 1
UtilsDeviceInstallationDate UtilsDeviceInstallationDate 1
UtilsDeviceLastLeadSealingDate UtilsDeviceLastLeadSealingDate 1
UtilsDeviceLocation UtilsDeviceLocation 1
UtilsDeviceMeasurementType UtilsDeviceMeasurementType 1
UtilsDeviceOldCertfnInYears UtilsDeviceOldCertfnInYears 1
UtilsDeviceRemovalDate UtilsDeviceRemovalDate 1
UtilsDeviceSampleLot UtilsDeviceSampleLot 1
UtilsDvceCalcNextRplcmtInYears UtilsDvceCalcNextRplcmtInYears 1
UtilsDvceCalibrnValdtylnYears UtilsDvceCalibrnValdtylnYears 1
UtilsDvceIntCertfnPerdInYears UtilsDvceIntCertfnPerdInYears 1
UtilsPerdcRplcmtCreatedByUser UtilsPerdcRplcmtCreatedByUser 1
UtilsPerdcRplcmtCreationDate UtilsPerdcRplcmtCreationDate 1
UtilsPerdcRplcmtLastChangeDate UtilsPerdcRplcmtLastChangeDate 1
UtilsPerdcRplcmtLastChgdByUser UtilsPerdcRplcmtLastChgdByUser 1
UtilsPerdcRplcmtYear UtilsPerdcRplcmtYear 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Device Periodic Replacement List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSDVCEPERDCRPLCMNTLIST (
    _POSTALCITY,
    ADVANCEDMETERINGSYSTEM,
    ASSETMANUFACTURERNAME,
    CITYNAME,
    CITYNUMBER,
    CONSTRUCTIONYEAR,
    COUNTRY,
    DISTRICT,
    DISTRICTNAME,
    DIVISION,
    DVCEINDIVCERTFNVALDTYINYRS,
    FUNCTIONALLOCATION,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INSTDUTILSDEVICEISCERTIFIABLE,
    MAINTENANCENOTIFICATION,
    MAINTENANCEOBJECTLOCATION,
    MAINTENANCEORDER,
    MAINTENANCEPLANT,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MANUFACTURERCOUNTRY,
    MANUFACTURERPARTTYPENAME,
    METERREADINGUNIT,
    NMBROFDEVICESTOBEREPLACED,
    NMBROFREMOVEDDEVICES,
    POSTALCODE,
    REGION,
    REGIONALSTRUCTUREGROUPING,
    SERIALNUMBER,
    STREETNAME,
    UTILITIESDEVICE,
    UTILITIESDEVICECATEGORY,
    UTILITIESPREPAYMENTMETERTYPE,
    UTILSDEVICEADVNCRPLCMTYEAR,
    UTILSDEVICEBSCCATCOMBINATION,
    UTILSDEVICECALIBRNVALDTYISUSED,
    UTILSDEVICECATEGORYDESCRIPTION,
    UTILSDEVICECERTFNRQMTTYPE,
    UTILSDEVICECERTFNSTATUS,
    UTILSDEVICECERTIFICATIONYEAR,
    UTILSDEVICECONSTRUCTIONCLASS,
    UTILSDEVICEFUNCTIONCLASS,
    UTILSDEVICEGROUP,
    UTILSDEVICEINOUTGROUP,
    UTILSDEVICEINSPECTIONNUMBER,
    UTILSDEVICEINSPRELEVANCECODE,
    UTILSDEVICEINSTALLATIONDATE,
    UTILSDEVICELASTLEADSEALINGDATE,
    UTILSDEVICELOCATION,
    UTILSDEVICEMEASUREMENTTYPE,
    UTILSDEVICEOLDCERTFNINYEARS,
    UTILSDEVICEREMOVALDATE,
    UTILSDEVICESAMPLELOT,
    UTILSDVCECALCNEXTRPLCMTINYEARS,
    UTILSDVCECALIBRNVALDTYLNYEARS,
    UTILSDVCEINTCERTFNPERDINYEARS,
    UTILSPERDCRPLCMTCREATEDBYUSER,
    UTILSPERDCRPLCMTCREATIONDATE,
    UTILSPERDCRPLCMTLASTCHANGEDATE,
    UTILSPERDCRPLCMTLASTCHGDBYUSER,
    UTILSPERDCRPLCMTYEAR
);

Learn More