P_EVTBSDREVNRECPROJECTAPPLOG

CDS View

Headers of appl. log for projects

P_EVTBSDREVNRECPROJECTAPPLOG is a CDS View in S/4HANA. Headers of appl. log for projects. It contains 10 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 10 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EvtBsdRevnRecgnProjectIssDet view from CONSUMPTION Event based rev. rec. project iss detail
P_EvtBsdRevnRecProjectIssue view from CONSUMPTION Event based rev. rec. project issue

Fields (10)

KeyField CDS FieldsUsed in Views
KEY ApplicationLog ApplicationLog 2
AccountingPrinciple AccountingPrinciple 1
ApplicationLogHandle ApplicationLogHandle 1
CompanyCode CompanyCode 1
ExternalNumber ExternalNumber 1
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 2
NumberOfOpenErrorMessages NumberOfOpenErrorMessages 1
Prefix Prefix 1
WBSElementObject WBSElementObject 1 
@AbapCatalog.sqlViewName: 'PROJDOCISSERRSUM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Headers of appl. log for projects'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_EvtBsdRevnRecProjectAppLog
  as select from balhdr
{
  key lognumber                                                                   as ApplicationLog,
      extnumber                                                                   as ExternalNumber,
      rtrim ( substring(extnumber, 11, 20), ' ')                                  as WBSElementObject,
      substring(extnumber, 11, 2)                                                 as Prefix,
      cast ( substring(extnumber, 6, 4) as accounting_principle preserving type ) as AccountingPrinciple, //actual source is RLDNR!

      cast ( substring( extnumber, 39, 3 ) as poper )                             as FiscalPeriod,
      cast ( substring( extnumber, 34, 4 ) as gjahr )                             as FiscalYear,
      cast ( substring( extnumber, 1, 4) as bukrs preserving type )               as CompanyCode,
      cast( msg_cnt_e as abap.int4)                                               as NumberOfOpenErrorMessages,
      cast( log_handle as abap.sstring(22))                                       as ApplicationLogHandle
}
where
      object    =  'TBRR'
  and subobject =  'RERQ'
  and msg_cnt_e <> '000000'

Learn More