C_DataMigrationVal

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_DataMigrationVal.
-- 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: CDMVAL

CREATE VIEW C_DataMigrationVal AS
SELECT
  DataMigrationObjectID,
  DataMigrationSenderKey,
  DataMigrationProjectID,
  _DataMigrationObjectVH.DataMigrationObjectDesc AS DataMigrationObjectDesc,
  _DataMigrationObjectVH.DataMigrtnObjectNameInEnglish AS DataMigrtnObjectNameInEnglish,
  _DataMigrationObjectVH.ObjectName AS ObjectName,
  _DataMigrationProjectVH.MassTransferCode AS MassTransferCode,
  _DataMigrationProjectVH.DataMigrationProjectDesc AS DataMigrationProjectDesc,
  DataMigrationLoadingDate,
  DataMigrationStatus,
  DataMigrationStepExtID,
  cast (1 as abap.int8) AS NumberOfTotalRecords,
  cast(case when DataMigrationStatus = '3' then 1 else 0 end as abap.int8) as NumberOfImportedRecords AS int8asNumberOfImportedRecords,
  cast(case when DataMigrationStatus = '2' then 1 else 0 end as abap.int8) as NumberOfSimulatedRecords AS int8asNumberOfSimulatedRecords,
  cast(case when DataMigrationStatus = '1' then 1 else 0 end as abap.int8) as NumberOfErrorRecords AS int8asNumberOfErrorRecords,
  cast( '' as abap.char( 1 )) AS DataMigrtnIsStrucCatDataAvail,
  1 AS DataMigrationFailRateInPercent,
  0 AS DataMigrationSimRateInPercent,
  3 AS DataMigrationImpRateInPercent
FROM I_DataMigrtnLogItem
LEFT OUTER JOIN C_DataMigrationValAll AS _DataMigrationValAll ON _DataMigrationValAll.DataMigrationObjectID = DataMigrationObjectID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrationValMsgSum AS _DataMigrationValMsgSum ON _DataMigrationValMsgSum.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
LEFT OUTER JOIN C_DataMigrationObjectVH AS _DataMigrationObjectVH ON _DataMigrationObjectVH.DataMigrationObjectID = DataMigrationObjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationProjectVH AS _DataMigrationProjectVH ON _DataMigrationProjectVH.DataMigrationProjectID = DataMigrationProjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationValRecSts AS _DataMigrationValRecSts ON _DataMigrationValRecSts.DataMigrationStatus = DataMigrationStatus  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationValConfign AS _DataMigrationValConfign ON _DataMigrationValConfign.DataMigrationObjectID = DataMigrationObjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrtnLogItemMsg AS _DataMigrtnLogItemMsg ON _DataMigrtnLogItemMsg.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
LEFT OUTER JOIN C_DataMigrtnObjStructureCat AS _DataMigrtnObjStructureCat ON _DataMigrtnObjStructureCat.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
LEFT OUTER JOIN C_DataMigrtnObjStrucActvCat AS _DataMigrtnObjStrucActvCat ON _DataMigrtnObjStrucActvCat.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
LEFT OUTER JOIN C_DataMigrtnLgItmCatDataAggrgn AS _DataMigrtnLgItmCatDataAggrgn ON _DataMigrtnLgItmCatDataAggrgn.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
LEFT OUTER JOIN C_DataMigrtnProjObjSndrStruc AS _ObjSndrStruc ON _ObjSndrStruc.DataMigrationProjectID = 'MIG_SINNOVATION' AND _ObjSndrStruc.DataMigrationSubProjectID = 'MIG_SINNOVATION_FILE' AND _ObjSndrStruc.DataMigrationObjectID = DataMigrationObjectID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrtnObjInstceCntBySts AS _DataMigrtnObjInstceCntBySts ON _DataMigrtnObjInstceCntBySts.DataMigrationObjectID = DataMigrationObjectID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrtnLgItmCatCntBySts AS _DataMigrtnLgItmCatCntBySts ON _DataMigrtnLgItmCatCntBySts.DataMigrationObjectID = DataMigrationObjectID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrationValTileKPI AS _DataMigrationValTileKPI ON _DataMigrationValTileKPI.NumberOfImportedRecords = 0  -- association [0..1]
LEFT OUTER JOIN C_DataMigrtnSenderStructureFld AS _DataMigrtnSenderStructureFld ON _DataMigrtnSenderStructureFld.DataMigrationObjectID = DataMigrationObjectID  -- association [0..*]
;