I_MigrtdDtaInstanceLogEnriched

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_MigrtdDtaInstanceLogEnriched.
-- 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: IMIGDATAINSTENR

CREATE VIEW I_MigrtdDtaInstanceLogEnriched AS
SELECT
  coalesce( dmc_miginstlog.log_id, dmc_migexecinst.instance_id ) AS DataMigrationInstanceLogUUID,
  dmc_migexecinst.execution_id AS DataMigrationExecutionUUID,
  dmc_migexecinst.instance_id AS DataMigrationInstanceUUID,
  coalesce( dmc_miginstlog.msgtype, 'S') AS SystemMessageType,
  coalesce( dmc_miginstlog.msgid, 'CNV_DMC_SIN') AS SystemMessageClass,
  case coalesce( dmc_miginstlog.msgno, dmc_migexec.testrun ) when 'X' then cast( '392' as msgnr ) when ' ' then cast( '393' as msgnr ) else dmc_miginstlog.msgno end as SystemMessageNumber AS msgnoendasSystemMessageNumber,
  dmc_miginstlog.msgv1 AS SystemMessageVariable1,
  dmc_miginstlog.msgv2 AS SystemMessageVariable2,
  dmc_miginstlog.msgv3 AS SystemMessageVariable3,
  dmc_miginstlog.msgv4 AS SystemMessageVariable4,
  cast ( coalesce( dmc_miginstlog.changed_at, dmc_migexec.created_at ) as dmc_changed_at ) AS LastChangeDateTime,
  dmc_miginstlog.msg_field AS DataMigrtnInstceLogRefFldName
LEFT OUTER JOIN I_MigratedDataInstance AS _DataInstance ON DataMigrationInstanceUUID = _DataInstance.DataMigrationInstanceUUID  -- association [1]
;