C_UtilitiesDeviceInfoRecordDP

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_UtilitiesDeviceInfoRecordDP.
-- 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.

CREATE VIEW C_UtilitiesDeviceInfoRecordDP AS
SELECT
  UtilitiesDeviceInfoRecord,
  UtilsDeviceValidityEndDate,
  UtilsDeviceValidityStartDate,
  UtilitiesLogicalDeviceNumber,
  UtilitiesRegisterGroup,
  UtilitiesDeviceCategory,
  UtilsDeviceBscCatCombination,
  UtilsDeviceInstallationDate,
  UtilsDeviceRemovalDate,
  UtilsDeviceGroup,
  UtilitiesPrepaymentMeterType,
  UtilsDeviceLossDetnGroup,
  DvcePwrTrnsfrmtrPrimVoltVal,
  DvcePwrTrnsfrmtrSecdryVoltVal,
  DvcePwrTrnsfrmtrTrnsfRatingVal,
  AdvancedMeteringSystem,
  AdvancedMeterCapabilityGroup,
  UniqueItemIdentifier,
  UtilsDeviceWindingGroup,
  UtilsDeviceInfoRecdSrvcPrvd,
  SerialNumber,
  Division,
  UtilsInfoRecdAuthorizationGrp
FROM I_UtilsDvceInfoRecordHistory
LEFT OUTER JOIN C_UtilsDvceInfoRecdRateDataDP AS _UtilsDvceInfoRecdRateDataDP ON UtilitiesLogicalDeviceNumber = _UtilsDvceInfoRecdRateDataDP.UtilitiesLogicalDeviceNumber AND UtilsDeviceValidityEndDate >= _UtilsDvceInfoRecdRateDataDP.UtilsDvceRateDataValdtyStrtDte AND UtilsDeviceValidityStartDate <= _UtilsDvceInfoRecdRateDataDP.UtilsDvceRateDataValdtyEndDte  -- association [0..*]
;