P_AUDIT_AT_HELPER_LEDGER

CDS View

Austrian Audit Helper Ledger

P_AUDIT_AT_HELPER_LEDGER is a CDS View in S/4HANA. Austrian Audit Helper Ledger. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AUDIT_AT_BKPF view from COMPOSITE
P_AUDIT_AT_BSET view_entity from COMPOSITE Austrian Audit Journal Tax Data

Fields (1)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger 2 
//@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Austrian Audit Helper Ledger'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
define view entity P_AUDIT_AT_HELPER_LEDGER
  as select from I_JournalEntryItem
{
  key I_JournalEntryItem.CompanyCode,
  key I_JournalEntryItem.FiscalYear,
  key I_JournalEntryItem.AccountingDocument,
  key I_JournalEntryItem.Ledger
}
where
  (
       AccountingDocumentCategory   =  ''
    or AccountingDocumentCategory   =  'L'
    or AccountingDocumentCategory   =  'U'
  )
  and  AccountingDocumentType       <> ''
  and  AmountInCompanyCodeCurrency  <> 0.00
  and(
       JrnlEntryItemMigrationSource =  ''
    or JrnlEntryItemMigrationSource =  ''
    or JrnlEntryItemMigrationSource =  ''
  )
group by
  I_JournalEntryItem.CompanyCode,
  I_JournalEntryItem.FiscalYear,
  I_JournalEntryItem.AccountingDocument,
  I_JournalEntryItem.Ledger
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More