I_UtilitiesDevice

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_UtilitiesDevice.
-- 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: IEDEVICE

CREATE VIEW I_UtilitiesDevice AS
SELECT
  I_UtilitiesDeviceHistory.Equipment AS UtilitiesDevice,
  I_UtilitiesDeviceHistory.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilitiesDeviceHistory.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilitiesDeviceHistory.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilitiesDeviceHistory.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilitiesDeviceHistory.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilitiesDeviceHistory.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilitiesDeviceHistory.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilitiesDeviceHistory.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilitiesDeviceHistory.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilitiesDeviceHistory.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilitiesDeviceHistory.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilitiesDeviceHistory.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilitiesDeviceHistory.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilitiesDeviceHistory.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilitiesDeviceHistory.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  _Equipment.EquipmentCategory AS EquipmentCategory,
  _Equipment.TechnicalObjectType AS TechnicalObjectType,
  _Equipment.AuthorizationGroup AS AuthorizationGroup,
  _Equipment.AcquisitionDate AS AcquisitionDate,
  _Equipment.AcquisitionValue AS AcquisitionValue,
  _Equipment.Currency AS Currency,
  _Equipment.AssetManufacturerName AS AssetManufacturerName,
  _Equipment.ManufacturerCountry AS ManufacturerCountry,
  _Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  _Equipment.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  cast(_Equipment.ConstructionYear as e_dvce_constr_year_vdm ) AS ConstructionYear,
  cast(_Equipment.Material as gertyp preserving type) AS UtilitiesDeviceCategory,
  cast(_Equipment.SerialNumber as geraet preserving type) AS SerialNumber,
  _Equipment.Plant AS Plant,
  _Equipment.Division AS Division,
  _Equipment.StorageLocation AS StorageLocation,
  _Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  _Equipment.UniqueItemIdentifierStrucType AS UniqueItemIdentifierStrucType,
  _Equipment.UniqueItemIdentifierRespPlant AS UniqueItemIdentifierRespPlant,
  I_UtilitiesDeviceHeader.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilitiesDeviceHeader.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilitiesDeviceHeader.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilitiesDeviceHeader.UtilsDeviceMeasuredPressure AS UtilsDeviceMeasuredPressure,
  I_UtilitiesDeviceHeader.UtilsDeviceTransformationRatio AS UtilsDeviceTransformationRatio,
  I_UtilitiesDeviceHeader.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilitiesDeviceHeader.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilitiesDeviceHeader.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilitiesDeviceHeader.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilitiesDeviceHeader.SampleUtilsDeviceStatus AS SampleUtilsDeviceStatus,
  I_UtilitiesDeviceHeader.UtilsDeviceLastLeadSealingDate AS UtilsDeviceLastLeadSealingDate,
  I_UtilitiesDeviceHeader.UtilsDeviceCertfnType AS UtilsDeviceCertfnType,
  I_UtilitiesDeviceHeader.UtilsDeviceCertificationNumber AS UtilsDeviceCertificationNumber,
  I_UtilitiesDeviceHeader.UtilsDeviceModificationDate AS UtilsDeviceModificationDate,
  I_UtilitiesDeviceHeader.UtilsDeviceModReason AS UtilsDeviceModReason,
  I_UtilitiesDeviceHeader.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilitiesDeviceHeader.UtilsDeviceParametrizationCode AS UtilsDeviceParametrizationCode,
  I_UtilitiesDeviceHeader.UtilsDeviceLeadSealingCode AS UtilsDeviceLeadSealingCode,
  I_UtilitiesDeviceHeader.LastChangeDate AS LastChangeDate,
  I_UtilitiesDeviceHeader.UtilsDeviceLastChangedByUser AS UtilsDeviceLastChangedByUser,
  I_UtilitiesDeviceHeader.UtilsDeviceInspPointGroup AS UtilsDeviceInspPointGroup,
  I_UtilitiesDeviceHeader.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilitiesDeviceHeader.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilitiesDeviceHeader.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_UtilitiesDeviceHistory._UtilitiesDeviceHeader AS _UtilitiesDeviceHeader,
  I_UtilitiesDeviceHistory._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilitiesDeviceHistory._UtilsDvceActivityReason AS _UtilsDvceActivityReason,
  I_UtilitiesDeviceHistory._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilitiesDeviceHistory._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  _Equipment._Currency AS _Currency,
  _Equipment._Division AS _Division,
  _Equipment._EquipmentCategory AS _EquipmentCategory,
  _Equipment._Plant AS _Plant,
  _Equipment._StorageLocation AS _StorageLocation,
  _Equipment._TechnicalObjectType AS _TechnicalObjectType,
  _Equipment._ManufacturerCountry AS _ManufacturerCountry,
  I_UtilitiesDeviceHeader._UtilsDeviceCertfnStatus AS _UtilsDeviceCertfnStatus,
  I_UtilitiesDeviceHeader._UtilsDeviceCertfnType AS _UtilsDeviceCertfnType,
  I_UtilitiesDeviceHeader._UtilsDeviceLastChangedByUser AS _UtilsDeviceLastChangedByUser,
  I_UtilitiesDeviceHeader._UtilsDeviceModReason AS _UtilsDeviceModReason,
  I_UtilitiesDeviceHeader._UtilsDvceInspRelevance AS _UtilsDvceInspRelevance,
  I_UtilitiesDeviceHeader._UtilsDvceParametrization AS _UtilsDvceParametrization,
  I_UtilitiesDeviceHeader._UtilsSampleDeviceStatus AS _UtilsSampleDeviceStatus,
  I_UtilitiesDeviceHeader._UtilsDeviceSampleLot AS _UtilsDeviceSampleLot
FROM I_UtilitiesDeviceHistory
LEFT OUTER JOIN I_Equipment AS _Equipment ON UtilitiesDevice = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_EquipmentTimeSeg AS _EquipmentTimeSeg ON UtilitiesDevice = _EquipmentTimeSeg.Equipment  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON UtilitiesDevice = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_SerialNumberStockSegment AS _SerialNumberStockSegment ON _SerialNumberStockSegment.Equipment = UtilitiesDevice  -- association [0..1]
;