C_DataMigrtnLgItmCatData

DDL: C_DATAMIGRTNLGITMCATDATA SQL: CDMCCLGITMCATDTA Type: view CONSUMPTION
32 Fields 1 Data Sources 7 Associations

Data mig log item Structure cat Data

C_DataMigrtnLgItmCatData is a Consumption CDS View that provides data about "Data mig log item Structure cat Data" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnLogItmCatDataEnhcd) and exposes 32 fields with key fields DataMigrationObjectID, DataMigrationProjectID, DataMigrationSenderKey, DataMigrtnSndrStrucName, DataMigrationSndrStrucField. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLogItmCatDataEnhcd _DataMigrtnLogItmCatDataEnhcd from

Associations (7)

CardinalityTargetAliasCondition
[1..*] C_DataMigrationValMsg _DataMigrationValMsg _DataMigrationValMsg.DataMigrationObjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationObjectID and _DataMigrationValMsg.DataMigrationProjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationProjectID and _DataMigrationValMsg.DataMigrationSenderKey = _DataMigrtnLogItmCatDataEnhcd.DataMigrationSenderKey
[1..1] C_DataMigrationValRecSts _DataMigrationValRecSts $projection.DataMigrationStatus = _DataMigrationValRecSts.DataMigrationStatus
[1..1] C_DataMigrationAuditSts _DataMigrationAuditSts $projection.DataMigrationLogItemAuditSts = _DataMigrationAuditSts.DataMigrationLogItemAuditSts
[1..1] C_DataMigrationValConfign _DataMigrationValConfign _DataMigrationValConfign.DataMigrationObjectID = $projection.DataMigrationObjectID
[1..1] C_DataMigrationProjectVH _DataMigrationProjectVH _DataMigrationProjectVH.DataMigrationProjectID = $projection.DataMigrationProjectID
[1..*] C_DataMigrationLogItemText _DataMigrationLogItemText _DataMigrationLogItemText.DataMigrtnLogItemMsgID = $projection.DataMigrtnLogItemMsgID
[1..*] C_DataMigrtnLgItemStructure _DataMigrtnLgItemStructure _DataMigrtnLgItemStructure.DataMigrationObjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationObjectID and _DataMigrtnLgItemStructure.DataMigrationProjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationProjectID and _DataMigrtnLgItemStructure.DataMigrationSenderKey = _DataMigrtnLogItmCatDataEnhcd.DataMigrationSenderKey

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CDMCCLGITMCATDTA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data mig log item Structure cat Data view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #CONSUMPTION view
Search.searchable true view
UI.headerInfo.typeName Instance view
UI.headerInfo.typeNamePlural Instances view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value DataMigrationSenderKey view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value DataMigrationSenderKeyTxt view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID DataMigrationObjectID
KEY DataMigrationProjectID DataMigrationProjectID
KEY DataMigrationSenderKey DataMigrationSenderKey Source ID
KEY DataMigrtnSndrStrucName DataMigrtnSndrStrucName
KEY DataMigrationSndrStrucField DataMigrationSndrStrucField
KEY DataMigrationSndrStrucFieldVal DataMigrationSndrStrucFieldVal Source Value
KEY DataMigrationKeyValue1 DataMigrationKeyValue1 Target Key 1
KEY DataMigrationKeyValue2 DataMigrationKeyValue2 Target Key 2
KEY DataMigrationKeyValue3 DataMigrationKeyValue3 Target Key 3
KEY DataMigrationKeyValue4 DataMigrationKeyValue4 Target Key 4
DataMigrationTgtStrucFieldVal DataMigrationTgtStrucFieldVal S/4HANA Target Value
DataMigrationSenderKeyTxt DataMigrationSenderKeyTxt Description
DataMigrationProjectDesc _DataMigrtnProject DataMigrationProjectDesc Project Description
DataMigrtnSndrStrucDesc DataMigrtnSndrStrucDesc Structure Name
DataMigrtnSndrStrucFieldLabel DataMigrtnSndrStrucFieldLabel Field Name
DataMigrationStatus DataMigrationStatus Instance Status
DataMigrationStggTblName DataMigrationStggTblName Staging Table
CreatedByUser CreatedByUser User Name
DataMigrationLoadingDate DataMigrationLoadingDate Created on
DataMigrtnLogItemMsgID DataMigrtnLogItemMsgID
DataMigrationStepExtID DataMigrationStepExtID
SemanticObject _DataMigrationValConfign SemanticObject Semantic Object
SemanticObjectAction _DataMigrationValConfign SemanticObjectAction Semantic Object Actn
DataMigrationLogItemAuditSts DataMigrationLogItemAuditSts
DataMigrtnLogItemApproverUser DataMigrtnLogItemApproverUser
DataMigrtnLgItmApprovalDteTime DataMigrtnLgItmApprovalDteTime
MassTransferCode _DataMigrationProjectVH MassTransferCode
_DataMigrationValMsg _DataMigrationValMsg
_DataMigrationValRecSts _DataMigrationValRecSts
_DataMigrationAuditSts _DataMigrationAuditSts
_DataMigrationLogItemText _DataMigrationLogItemText
_DataMigrtnLgItemStructure _DataMigrtnLgItemStructure

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 C_DataMigrtnLgItmCatData.
-- 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: CDMCCLGITMCATDTA

CREATE VIEW C_DataMigrtnLgItmCatData AS
SELECT
  DataMigrationObjectID,
  DataMigrationProjectID,
  DataMigrationSenderKey,
  DataMigrtnSndrStrucName,
  DataMigrationSndrStrucField,
  DataMigrationSndrStrucFieldVal,
  DataMigrationKeyValue1,
  DataMigrationKeyValue2,
  DataMigrationKeyValue3,
  DataMigrationKeyValue4,
  DataMigrationTgtStrucFieldVal,
  DataMigrationSenderKeyTxt,
  _DataMigrtnProject.DataMigrationProjectDesc AS DataMigrationProjectDesc,
  DataMigrtnSndrStrucDesc,
  DataMigrtnSndrStrucFieldLabel,
  DataMigrationStatus,
  DataMigrationStggTblName,
  CreatedByUser,
  DataMigrationLoadingDate,
  DataMigrtnLogItemMsgID,
  DataMigrationStepExtID,
  _DataMigrationValConfign.SemanticObject AS SemanticObject,
  _DataMigrationValConfign.SemanticObjectAction AS SemanticObjectAction,
  DataMigrationLogItemAuditSts,
  DataMigrtnLogItemApproverUser,
  DataMigrtnLgItmApprovalDteTime,
  _DataMigrationProjectVH.MassTransferCode AS MassTransferCode
FROM I_DataMigrtnLogItmCatDataEnhcd AS _DataMigrtnLogItmCatDataEnhcd
LEFT OUTER JOIN C_DataMigrationValMsg AS _DataMigrationValMsg ON _DataMigrationValMsg.DataMigrationObjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationObjectID AND _DataMigrationValMsg.DataMigrationProjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationProjectID AND _DataMigrationValMsg.DataMigrationSenderKey = _DataMigrtnLogItmCatDataEnhcd.DataMigrationSenderKey  -- association [1..*]
LEFT OUTER JOIN C_DataMigrationValRecSts AS _DataMigrationValRecSts ON DataMigrationStatus = _DataMigrationValRecSts.DataMigrationStatus  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationAuditSts AS _DataMigrationAuditSts ON DataMigrationLogItemAuditSts = _DataMigrationAuditSts.DataMigrationLogItemAuditSts  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationValConfign AS _DataMigrationValConfign ON _DataMigrationValConfign.DataMigrationObjectID = DataMigrationObjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationProjectVH AS _DataMigrationProjectVH ON _DataMigrationProjectVH.DataMigrationProjectID = DataMigrationProjectID  -- association [1..1]
LEFT OUTER JOIN C_DataMigrationLogItemText AS _DataMigrationLogItemText ON _DataMigrationLogItemText.DataMigrtnLogItemMsgID = DataMigrtnLogItemMsgID  -- association [1..*]
LEFT OUTER JOIN C_DataMigrtnLgItemStructure AS _DataMigrtnLgItemStructure ON _DataMigrtnLgItemStructure.DataMigrationObjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationObjectID AND _DataMigrtnLgItemStructure.DataMigrationProjectID = _DataMigrtnLogItmCatDataEnhcd.DataMigrationProjectID AND _DataMigrtnLgItemStructure.DataMigrationSenderKey = _DataMigrtnLogItmCatDataEnhcd.DataMigrationSenderKey  -- association [1..*]
;

Learn More