C_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 C_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: CDMVALALL

CREATE VIEW C_DataMigrationValAll AS
SELECT
  DataMigrationObjectID,
  DataMigrationProjectID,
  DataMigrationSenderKey,
  DataMigrationKeyValue1,
  DataMigrationKeyValue2,
  DataMigrationKeyValue3,
  DataMigrationKeyValue4,
  DataMigrationSenderKeyTxt,
  _DataMigrtnProject.MassTransferCode AS MassTransferCode,
  _DataMigrtnProject.DataMigrationProjectDesc AS DataMigrationProjectDesc,
  _DataMigrtnProject.DataMigrationProjectName AS DataMigrationProjectName,
  DataMigrationStatus,
  DataMigrationStggTblName,
  CreatedByUser,
  DataMigrationLoadingDate,
  DataMigrtnLogItemMsgID,
  DataMigrationStepExtID,
  _DataMigrationValConfign.SemanticObject AS SemanticObject,
  _DataMigrationValConfign.SemanticObjectAction AS SemanticObjectAction,
  DataMigrationLogItemAuditSts,
  DataMigrtnLogItemApproverUser,
  DataMigrtnLgItmApprovalDteTime,
  cast('' as text_description) AS NoteDescription,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey1Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey2Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey3Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey4Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey5Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey6Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey7Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey8Val,
  cast('' as abap.char(255)) AS DataMigrtnSndrKey9Val
FROM I_DataMigrtnLogItem AS _DataMigrtnLogItem
LEFT OUTER JOIN C_DataMigrationValMsg AS _DataMigrationValMsg ON _DataMigrationValMsg.DataMigrationObjectID = _DataMigrtnLogItem.DataMigrationObjectID AND _DataMigrationValMsg.DataMigrationProjectID = _DataMigrtnLogItem.DataMigrationProjectID AND _DataMigrationValMsg.DataMigrationSenderKey = _DataMigrtnLogItem.DataMigrationSenderKey  -- association [1..*]
LEFT OUTER JOIN C_DataMigrationValRecSts AS _DataMigrationValRecSts ON DataMigrationStatus = _DataMigrationValRecSts.DataMigrationStatus  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationAuditSts AS _DataMigrationAuditSts ON DataMigrationLogItemAuditSts = _DataMigrationAuditSts.DataMigrationLogItemAuditSts  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationVal AS _DataMigrationVal ON DataMigrationObjectID = _DataMigrationVal.DataMigrationObjectID AND DataMigrationProjectID = _DataMigrationVal.DataMigrationProjectID AND DataMigrationSenderKey = _DataMigrationVal.DataMigrationSenderKey  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationValConfign AS _DataMigrationValConfign ON _DataMigrationValConfign.DataMigrationObjectID = DataMigrationObjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationProjectVH AS _DataMigrationProjectVH ON _DataMigrationProjectVH.DataMigrationProjectID = DataMigrationProjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationLogItemText AS _DataMigrationLogItemText ON _DataMigrationLogItemText.DataMigrtnLogItemMsgID = DataMigrtnLogItemMsgID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrtnLgItemStructure AS _DataMigrtnLgItemStructure ON _DataMigrtnLgItemStructure.DataMigrationObjectID = DataMigrationObjectID AND _DataMigrtnLgItemStructure.DataMigrationProjectID = _DataMigrtnLogItem.DataMigrationProjectID AND _DataMigrtnLgItemStructure.DataMigrationSenderKey = _DataMigrtnLogItem.DataMigrationSenderKey  -- association [1..*]
;