P_AUDIT_AT_BKPF

@AbapCatalog.sqlViewName: 'PAUDITATBKPF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_AUDIT_AT_BKPF
  as select from P_AUDIT_AT_HELPER_LEDGER
    inner join   I_JournalEntry on  I_JournalEntry.CompanyCode        = P_AUDIT_AT_HELPER_LEDGER.CompanyCode
                                and I_JournalEntry.FiscalYear         = P_AUDIT_AT_HELPER_LEDGER.FiscalYear
                                and I_JournalEntry.AccountingDocument = P_AUDIT_AT_HELPER_LEDGER.AccountingDocument
{
  key I_JournalEntry.CompanyCode                  as bukrs,
  key I_JournalEntry.AccountingDocument           as belnr,
  key I_JournalEntry.FiscalYear                   as gjahr,
  key P_AUDIT_AT_HELPER_LEDGER.Ledger             as Ledger,
      I_JournalEntry.AccountingDocumentType       as blart,
      I_JournalEntry.DocumentDate                 as bldat,
      I_JournalEntry.PostingDate                  as budat,
      I_JournalEntry.TaxReportingDate             as vatdate,
      I_JournalEntry.DocumentReferenceID          as xblnr,
      I_JournalEntry.AccountingDocumentHeaderText as ltext,
      I_JournalEntry.AccountingDocumentCategory   as bstat,
      I_JournalEntry.TransactionCurrency          as waers,
      I_JournalEntry.AbsoluteExchangeRate         as kursf,
      I_JournalEntry.RecurringAccountingDocument  as dbblg,
      I_JournalEntry.TaxIsCalculatedAutomatically as xmwst

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"P_AUDIT_AT_HELPER_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/