C_UtilsTechlyInstdDeviceQuery

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

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