P_REALTIMEMFGORDERLOG

@AbapCatalog.sqlViewName: 'PRTMOLOG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@EndUserText.label: 'Event-Based WIP Order Application Log'

@AbapCatalog.preserveKey:true

define view P_RealTimeMfgOrderLog
  as select from P_RealTimeMfgOrderLogData 
{
  key LogNumber,
      LogHandle,
      LogMessageText,
      ApplicationLogObject,
      ApplicationLogSubobject,
      EvtBsdOrdRefTransText,
      CreatedByUser,
      CreationDate,
      CreationTime,
      EvtBsdProdnCostErrProcgSts,
      Ledger,
      case EvtBsdProdnCostMsgCat
        when '01' then 'Costing'
        when '02' then 'Locking'
        when '03' then 'Customizing'
        when '04' then 'MasterData'
        when '05' then 'Posting'
        when '99' then 'Others'
        else 'Others'
        end as EvtBsdProdnCostErrorType,
      OrderID,
      ControllingObject,
      Severity
}