I_DataMigrtnLgItmCatDataMsg

DDL: I_DATAMIGRTNLGITMCATDATAMSG SQL: IDMCCLGITMMSGCAT Type: view COMPOSITE
18 Fields 1 Data Sources 1 Associations

DM Log item Msgs by structure category

I_DataMigrtnLgItmCatDataMsg is a Composite CDS View that provides data about "DM Log item Msgs by structure category" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnLgItemActvCatData) and exposes 18 fields with key fields DataMigrationObjectID, DataMigrationProjectID, DataMigrationSenderKey, DataMigrtnSndrStrucName, DataMigrationSndrStrucField. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLgItemActvCatData _DataMigrtnLgItemActvCatData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DataMigrtnLogItmCatDataEnhcd _DataMigrtnLogItemCatDataEnhcd $projection.DataMigrationProjectID = _DataMigrtnLogItemCatDataEnhcd.DataMigrationProjectID and $projection.DataMigrationObjectID = _DataMigrtnLogItemCatDataEnhcd.DataMigrationObjectID and $projection.DataMigrationSenderKey = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSenderKey and $projection.DataMigrtnSndrStrucName = _DataMigrtnLogItemCatDataEnhcd.DataMigrtnSndrStrucName and $projection.DataMigrationSndrStrucField = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSndrStrucField and $projection.DataMigrationSndrStrucFieldVal = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSndrStrucFieldVal

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDMCCLGITMMSGCAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label DM Log item Msgs by structure category 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 (18)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID I_DataMigrtnLgItemActvCatData DataMigrationObjectID
KEY DataMigrationProjectID I_DataMigrtnLgItemActvCatData DataMigrationProjectID
KEY DataMigrationSenderKey I_DataMigrtnLgItemActvCatData DataMigrationSenderKey
KEY DataMigrtnSndrStrucName I_DataMigrtnLgItemActvCatData DataMigrtnSndrStrucName
KEY DataMigrationSndrStrucField I_DataMigrtnLgItemActvCatData DataMigrationSndrStrucField
KEY DataMigrationSndrStrucFieldVal I_DataMigrtnLgItemActvCatData DataMigrationSndrStrucFieldVal
KEY DataMigrationLogItemMsg _DataMigrtnLogItemMsg DataMigrationLogItemMsg
SystemMessageType _DataMigrtnLogItemMsg SystemMessageType Message type
SystemMessageClass _DataMigrtnLogItemMsg SystemMessageClass Message ID
SystemMessageNumber _DataMigrtnLogItemMsg SystemMessageNumber Message Number
SystemMessageVariable1 _DataMigrtnLogItemMsg SystemMessageVariable1 Variable 1
SystemMessageVariable2 _DataMigrtnLogItemMsg SystemMessageVariable2 Variable 2
SystemMessageVariable3 _DataMigrtnLogItemMsg SystemMessageVariable3 Variable 3
SystemMessageVariable4 _DataMigrtnLogItemMsg SystemMessageVariable4 Variable 4
DataMigrationFileUUID _DataMigrtnLogItemMsg DataMigrationFileUUID
DataMigrationStggTblName _DataMigrtnLogItemMsg DataMigrationStggTblName
DataMigrationTgtStrucFieldVal I_DataMigrtnLgItemActvCatData DataMigrationTgtStrucFieldVal
_DataMigrtnLogItemCatDataEnhcd _DataMigrtnLogItemCatDataEnhcd

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_DataMigrtnLgItmCatDataMsg.
-- 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: IDMCCLGITMMSGCAT

CREATE VIEW I_DataMigrtnLgItmCatDataMsg AS
SELECT
  _DataMigrtnLgItemActvCatData.DataMigrationObjectID AS DataMigrationObjectID,
  _DataMigrtnLgItemActvCatData.DataMigrationProjectID AS DataMigrationProjectID,
  _DataMigrtnLgItemActvCatData.DataMigrationSenderKey AS DataMigrationSenderKey,
  _DataMigrtnLgItemActvCatData.DataMigrtnSndrStrucName AS DataMigrtnSndrStrucName,
  _DataMigrtnLgItemActvCatData.DataMigrationSndrStrucField AS DataMigrationSndrStrucField,
  _DataMigrtnLgItemActvCatData.DataMigrationSndrStrucFieldVal AS DataMigrationSndrStrucFieldVal,
  _DataMigrtnLogItemMsg.DataMigrationLogItemMsg AS DataMigrationLogItemMsg,
  _DataMigrtnLogItemMsg.SystemMessageType AS SystemMessageType,
  _DataMigrtnLogItemMsg.SystemMessageClass AS SystemMessageClass,
  _DataMigrtnLogItemMsg.SystemMessageNumber AS SystemMessageNumber,
  _DataMigrtnLogItemMsg.SystemMessageVariable1 AS SystemMessageVariable1,
  _DataMigrtnLogItemMsg.SystemMessageVariable2 AS SystemMessageVariable2,
  _DataMigrtnLogItemMsg.SystemMessageVariable3 AS SystemMessageVariable3,
  _DataMigrtnLogItemMsg.SystemMessageVariable4 AS SystemMessageVariable4,
  _DataMigrtnLogItemMsg.DataMigrationFileUUID AS DataMigrationFileUUID,
  _DataMigrtnLogItemMsg.DataMigrationStggTblName AS DataMigrationStggTblName,
  _DataMigrtnLgItemActvCatData.DataMigrationTgtStrucFieldVal AS DataMigrationTgtStrucFieldVal
FROM I_DataMigrtnLgItemActvCatData AS _DataMigrtnLgItemActvCatData
LEFT OUTER JOIN I_DataMigrtnLogItmCatDataEnhcd AS _DataMigrtnLogItemCatDataEnhcd ON DataMigrationProjectID = _DataMigrtnLogItemCatDataEnhcd.DataMigrationProjectID AND DataMigrationObjectID = _DataMigrtnLogItemCatDataEnhcd.DataMigrationObjectID AND DataMigrationSenderKey = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSenderKey AND DataMigrtnSndrStrucName = _DataMigrtnLogItemCatDataEnhcd.DataMigrtnSndrStrucName AND DataMigrationSndrStrucField = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSndrStrucField AND DataMigrationSndrStrucFieldVal = _DataMigrtnLogItemCatDataEnhcd.DataMigrationSndrStrucFieldVal  -- association [1..1]
;

Learn More