I_MIG_RmteSystemConnectionName

DDL: I_MIG_RMTESYSTEMCONNECTIONNAME SQL: IMIGRSYSCONNNAME Type: view BASIC Package: CNV_DMCM
6 Fields 2 Data Sources

MIG Remote System Connection Name

I_MIG_RmteSystemConnectionName is a Basic CDS View that provides data about "MIG Remote System Connection Name" in SAP S/4HANA. It reads from 2 data sources (P_MIG_MassTransfer, P_MIG_RemoteSystemConnection) and exposes 6 fields with key field MassTransferCode. Part of development package CNV_DMCM.

Data Sources (2)

SourceAliasJoin Type
P_MIG_MassTransfer mt_header from
P_MIG_RemoteSystemConnection system_connection left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMIGRSYSCONNNAME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MIG Remote System Connection Name view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MassTransferCode P_MIG_MassTransfer MassTransferCode WorklistID
MigrationSubproject P_MIG_MassTransfer MigrationSubproject Sub-project
SourceConnection P_MIG_RemoteSystemConnection SourceConnection
SourceConnectionType P_MIG_RemoteSystemConnection SourceConnectionType
TargetConnection P_MIG_RemoteSystemConnection TargetConnection
TargetConnectionType P_MIG_RemoteSystemConnection TargetConnectionType

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_RmteSystemConnectionName.
-- 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: IMIGRSYSCONNNAME

CREATE VIEW I_MIG_RmteSystemConnectionName AS
SELECT
  mt_header.MassTransferCode AS MassTransferCode,
  mt_header.MigrationSubproject AS MigrationSubproject,
  system_connection.SourceConnection AS SourceConnection,
  system_connection.SourceConnectionType AS SourceConnectionType,
  system_connection.TargetConnection AS TargetConnection,
  system_connection.TargetConnectionType AS TargetConnectionType
FROM P_MIG_MassTransfer AS mt_header
LEFT OUTER JOIN P_MIG_RemoteSystemConnection AS system_connection ON /* join condition not captured in parsed metadata */
;

Learn More