I_UtilsDvceExtCertfnReplcmntYr

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_UtilsDvceExtCertfnReplcmntYr.
-- 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: IEDVCEECERTFNRY

CREATE VIEW I_UtilsDvceExtCertfnReplcmntYr AS
SELECT
  I_UtilitiesDevice.UtilitiesDevice AS UtilitiesDevice,
  I_UtilitiesDevice.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilitiesDevice.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilitiesDevice.AssetManufacturerName AS AssetManufacturerName,
  I_UtilitiesDevice.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilitiesDevice.ManufacturerCountry AS ManufacturerCountry,
  I_UtilitiesDevice.ConstructionYear AS ConstructionYear,
  I_UtilitiesDevice.SerialNumber AS SerialNumber,
  I_UtilitiesDevice.Plant AS Plant,
  I_UtilitiesDevice.StorageLocation AS StorageLocation,
  I_UtilitiesDevice.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilitiesDevice.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilitiesDevice.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilitiesDevice.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilitiesDevice.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilitiesDevice.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilitiesDevice.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilitiesDevice.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilitiesDevice.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilitiesDevice.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilitiesDevice.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilitiesDevice.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilitiesDevice.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilitiesDevice.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilitiesDevice.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilitiesDevice.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilitiesDevice.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilitiesDevice.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilitiesDevice.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_UtilitiesDevice.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_UtilitiesDevice.AuthorizationGroup AS AuthorizationGroup,
  cast(I_UtilitiesDevice.UtilsDeviceCertificationYear as abap.int4) + _UtilsDeviceCategory.UtilsDvceCalibrnValdtylnYears AS DvceExternalCertfnRplcmtYear,
  cast(0 as abap.int4) AS DvceSampleLotNextDueYear,
  cast(0 as abap.int4) AS DvceInternalCertfnRplcmtYear,
  cast(0 as abap.int4) AS DvceOldCertfnRplcmtYear,
  cast(0 as abap.int4) AS DvceLostCertfnRplcmtYear,
  cast(0 as abap.int4) AS DvceIndividualCertfnRplcmtYear,
  cast(0 as abap.int4) AS DvceAdvancedRplcmtYear,
  I_UtilitiesDevice._EquipmentText AS _EquipmentText,
  I_UtilitiesDevice._Plant AS _Plant,
  I_UtilitiesDevice._StorageLocation AS _StorageLocation,
  I_UtilitiesDevice._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilitiesDevice._UtilsDeviceCertfnStatus AS _UtilsDeviceCertfnStatus,
  I_UtilitiesDevice._UtilsDvceActivityReason AS _UtilsDvceActivityReason,
  I_UtilitiesDevice._UtilsDvceInspRelevance AS _UtilsDvceInspRelevance
FROM I_UtilitiesDevice
LEFT OUTER JOIN I_UtilsDeviceCategory AS _UtilsDeviceCategory ON UtilitiesDeviceCategory = _UtilsDeviceCategory.UtilitiesDeviceCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsDeviceSampleLot AS _UtilsDeviceSampleLot ON UtilsDeviceSampleLot = _UtilsDeviceSampleLot.UtilsDeviceSampleLot  -- association [0..1]
;