P_PE_JrnlEntryWthOfclDocClass

@AbapCatalog.sqlViewName: 'PJRNLWDOCCLN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Journal Entries With Document Class'

define view P_PE_JrnlEntryWthOfclDocClass 
  as select from    I_JournalEntry

    inner join      I_CompanyCode              as CompanyCode             
      on CompanyCode.CompanyCode = I_JournalEntry.CompanyCode

    left outer join I_DocTypeOfclDocClassAssgmt as DocTypeOfclDocClassAssgmt 
      on  DocTypeOfclDocClassAssgmt.Country                = CompanyCode.Country
      and DocTypeOfclDocClassAssgmt.AccountingDocumentType = I_JournalEntry.AccountingDocumentType

{
  key I_JournalEntry.CompanyCode,
  key FiscalYear,
  key AccountingDocument,

  case
    when TaxReportingDate = '00000000' then PostingDate
      else TaxReportingDate
  end as ReportingDate,

  ODNDocumentClass,
  I_JournalEntry.AccountingDocumentType,
  DocumentDate,
  PostingDate,
  FiscalPeriod,
  AccountingDocumentCreationDate,
  CreationTime,
  LastChangeDate,
  ExchangeRateDate,
  AccountingDocCreatedByUser,
  TransactionCode,
  IntercompanyTransaction,
  DocumentReferenceID,
  RecurringAccountingDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  ExchangeRate,
  AccountingDocumentCategory,
  BusinessTransactionType,
  BatchInputSession,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  I_JournalEntry.FinancialManagementArea,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  ReversalIsPlanned,
  PlannedReversalDate,
  TaxIsCalculatedAutomatically,
  TaxBaseAmountIsNetAmount,
  SourceCompanyCode,
  LogicalSystem,
  ReferenceDocumentLogicalSystem,
  TaxExchangeRate,
  ReversalReason,
  Branch,
  NmbrOfPages,
  IsDiscountDocument,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  InvoiceReceiptDate,
  Ledger,
  LedgerGroup,
  TaxReportingDate,
  AccountingDocumentClass,
  ExchangeRateType,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  SalesDocumentCondition,
  IsReversal,
  IsReversed,
  
  _CompanyCode,
  _FiscalYear,
   _FiscalPeriod,
  _AccountingDocumentType,
  _TransactionCurrency,
  _AccountingDocumentCategory,
  _ReferenceDocumentType,
  _FinancialManagementArea,
  _CompanyCodeCurrency,
  _LogicalSystem,
  _RefDocumentLogicalSystem,
  _Ledger, 
  _BusinessTransactionType
}