I_MIG_MigrationObjectStatus

DDL: I_MIG_MIGRATIONOBJECTSTATUS SQL: IMIGMIGOBJCTSTS Type: view BASIC Package: CNV_DMCR
10 Fields 1 Data Sources

MIG Migration Object Status

I_MIG_MigrationObjectStatus is a Basic CDS View that provides data about "MIG Migration Object Status" in SAP S/4HANA. It reads from 1 data source (dmc_mt_tables) and exposes 10 fields with key fields MassTransferCode, ReplicationInternalTableName. Part of development package CNV_DMCR.

Data Sources (1)

SourceAliasJoin Type
dmc_mt_tables dmc_mt_tables from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMIGMIGOBJCTSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MIG Migration Object Status view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MassTransferCode dmc_mt_tables id WorklistID
KEY ReplicationInternalTableName dmc_mt_tables tabname Table/Constant Value
MigrationObjectUUID dmc_mt_tables cobj_guid UUID 22 char.
definedendasMigrationObjectIsCreated
generatedendasRuntimeObjectIsGenerated
calculatedendasDataPortionsAreCalculated
failedendasMigrationObjectHasFailed
loadedendasDataPortionsAreLoaded
DataReadMode dmc_mt_tables reading_type Reading Type
DataWriteMode dmc_mt_tables write_behaviour Write Behavior

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_MIG_MigrationObjectStatus.
-- 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: IMIGMIGOBJCTSTS

CREATE VIEW I_MIG_MigrationObjectStatus AS
SELECT
  dmc_mt_tables.id AS MassTransferCode,
  dmc_mt_tables.tabname AS ReplicationInternalTableName,
  dmc_mt_tables.cobj_guid AS MigrationObjectUUID,
  case when dmc_mt_tables.defined != 'X' then '' else dmc_mt_tables.defined end as MigrationObjectIsCreated AS definedendasMigrationObjectIsCreated,
  case when dmc_mt_tables.generated != 'X' then '' else dmc_mt_tables.generated end as RuntimeObjectIsGenerated AS generatedendasRuntimeObjectIsGenerated,
  case when dmc_mt_tables.calculated != 'X' then '' else dmc_mt_tables.calculated end as DataPortionsAreCalculated AS calculatedendasDataPortionsAreCalculated,
  case when dmc_mt_tables.failed != 'X' then '' else dmc_mt_tables.failed end as MigrationObjectHasFailed AS failedendasMigrationObjectHasFailed,
  case when dmc_mt_tables.loaded != 'X' then '' else dmc_mt_tables.loaded end as DataPortionsAreLoaded AS loadedendasDataPortionsAreLoaded,
  dmc_mt_tables.reading_type AS DataReadMode,
  dmc_mt_tables.write_behaviour AS DataWriteMode
FROM dmc_mt_tables
;

Learn More