I_DataMigrationValAll

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_DataMigrationValAll.
-- 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: IDMVALALL

CREATE VIEW I_DataMigrationValAll AS
SELECT
  DataMigrationObjectID AS ObjectName,
  _log.DataMigrationProjectID AS DataMigrationProjectID,
  _log.DataMigrationSenderKey AS DataMigrationSenderKey,
  _log.DataMigrationSenderKeyTxt AS DataMigrationSenderKeyTxt,
  _log.DataMigrationStatus AS DataMigrationStatus,
  _log.DataMigrationKeyValue1 AS DataMigrationKeyValue1,
  _log.DataMigrationKeyValue2 AS DataMigrationKeyValue2,
  _log.DataMigrationKeyValue3 AS DataMigrationKeyValue3,
  _log.DataMigrationKeyValue4 AS DataMigrationKeyValue4,
  _log.CreatedByUser AS DataMigrationCreatedByUserID,
  _log.CreationDateTime AS DataMigrationCreatedOnDateTime,
  _log.DataMigrationLoadingDate AS LoadingDate,
  1 AS NumberOfTotalRecords,
  _log._DataMigrationFile.DataMigrationFileUUID AS DataMigrationFileUUID,
  _log._DataMigrationFile.DataMigrationFileName AS DataMigrationFileName,
  _config.DataMigrationObjectUUID AS DataMigrationObjectUUID,
  _project.DataMigrationProjectUUID AS DataMigrationProjectUUID
FROM I_DataMigrtnLogItem AS _log
INNER JOIN I_DataMigrationValConfign AS _config ON /* join condition not captured in parsed metadata */
INNER JOIN R_DataMigrationProject AS _project ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_DataMigrationObjectVH AS _DataMigrationObject ON DataMigrationObjectUUID = _DataMigrationObject.DataMigrationObjectUUID  -- association [1..1]
LEFT OUTER JOIN R_DataMigrtnObjectDesc AS _DataMigrtnObjectDesc ON DataMigrationObjectUUID = _DataMigrtnObjectDesc.DataMigrationObjectUUID AND _DataMigrtnObjectDesc.Language = $session.system_language  -- association [1..1]
;