I_MigratedDataInstance

DDL: I_MIGRATEDDATAINSTANCE Type: view_entity BASIC Package: CNV_DMCR_MC_INSTLOG
11 Fields 1 Data Sources

Migrated Data Instance

I_MigratedDataInstance is a Basic CDS View that provides data about "Migrated Data Instance" in SAP S/4HANA. It reads from 1 data source (dmc_miginst) and exposes 11 fields with key field DataMigrationInstanceUUID. Part of development package CNV_DMCR_MC_INSTLOG.

Data Sources (1)

SourceAliasJoin Type
dmc_miginst dmc_miginst from

Annotations (7)

NameValueLevelField
Analytics.technicalName IMIGDATAINST view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Migrated Data Instance view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationInstanceUUID instance_id Instance ID
MigrationObjectName mig_object_id Mig Object ID
DataMigrationLastExecutionUUID last_execution_id Last Execution ID
DataMigrtnInstanceMessageUUID message_id Msg ID
DataMigrtnInstanceImportState import_state Import State
DataMigrtnInstanceImportDteTme imported_at Timestamp of Import
DataMigrationProjectID
DataMigrationObjectID _DataMigrationObject DataMigrationObjectAlias
_RestartHandling _RestartHandling
_Logs _Logs
_LatestLog _LatestLog

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_MigratedDataInstance.
-- 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.

CREATE VIEW I_MigratedDataInstance AS
SELECT
  instance_id AS DataMigrationInstanceUUID,
  mig_object_id AS MigrationObjectName,
  last_execution_id AS DataMigrationLastExecutionUUID,
  message_id AS DataMigrtnInstanceMessageUUID,
  import_state AS DataMigrtnInstanceImportState,
  imported_at AS DataMigrtnInstanceImportDteTme,
  _DataMigrationObject._Subproject._DataMigrationCoreProject.DataMigrationProjectID AS DataMigrationProjectID,
  _DataMigrationObject.DataMigrationObjectAlias AS DataMigrationObjectID
FROM dmc_miginst
;

Learn More