C_UtilsInstalledDeviceQuery

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 C_UtilsInstalledDeviceQuery.
-- 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: CEINSTALLEDDVCEQ
-- Parameters: P_Language : sylangu, P_KeyDate : e_keydate_vdm

CREATE VIEW C_UtilsInstalledDeviceQuery AS
SELECT
  I_UtilsInstalledDevice.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsInstalledDevice.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  I_UtilsInstalledDevice.Division AS Division,
  I_UtilsInstalledDevice._Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  I_UtilsInstalledDevice.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilsInstalledDevice.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsInstalledDevice.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsInstalledDevice.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilsInstalledDevice.UtilsDeviceFunctionClass AS UtilsDeviceFunctionClass,
  I_UtilsInstalledDevice._UtilsDeviceFunctionClass._UtilsDeviceFunctionClassText[1: Language=$parameters.P_Language].UtilsDeviceFunctionClassName AS UtilsDeviceFunctionClassName,
  I_UtilsInstalledDevice.UtilsDeviceConstructionClass AS UtilsDeviceConstructionClass,
  I_UtilsInstalledDevice._UtilsDvceConstructionClass._UtilsDvceConstructionClassT[1: Language=$parameters.P_Language].UtilsDvceConstructionClassName AS UtilsDvceConstructionClassName,
  I_UtilsInstalledDevice.UtilsDeviceMeasurementType AS UtilsDeviceMeasurementType,
  I_UtilsInstalledDevice._UtilsDeviceMsmtType._UtilsDeviceMsmtTypeText[1: Language=$parameters.P_Language].UtilsDeviceMeasurementTypeName AS UtilsDeviceMeasurementTypeName,
  I_UtilsInstalledDevice.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilsInstalledDevice.UtilsDvceCalibrnValdtylnYears AS UtilsDvceCalibrnValdtylnYears,
  I_UtilsInstalledDevice.UtilsDeviceAdvncdMeterCat AS UtilsDeviceAdvncdMeterCat,
  I_UtilsInstalledDevice.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilsInstalledDevice.ConstructionYear AS ConstructionYear,
  I_UtilsInstalledDevice.SerialNumber AS SerialNumber,
  I_UtilsInstalledDevice.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilsInstalledDevice.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsInstalledDevice.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilsInstalledDevice.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilsInstalledDevice.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilsInstalledDevice.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilsInstalledDevice.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsInstalledDevice.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilsInstalledDevice.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilsInstalledDevice.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilsInstalledDevice.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilsInstalledDevice._UtilsDvceInspRelevance._UtilsDvceInspRelevanceText[1: Language=$parameters.P_Language].UtilsDeviceInspRelevanceName AS UtilsDeviceInspRelevanceName,
  I_UtilsInstalledDevice.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilsInstalledDevice.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilsInstalledDevice.SampleUtilsDeviceStatus AS SampleUtilsDeviceStatus,
  I_UtilsInstalledDevice._UtilsSampleDeviceStatus._UtilsSampleDeviceStatusText[1: Language=$parameters.P_Language].SampleUtilsDeviceStatusName AS SampleUtilsDeviceStatusName,
  I_UtilsInstalledDevice.UtilsDeviceParametrizationCode AS UtilsDeviceParametrizationCode,
  I_UtilsInstalledDevice._UtilsDvceParametrization._UtilsDvceParametrizationText[1: Language=$parameters.P_Language].UtilsDeviceParametrizationName AS UtilsDeviceParametrizationName,
  I_UtilsInstalledDevice.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_UtilsInstalledDevice.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilsInstalledDevice.Plant AS Plant,
  I_UtilsInstalledDevice.MaintenancePlant AS MaintenancePlant,
  I_UtilsInstalledDevice._MaintenancePlant.PlantName AS PlantName,
  I_UtilsInstalledDevice.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_UtilsInstalledDevice.PlantName2 AS PlantName2,
  I_UtilsInstalledDevice.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_UtilsInstalledDevice.AuthorizationGroup AS AuthorizationGroup,
  I_UtilsInstalledDevice.FunctionalLocation AS FunctionalLocation,
  I_UtilsInstalledDevice._FunctionalLocation._FunctionalLocationText[1: Language=$parameters.P_Language].FunctionalLocationName AS FunctionalLocationName,
  I_UtilsInstalledDevice.MaintenanceObjectLocation AS MaintenanceObjectLocation,
  I_UtilsInstalledDevice.Country AS Country,
  I_UtilsInstalledDevice.Region AS Region,
  I_UtilsInstalledDevice.CityName AS CityName,
  I_UtilsInstalledDevice.CityNumber AS CityNumber,
  I_UtilsInstalledDevice.District AS District,
  I_UtilsInstalledDevice.HomeCityName AS HomeCityName,
  I_UtilsInstalledDevice.PostalCode AS PostalCode,
  I_UtilsInstalledDevice.StreetName AS StreetName,
  I_UtilsInstalledDevice.HouseNumber AS HouseNumber,
  I_UtilsInstalledDevice.HouseNumberSupplementText AS HouseNumberSupplementText,
  NmbrOfInstalledUtilsDevices,
  NmbrOfInstalledAdvancedMeters
FROM I_UtilsInstalledDevice
;