I_UTILSDVCEINFORECORDHISTORY

CDS View
27 Fields 5 CDS Views

Device Information Record History

I_UTILSDVCEINFORECORDHISTORY is a CDS View in S/4HANA. Device Information Record History. It contains 27 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_UtilitiesDeviceInfoRecordDP view_entity from CONSUMPTION Data Provider for utils device info rcd
CRMS4_IU_P_PODDEV view left_outer Point of Delivery by Device
I_MeterReadingDocDvceInfoRecd view union COMPOSITE Meter Reading Document Device Device Info Record
I_UtilsInfoRecdHistAndInst view inner COMPOSITE Information Record History And Installation
P_UtilsDeviceInfoRecordEntSrch view_entity inner COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
KEY SerialNumber DEV_SERNR,SerialNumber 4
KEY UtilitiesDeviceInfoRecord UtilitiesDeviceInfoRecord 3
KEY UtilsDeviceValidityEndDate UtilsDeviceValidityEndDate,UtilsDvceIRValidiryEndDate 4
_Division _Division 1
_UtilsAdvncdMeteringSystem _UtilsAdvncdMeteringSystem 2
_UtilsDvceLossDetnGroup _UtilsDvceLossDetnGroup 2
_UtilsRegisterGroupInfoText _UtilsRegisterGroupInfoText 2
AdvancedMeterCapabilityGroup AdvancedMeterCapabilityGroup 2
AdvancedMeteringSystem AdvancedMeteringSystem 2
Division Division 2
DvcePwrTrnsfrmtrPrimVoltVal DvcePwrTrnsfrmtrPrimVoltVal 2
DvcePwrTrnsfrmtrSecdryVoltVal DvcePwrTrnsfrmtrSecdryVoltVal 2
DvcePwrTrnsfrmtrTrnsfRatingVal DvcePwrTrnsfrmtrTrnsfRatingVal 2
UniqueItemIdentifier UniqueItemIdentifier 2
UtilitiesDeviceCategory UtilitiesDeviceCategory 3
UtilitiesLogicalDeviceNumber UtilitiesLogicalDeviceNumber 1
UtilitiesPrepaymentMeterType UtilitiesPrepaymentMeterType 2
UtilitiesRegisterGroup UtilitiesRegisterGroup 2
UtilsDeviceBscCatCombination UtilsDeviceBscCatCombination 2
UtilsDeviceGroup UtilsDeviceGroup 2
UtilsDeviceInfoRecdSrvcPrvd UtilsDeviceInfoRecdSrvcPrvd 2
UtilsDeviceInstallationDate UtilsDeviceInstallationDate 2
UtilsDeviceLossDetnGroup UtilsDeviceLossDetnGroup 2
UtilsDeviceRemovalDate UtilsDeviceRemovalDate 2
UtilsDeviceValidityStartDate UtilsDeviceValidityStartDate 3
UtilsDeviceWindingGroup UtilsDeviceWindingGroup 2
UtilsInfoRecdAuthorizationGrp UtilsInfoRecdAuthorizationGrp 2

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 Information Record History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSDVCEINFORECORDHISTORY (
    SERIALNUMBER,
    UTILITIESDEVICEINFORECORD,
    UTILSDEVICEVALIDITYENDDATE,
    _DIVISION,
    _UTILSADVNCDMETERINGSYSTEM,
    _UTILSDVCELOSSDETNGROUP,
    _UTILSREGISTERGROUPINFOTEXT,
    ADVANCEDMETERCAPABILITYGROUP,
    ADVANCEDMETERINGSYSTEM,
    DIVISION,
    DVCEPWRTRNSFRMTRPRIMVOLTVAL,
    DVCEPWRTRNSFRMTRSECDRYVOLTVAL,
    DVCEPWRTRNSFRMTRTRNSFRATINGVAL,
    UNIQUEITEMIDENTIFIER,
    UTILITIESDEVICECATEGORY,
    UTILITIESLOGICALDEVICENUMBER,
    UTILITIESPREPAYMENTMETERTYPE,
    UTILITIESREGISTERGROUP,
    UTILSDEVICEBSCCATCOMBINATION,
    UTILSDEVICEGROUP,
    UTILSDEVICEINFORECDSRVCPRVD,
    UTILSDEVICEINSTALLATIONDATE,
    UTILSDEVICELOSSDETNGROUP,
    UTILSDEVICEREMOVALDATE,
    UTILSDEVICEVALIDITYSTARTDATE,
    UTILSDEVICEWINDINGGROUP,
    UTILSINFORECDAUTHORIZATIONGRP,
    PRIMARY KEY (SERIALNUMBER, UTILITIESDEVICEINFORECORD, UTILSDEVICEVALIDITYENDDATE)
);

Learn More