P_SIMLNLOGSINGLESUCCESS

CDS View

Single Success Log Message

P_SIMLNLOGSINGLESUCCESS is a CDS View in S/4HANA. Single Success Log Message. It contains 10 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 10 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MassUpdtCntrlCtrHierMsgDets view from CONSUMPTION Message Facet for HCTR Object Page
C_MassUpdtCntrlCtrMsgDets view from CONSUMPTION Message Facet for CCTR Object Page
C_MassUpdtPurgDocsMsgDets view from CONSUMPTION Message Facet Object Page
C_SimulationLogStatusCount view from CONSUMPTION Count error, wrng msgs in app log
P_PurgDocSimlnMsgId view from CONSUMPTION P View for Unique message ID

Fields (10)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument ActivePurchasingDocument,PurchasingDocument 2
KEY PurchasingDocumentItem PurchasingDocumentItem 2
KEY SimulationJobUUID SimulationJobUUID 2
KEY SystemMessageIdentification SystemMessageIdentification 2
KEY SystemMessageNumber SystemMessageNumber 2
KEY SystemMessageType SystemMessageType 2
KEY SystemMessageVariable1 SystemMessageVariable1 2
KEY SystemMessageVariable2 SystemMessageVariable2 2
KEY SystemMessageVariable3 SystemMessageVariable3 2
KEY SystemMessageVariable4 SystemMessageVariable4 2 
@AbapCatalog.sqlViewName: 'PLGSGLSUCCESS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Single Success Log Message'
@ObjectModel.usageType: {dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION

define view P_SimlnLogSingleSuccess
  as select from I_PurchasingDocSimulationLog
{
  key SimulationJobUUID,
      PurchasingDocument,
      PurchasingDocumentItem ,
      SystemMessageNumber          as SystemMessageNumber,
      SystemMessageIdentification  as SystemMessageIdentification,
      SystemMessageType            as SystemMessageType,
      SystemMessageVariable1       as SystemMessageVariable1,
      SystemMessageVariable2       as SystemMessageVariable2,
      SystemMessageVariable3       as SystemMessageVariable3,
      SystemMessageVariable4       as SystemMessageVariable4
//      @ObjectModel.virtualElement: true

//      @ObjectModel.virtualElementCalculatedBy: 'CL_MM_PUR_RPLD_CALC_DOC'

//      cast( '' as sychar10 )as NumberOfOccurrences

      
      /*case when SystemMessageType = 'S'
             then cast('899' as msgnr)
             else SystemMessageNumber   end         as SystemMessageNumber,

      case when SystemMessageType = 'S'
             then cast('MM' as abap.char(20))
             else SystemMessageIdentification   end as SystemMessageIdentification,

      SystemMessageType,

      case when SystemMessageType = 'S'
        then cast('' as sychar50)
        else SystemMessageVariable1 end             as SystemMessageVariable1,

      case when SystemMessageType = 'S'
        then cast('' as sychar50)
        else SystemMessageVariable2 end             as SystemMessageVariable2,

      case when SystemMessageType = 'S'
        then cast('' as sychar50)
        else SystemMessageVariable3 end             as SystemMessageVariable3,

      case when SystemMessageType = 'S'
        then cast('' as sychar50)
        else SystemMessageVariable4 end             as SystemMessageVariable4 */
}

Learn More