P_EVTBSDREVRECSALESORDERAPPLOG

CDS View

Headers of application log

P_EVTBSDREVRECSALESORDERAPPLOG is a CDS View in S/4HANA. Headers of application log. It contains 8 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 8 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EvtBsdRevnRecgnSlsOrdIssDet view from CONSUMPTION Event based rev. rec. project iss detail
P_EvtBsdRevnRecSalesOrderIss view from CONSUMPTION Event based rev. rec. sales order issue

Fields (8)

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

@EndUserText.label: 'Headers of application log'

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

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

define view P_EvtBsdRevRecSalesOrderAppLog
  as select from balhdr
{
  key  lognumber                                                                  as ApplicationLog,
       object                                                                     as Object,
       cast(log_handle as abap.sstring(22))                                       as ApplicationLogHandle,
       subobject                                                                  as SubObject,
       extnumber                                                                  as ExternalNumber,
       cast( substring( extnumber, 1, 4) as bukrs preserving type )               as CompanyCode,
       cast( substring( extnumber, 6, 4) as accounting_principle preserving type) as AccountingPrinciple,   //actual source is RLDNR!

       substring( extnumber, 11, 2)                                               as Prefix,
       cast( substring( extnumber, 13, 10) as vbeln preserving type )             as SDDocument,
       cast( substring( extnumber, 23, 6) as kdpos )                              as SDDocumentItem,
       cast( substring( extnumber, 34, 4) as gjahr)                               as FiscalYear,
       cast( substring( extnumber, 39, 3) as poper)                               as FiscalPeriod,       
       cast(msg_cnt_e as abap.int4)                                               as NumberOfOpenErrorMessages
}
where
      object    =  'TBRR'
  and subobject =  'RERQ'
  and msg_cnt_e <> '000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BALHDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More