C_DataMigrtnLgItmCatCntBySts

DDL: C_DATAMIGRTNLGITMCATCNTBYSTS SQL: CDMCATCNTBYSTAT Type: view CONSUMPTION
26 Fields 1 Data Sources

Instance count by Status

C_DataMigrtnLgItmCatCntBySts is a Consumption CDS View that provides data about "Instance count by Status" in SAP S/4HANA. It reads from 1 data source (C_DataMigrtnLgItmCatData) and exposes 26 fields with key fields DataMigrationObjectID, DataMigrationProjectID, DataMigrationSenderKey, DataMigrtnSndrStrucName, DataMigrationSndrStrucField.

Data Sources (1)

SourceAliasJoin Type
C_DataMigrtnLgItmCatData C_DataMigrtnLgItmCatData from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDMCATCNTBYSTAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Instance count by Status 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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID DataMigrationObjectID
KEY DataMigrationProjectID DataMigrationProjectID
KEY DataMigrationSenderKey DataMigrationSenderKey
KEY DataMigrtnSndrStrucName DataMigrtnSndrStrucName
KEY DataMigrationSndrStrucField DataMigrationSndrStrucField
KEY DataMigrationSndrStrucFieldVal DataMigrationSndrStrucFieldVal
DataMigrationTgtStrucFieldVal DataMigrationTgtStrucFieldVal
DataMigrationLoadingDate DataMigrationLoadingDate
DataMigrationStatus DataMigrationStatus
DataMigrationLogItemAuditSts DataMigrationLogItemAuditSts
CreatedByUser CreatedByUser User Name
DataMigrationSenderKeyTxt DataMigrationSenderKeyTxt
DataMigrationFileName DataMigrationFileName
DataMigrationProjectDesc DataMigrationProjectDesc
DataMigrationStggTblName DataMigrationStggTblName
DataMigrationKeyValue1 DataMigrationKeyValue1
DataMigrationKeyValue2 DataMigrationKeyValue2
DataMigrationKeyValue3 DataMigrationKeyValue3
DataMigrationKeyValue4 DataMigrationKeyValue4
NumberOfTotalRecords
int8asNumberOfErrorRecords
int8asNumberOfSimulatedRecords
int8asNumberOfImportedRecords
int8asNumberOfPendingRecords
int8asNumberOfApprovedRecords
int8asNumberOfRejectedRecords

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_DataMigrtnLgItmCatCntBySts.
-- 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: CDMCATCNTBYSTAT

CREATE VIEW C_DataMigrtnLgItmCatCntBySts AS
SELECT
  DataMigrationObjectID,
  DataMigrationProjectID,
  DataMigrationSenderKey,
  DataMigrtnSndrStrucName,
  DataMigrationSndrStrucField,
  DataMigrationSndrStrucFieldVal,
  DataMigrationTgtStrucFieldVal,
  DataMigrationLoadingDate,
  DataMigrationStatus,
  DataMigrationLogItemAuditSts,
  CreatedByUser,
  DataMigrationSenderKeyTxt,
  DataMigrationFileName,
  DataMigrationProjectDesc,
  DataMigrationStggTblName,
  DataMigrationKeyValue1,
  DataMigrationKeyValue2,
  DataMigrationKeyValue3,
  DataMigrationKeyValue4,
  cast (1 as abap.int8) AS NumberOfTotalRecords,
  cast(case when DataMigrationStatus = '1' then 1 else 0 end as abap.int8) as NumberOfErrorRecords AS int8asNumberOfErrorRecords,
  cast(case when DataMigrationStatus = '2' then 1 else 0 end as abap.int8) as NumberOfSimulatedRecords AS int8asNumberOfSimulatedRecords,
  cast(case when DataMigrationStatus = '3' then 1 else 0 end as abap.int8) as NumberOfImportedRecords AS int8asNumberOfImportedRecords,
  cast(case when DataMigrationLogItemAuditSts = '0' then 1 else 0 end as abap.int8) as NumberOfPendingRecords AS int8asNumberOfPendingRecords,
  cast(case when DataMigrationLogItemAuditSts = '1' then 1 else 0 end as abap.int8) as NumberOfApprovedRecords AS int8asNumberOfApprovedRecords,
  cast(case when DataMigrationLogItemAuditSts = '2' then 1 else 0 end as abap.int8) as NumberOfRejectedRecords AS int8asNumberOfRejectedRecords
FROM C_DataMigrtnLgItmCatData
;

Learn More