I_UTILSDEVICERATEDATA

CDS View
14 Fields 6 CDS Views

Device Rate Data

I_UTILSDEVICERATEDATA is a CDS View in S/4HANA. Device Rate Data. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_UtilsDeviceRateDataDP view_entity from CONSUMPTION Data Provider for utils device rate data
C_UtilsDvceInfoRecdRateDataDP view_entity from CONSUMPTION Data Provider for dvce info rcd rte data
CRMS4_IU_C_PODDEV view inner Point of Delivery by Device
I_UtilsInfoRecdHistAndInst view from COMPOSITE Information Record History And Installation
I_UtilsInstdDvceAndInst view from COMPOSITE Installed Device And Installation
P_UtilsDeviceInfoRecordEntSrch view_entity from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY UtilitiesInstallation UtilitiesInstallation 3
KEY UtilitiesLogicalDeviceNumber UtilitiesLogicalDeviceNumber 4
KEY UtilsDvceRateDataValdtyEndDte bis,UtilsDvceRateDataValdtyEndDte 4
KEY UtilsDvceRateDataValdtyStrtDte ab,UtilsDvceRateDataValdtyStrtDte 4
_UtilitiesInstallation _UtilitiesInstallation 1
_UtilsDevicePriceClass _UtilsDevicePriceClass 3
_UtilsDeviceRateFactGrp _UtilsDeviceRateFactGrp 3
_UtilsDeviceRateType _UtilsDeviceRateType 3
UtilsDevicePriceClass UtilsDevicePriceClass 3
UtilsDeviceRateFactGroup UtilsDeviceRateFactGroup 3
UtilsDeviceRateType UtilsDeviceRateType 3
UtilsDvceIsNotBillingRelevant UtilsDvceIsNotBillingRelevant 3
UtilsDvceIsRelevantForRntlPrc UtilsDvceIsRelevantForRntlPrc 3
UtilsInstallationDvceRateData UtilsInstallationDvceRateData 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 Rate Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSDEVICERATEDATA (
    UTILITIESINSTALLATION,
    UTILITIESLOGICALDEVICENUMBER,
    UTILSDVCERATEDATAVALDTYENDDTE,
    UTILSDVCERATEDATAVALDTYSTRTDTE,
    _UTILITIESINSTALLATION,
    _UTILSDEVICEPRICECLASS,
    _UTILSDEVICERATEFACTGRP,
    _UTILSDEVICERATETYPE,
    UTILSDEVICEPRICECLASS,
    UTILSDEVICERATEFACTGROUP,
    UTILSDEVICERATETYPE,
    UTILSDVCEISNOTBILLINGRELEVANT,
    UTILSDVCEISRELEVANTFORRNTLPRC,
    UTILSINSTALLATIONDVCERATEDATA,
    PRIMARY KEY (UTILITIESINSTALLATION, UTILITIESLOGICALDEVICENUMBER, UTILSDVCERATEDATAVALDTYENDDTE, UTILSDVCERATEDATAVALDTYSTRTDTE)
);

Learn More