I_UtilsDeviceCategory

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 I_UtilsDeviceCategory.
-- 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: IEDEVICECATEGORY

CREATE VIEW I_UtilsDeviceCategory AS
SELECT
  cast(etyp.matnr as gertyp preserving type) AS UtilitiesDeviceCategory,
  etyp.funklas AS UtilsDeviceFunctionClass,
  etyp.bauklas AS UtilsDeviceConstructionClass,
  cast(etyp.bauform as e_dvce_cat_name_vdm) AS UtilsDeviceCategoryDescription,
  etyp.preiskla AS UtilsDeviceCategoryPriceClass,
  etyp.ptbnum AS UtilsDevicePTIRegnNmbr,
  etyp.dvgwnum AS UtilsDeviceGGWARegnNmbr,
  etyp.bglkz AS UtilsDeviceCertfnRqmtType,
  etyp.vlzeitt AS UtilsDvceCalibrnValdtylnYears,
  etyp.vlzeitti AS UtilsDvceIntCertfnPerdInYears,
  etyp.vlzeitn AS UtilsDvceCalcNextRplcmtInYears,
  etyp.vlkzbau AS UtilsDeviceOldCertfnInYears,
  etyp.messart AS UtilsDeviceMeasurementType,
  etyp.ueberver AS UtilsDeviceTransformationRatio,
  etyp.sparte AS Division,
  etyp.nennbel AS UtilsDeviceNominalLoadValue,
  etyp.smart_meter AS UtilsDeviceAdvncdMeterCat
FROM etyp
LEFT OUTER JOIN I_UtilsDvceCertfnRqmtType AS _UtilsDvceCertfnRqmtType ON UtilsDeviceCertfnRqmtType = _UtilsDvceCertfnRqmtType.UtilsDeviceCertfnRqmtType  -- association [0..1]
LEFT OUTER JOIN I_UtilsDeviceMsmtType AS _UtilsDeviceMsmtType ON UtilsDeviceMeasurementType = _UtilsDeviceMsmtType.UtilsDeviceMeasurementType  -- association [0..1]
LEFT OUTER JOIN I_UtilsDvceAdvncdMeterCat AS _UtilsDvceAdvncdMeterCat ON UtilsDeviceAdvncdMeterCat = _UtilsDvceAdvncdMeterCat.UtilsDeviceAdvncdMeterCat  -- association [0..1]
LEFT OUTER JOIN I_UtilsDeviceFunctionClass AS _UtilsDeviceFunctionClass ON UtilsDeviceFunctionClass = _UtilsDeviceFunctionClass.UtilsDeviceFunctionClass  -- association [0..1]
LEFT OUTER JOIN I_UtilsDvceConstructionClass AS _UtilsDvceConstructionClass ON UtilsDeviceConstructionClass = _UtilsDvceConstructionClass.UtilsDeviceConstructionClass  -- association [0..1]
;