I_DataMigrtnSenderStructureFld

DDL: I_DATAMIGRTNSENDERSTRUCTUREFLD SQL: IDMSNDRSTRUCTFLD Type: view COMPOSITE
15 Fields 1 Data Sources 3 Associations

Migration Object Sender Structure Field

I_DataMigrtnSenderStructureFld is a Composite CDS View that provides data about "Migration Object Sender Structure Field" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnProjObjSndrStruc) and exposes 15 fields with key fields DataMigrationProjectID, DataMigrationSubprojectID, DataMigrationObjectID, DataMigrtnSndrStrucName, DataMigrationSndrStrucField. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnProjObjSndrStruc _ObjSndrStruc from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_DataMigrtnProjObjField _DataMigrtnProjObjField _DataMigrtnProjObjField.DataMigrtnSndrStrucUUID = _ObjSndrStruc.DataMigrtnSndrStrucUUID
[1..1] I_DtaMigrtnObjStrucFieldView _DtaMigrtnObjStrucFieldView _DtaMigrtnObjStrucFieldView.MigrationObjectName = _ObjSndrStruc.MigrationObjectName and _DtaMigrtnObjStrucFieldView.DataMigrtnSndrStrucUUID = _ObjSndrStruc.DataMigrtnSndrStrucUUID and _DtaMigrtnObjStrucFieldView.DataMigrtnSndrStrucFieldUUID = _DataMigrtnProjObjField.DataMigrtnSndrStrucFieldUUID and _DtaMigrtnObjStrucFieldView.DataMigrtnVwIdn = 'SAP_BP_CLD_EE'
[0..*] I_DataMigrtnSenderStrucFldDesc _SndrStrucFldDesc $projection.DataMigrtnSndrStrucFieldUUID = _SndrStrucFldDesc.DataMigrtnSndrStrucFieldUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDMSNDRSTRUCTFLD view
EndUserText.label Migration Object Sender Structure Field view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationProjectID I_DataMigrtnProjObjSndrStruc DataMigrationProjectID Tree Structure
KEY DataMigrationSubprojectID I_DataMigrtnProjObjSndrStruc DataMigrationSubprojectID Tree Structure
KEY DataMigrationObjectID I_DataMigrtnProjObjSndrStruc DataMigrationObjectID Conv. Obj. Alias
KEY DataMigrtnSndrStrucName I_DataMigrtnProjObjSndrStruc DataMigrtnSndrStrucName Tree Structure
KEY DataMigrationSndrStrucField _DataMigrtnProjObjField DataMigrationSndrStrucField
DataMigrtnSndrStrucFieldPos _DataMigrtnProjObjField DataMigrtnSndrStrucFieldPos
IsKeyField _DataMigrtnProjObjField IsKeyField
DataMigrtnSndrStrucPos I_DataMigrtnProjObjSndrStruc DataMigrtnSndrStrucPos Sequential Number
DataMigrtnSndrStrucLevel I_DataMigrtnProjObjSndrStruc DataMigrtnSndrStrucLevel Level
DataMigrtnSndrStrucTreeUUID I_DataMigrtnProjObjSndrStruc DataMigrtnSndrStrucTreeUUID UUID 22 char.
MigrationObjectName I_DataMigrtnProjObjSndrStruc MigrationObjectName Tree Structure
DataMigrtnSndrStrucUUID I_DataMigrtnProjObjSndrStruc DataMigrtnSndrStrucUUID Table Name
DataMigrtnSndrStrucFieldUUID _DataMigrtnProjObjField DataMigrtnSndrStrucFieldUUID
_DtaMigrtnObjStrucFieldView _DtaMigrtnObjStrucFieldView
_SndrStrucFldDesc _SndrStrucFldDesc

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_DataMigrtnSenderStructureFld.
-- 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: IDMSNDRSTRUCTFLD

CREATE VIEW I_DataMigrtnSenderStructureFld AS
SELECT
  _ObjSndrStruc.DataMigrationProjectID AS DataMigrationProjectID,
  _ObjSndrStruc.DataMigrationSubprojectID AS DataMigrationSubprojectID,
  _ObjSndrStruc.DataMigrationObjectID AS DataMigrationObjectID,
  _ObjSndrStruc.DataMigrtnSndrStrucName AS DataMigrtnSndrStrucName,
  _DataMigrtnProjObjField.DataMigrationSndrStrucField AS DataMigrationSndrStrucField,
  _DataMigrtnProjObjField.DataMigrtnSndrStrucFieldPos AS DataMigrtnSndrStrucFieldPos,
  _DataMigrtnProjObjField.IsKeyField AS IsKeyField,
  _ObjSndrStruc.DataMigrtnSndrStrucPos AS DataMigrtnSndrStrucPos,
  _ObjSndrStruc.DataMigrtnSndrStrucLevel AS DataMigrtnSndrStrucLevel,
  _ObjSndrStruc.DataMigrtnSndrStrucTreeUUID AS DataMigrtnSndrStrucTreeUUID,
  _ObjSndrStruc.MigrationObjectName AS MigrationObjectName,
  _ObjSndrStruc.DataMigrtnSndrStrucUUID AS DataMigrtnSndrStrucUUID,
  _DataMigrtnProjObjField.DataMigrtnSndrStrucFieldUUID AS DataMigrtnSndrStrucFieldUUID
FROM I_DataMigrtnProjObjSndrStruc AS _ObjSndrStruc
LEFT OUTER JOIN I_DataMigrtnProjObjField AS _DataMigrtnProjObjField ON _DataMigrtnProjObjField.DataMigrtnSndrStrucUUID = _ObjSndrStruc.DataMigrtnSndrStrucUUID  -- association [1..*]
LEFT OUTER JOIN I_DtaMigrtnObjStrucFieldView AS _DtaMigrtnObjStrucFieldView ON _DtaMigrtnObjStrucFieldView.MigrationObjectName = _ObjSndrStruc.MigrationObjectName AND _DtaMigrtnObjStrucFieldView.DataMigrtnSndrStrucUUID = _ObjSndrStruc.DataMigrtnSndrStrucUUID AND _DtaMigrtnObjStrucFieldView.DataMigrtnSndrStrucFieldUUID = _DataMigrtnProjObjField.DataMigrtnSndrStrucFieldUUID AND _DtaMigrtnObjStrucFieldView.DataMigrtnVwIdn = 'SAP_BP_CLD_EE'  -- association [1..1]
LEFT OUTER JOIN I_DataMigrtnSenderStrucFldDesc AS _SndrStrucFldDesc ON DataMigrtnSndrStrucFieldUUID = _SndrStrucFldDesc.DataMigrtnSndrStrucFieldUUID  -- association [0..*]
;

Learn More