I_ScenarioMigrationObject2

DDL: I_SCENARIOMIGRATIONOBJECT2 Type: view_entity COMPOSITE Package: CA_GTF_MIG_APP_EXPLMIGOBJ_VDM
4 Fields 1 Data Sources 1 Associations

Migration Scenario and releated Objects

I_ScenarioMigrationObject2 is a Composite CDS View that provides data about "Migration Scenario and releated Objects" in SAP S/4HANA. It reads from 1 data source (I_MigrationObjectsByScenario) and exposes 4 fields with key fields DtaMigrtnObjectScopeItemID, DataMigrationObjectID. It has 1 association to related views. Part of development package CA_GTF_MIG_APP_EXPLMIGOBJ_VDM.

Data Sources (1)

SourceAliasJoin Type
I_MigrationObjectsByScenario I_MigrationObjectsByScenario from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MigrationObjectStating _MigrationObjectStating _MigrationObjectStating.DataMigrationObjectID = $projection.DataMigrationObjectID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Migration Scenario and releated Objects view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY DtaMigrtnObjectScopeItemID DtaMigrtnObjectScopeItemID Scenario
KEY DataMigrationObjectID DataMigrationObjectID Migration Object
DataMigrationObjectName _MigrationObjectStating DataMigrationObjectName
_MigrationObject _MigrationObject

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_ScenarioMigrationObject2.
-- 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_ScenarioMigrationObject2 AS
SELECT
  DtaMigrtnObjectScopeItemID,
  DataMigrationObjectID,
  _MigrationObjectStating.DataMigrationObjectName AS DataMigrationObjectName
FROM I_MigrationObjectsByScenario
LEFT OUTER JOIN I_MigrationObjectStating AS _MigrationObjectStating ON _MigrationObjectStating.DataMigrationObjectID = DataMigrationObjectID  -- association [0..1]
;

Learn More