I_UTILSDEVICECATEGORY

CDS View
22 Fields 2 CDS Views

Device Category

I_UTILSDEVICECATEGORY is a CDS View in S/4HANA. Device Category. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EWA_ContainerAllocDetail view_entity from BASIC Fetch waste specific container
I_MeterReadingDocDvceInfoRecd view inner COMPOSITE Meter Reading Document Device Device Info Record

Fields (22)

KeyField CDS FieldsUsed in Views
KEY UtilitiesDeviceCategory UtilitiesDeviceCategory 1
_UtilsDeviceFunctionClass _UtilsDeviceFunctionClass 1
_UtilsDeviceMsmtType _UtilsDeviceMsmtType 1
_UtilsDvceAdvncdMeterCat _UtilsDvceAdvncdMeterCat 1
_UtilsDvceCertfnRqmtType _UtilsDvceCertfnRqmtType 1
_UtilsDvceConstructionClass _UtilsDvceConstructionClass 1
Division Division 1
UtilsDeviceAdvncdMeterCat UtilsDeviceAdvncdMeterCat 1
UtilsDeviceCategoryDescription UtilsDeviceCategoryDescription 2
UtilsDeviceCategoryPriceClass UtilsDeviceCategoryPriceClass 1
UtilsDeviceCertfnRqmtType UtilsDeviceCertfnRqmtType 1
UtilsDeviceConstructionClass UtilsDeviceConstructionClass 1
UtilsDeviceFunctionClass UtilsDeviceFunctionClass 1
UtilsDeviceGGWARegnNmbr UtilsDeviceGGWARegnNmbr 1
UtilsDeviceMeasurementType UtilsDeviceMeasurementType 1
UtilsDeviceNominalLoadValue UtilsDeviceNominalLoadValue 1
UtilsDeviceOldCertfnInYears UtilsDeviceOldCertfnInYears 1
UtilsDevicePTIRegnNmbr UtilsDevicePTIRegnNmbr 1
UtilsDeviceTransformationRatio UtilsDeviceTransformationRatio 1
UtilsDvceCalcNextRplcmtInYears UtilsDvceCalcNextRplcmtInYears 1
UtilsDvceCalibrnValdtylnYears UtilsDvceCalibrnValdtylnYears 1
UtilsDvceIntCertfnPerdInYears UtilsDvceIntCertfnPerdInYears 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 Category
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSDEVICECATEGORY (
    UTILITIESDEVICECATEGORY,
    _UTILSDEVICEFUNCTIONCLASS,
    _UTILSDEVICEMSMTTYPE,
    _UTILSDVCEADVNCDMETERCAT,
    _UTILSDVCECERTFNRQMTTYPE,
    _UTILSDVCECONSTRUCTIONCLASS,
    DIVISION,
    UTILSDEVICEADVNCDMETERCAT,
    UTILSDEVICECATEGORYDESCRIPTION,
    UTILSDEVICECATEGORYPRICECLASS,
    UTILSDEVICECERTFNRQMTTYPE,
    UTILSDEVICECONSTRUCTIONCLASS,
    UTILSDEVICEFUNCTIONCLASS,
    UTILSDEVICEGGWAREGNNMBR,
    UTILSDEVICEMEASUREMENTTYPE,
    UTILSDEVICENOMINALLOADVALUE,
    UTILSDEVICEOLDCERTFNINYEARS,
    UTILSDEVICEPTIREGNNMBR,
    UTILSDEVICETRANSFORMATIONRATIO,
    UTILSDVCECALCNEXTRPLCMTINYEARS,
    UTILSDVCECALIBRNVALDTYLNYEARS,
    UTILSDVCEINTCERTFNPERDINYEARS,
    PRIMARY KEY (UTILITIESDEVICECATEGORY)
);

Learn More