CRMS4_IU_P_PODDEV

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 CRMS4_IU_P_PODDEV.
-- 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: CRMS4IUVPPODDEV

CREATE VIEW CRMS4_IU_P_PODDEV AS
SELECT
  coalesce( I_UtilsDvceInfoRecordHistory.SerialNumber, I_UtilitiesDevice.SerialNumber ) AS SerialNumber,
  I_UtilsAllocOfInstToPoD.UtilsInternalPointOfDelivery AS UtilsInternalPointOfDelivery,
  I_UtilsAllocOfInstToPoD.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndDate AS UtilsInstToPoDAllocEndDate,
  I_UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndTime AS UtilsInstToPoDAllocEndTime,
  I_UtilitiesRegisterRateData.UtilitiesLogicalRegisterNumber AS UtilitiesLogicalRegisterNumber,
  I_UtilitiesRegisterRateData.UtilsRegRateDataValdtyEndDate AS UtilsRegRateDataValdtyEndDate,
  I_UtilitiesRegister.UtilitiesRegister AS UtilitiesRegister,
  I_UtilitiesRegister.Equipment AS Equipment,
  I_UtilitiesRegister.UtilsRegisterValidityEndDate AS UtilsRegisterValidityEndDate,
  I_UtilsDvceInfoRecordHistory.UtilitiesDeviceInfoRecord AS UtilitiesDeviceInfoRecord,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityEndDate AS UtilsDvceIRValidiryEndDate,
  I_UtilitiesDevice.UtilitiesDevice AS UtilitiesDevice,
  I_UtilitiesDevice.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsAllocOfInstToPoD._UtilitiesInstallation AS _UtilitiesInstallation,
  I_UtilitiesRegister._Equipment AS _Equipment
INNER JOIN I_UtilitiesRegisterRateData ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesRegister ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsDvceInfoRecordHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesDevice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsAllocOfInstToPoD AS _UtilsAllocOfInstToPoD ON ( _UtilsAllocOfInstToPoD.UtilsInternalPointOfDelivery = UtilsInternalPointOfDelivery AND _UtilsAllocOfInstToPoD.UtilitiesInstallation = UtilitiesInstallation AND _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndDate = UtilsInstToPoDAllocEndDate AND _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndTime = UtilsInstToPoDAllocEndTime )  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesRegisterRateData AS _UtilitiesRegisterRateData ON ( _UtilitiesRegisterRateData.UtilitiesLogicalRegisterNumber = UtilitiesLogicalRegisterNumber AND _UtilitiesRegisterRateData.UtilitiesInstallation = UtilitiesInstallation AND _UtilitiesRegisterRateData.UtilsRegRateDataValdtyEndDate = UtilsRegRateDataValdtyEndDate )  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesRegister AS _UtilitiesRegister ON ( _UtilitiesRegister.UtilitiesRegister = UtilitiesRegister AND _UtilitiesRegister.Equipment = Equipment AND _UtilitiesRegister.UtilsRegisterValidityEndDate = UtilsRegisterValidityEndDate )  -- association [1..1]
LEFT OUTER JOIN I_UtilsDvceInfoRecordHistory AS _UtilsDvceInfoRecordHistory ON ( _UtilsDvceInfoRecordHistory.UtilitiesDeviceInfoRecord = UtilitiesDeviceInfoRecord AND _UtilsDvceInfoRecordHistory.UtilsDeviceValidityEndDate = UtilsDvceIRValidiryEndDate )  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesDevice AS _UtilitiesDevice ON ( _UtilitiesDevice.UtilitiesDevice = UtilitiesDevice AND _UtilitiesDevice.UtilsDeviceValidityEndDate = UtilsDeviceValidityEndDate )  -- association [0..1]
LEFT OUTER JOIN CRMS4_IU_I_POD AS _PointOfDelivery ON ( _PointOfDelivery.UtilsInternalPointOfDelivery = UtilsInternalPointOfDelivery )  -- association [1..1]
;