P_SIMLNLOGOTHERMSGCNT

DDL: P_SIMLNLOGOTHERMSGCNT SQL: PSIMLNMSGCNT Type: view CONSUMPTION Package: ODATA_MM_COMMONS_MASSUPDT

Other Message Count

P_SIMLNLOGOTHERMSGCNT is a Consumption CDS View that provides data about "Other Message Count" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocSimulationLog, I_PurchasingDocSimulationLog) and exposes 2 fields with key field SimulationJobUUID. Part of development package ODATA_MM_COMMONS_MASSUPDT.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocSimulationLog I_PurchasingDocSimulationLog from
I_PurchasingDocSimulationLog I_PurchasingDocSimulationLog union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSIMLNMSGCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Other Message Count view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SimulationJobUUID SimulationJobUUID
NumberOfUniqueInfoSuccessMsgs 
@AbapCatalog.sqlViewName: 'PSIMLNMSGCNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Other Message Count'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #L}

define view P_SIMLNLOGOTHERMSGCNT
  as select from I_PurchasingDocSimulationLog
{
  key SimulationJobUUID,
  cast (1 as abap.int4) as NumberOfUniqueInfoSuccessMsgs
} 
where SystemMessageType = 'S'
group by
  SimulationJobUUID,
  SystemMessageType
  
  union all
  
 select from I_PurchasingDocSimulationLog
{
  key SimulationJobUUID,
  cast (1 as abap.int4) as NumberOfUniqueInfoSuccessMsgs
} 
where SystemMessageType = 'I'
group by
  SimulationJobUUID,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4

Learn More