P_CO_DIANInvoiceFinDocument

@AbapCatalog.sqlViewName: 'PSRCOINVFINDOC'
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #P
@VDM: {
  lifecycle.status: #DEPRECATED,
  lifecycle.successor: 'P_CO_DIANFrmt1001JrnlEntrOplVw'
}
define view P_CO_DIANInvoiceFinDocument
  with parameters
    P_FromPostingDate : fis_budat_from,
    P_ToPostingDate   : fis_budat_to
  as select from I_JournalEntryItem as JournalEntryItem
  
  inner join I_StRpJournalEntryLog as ReportedItemsLog on ReportedItemsLog.CompanyCode        = JournalEntryItem.CompanyCode
                                                      and ReportedItemsLog.AccountingDocument = JournalEntryItem.AccountingDocument
                                                      and ReportedItemsLog.FiscalYear         = JournalEntryItem.FiscalYear

{  
  key JournalEntryItem.SourceLedger,
  key JournalEntryItem.Ledger,
  key JournalEntryItem.CompanyCode,
  key cast( JournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) as FiscalYear,
  key JournalEntryItem.AccountingDocument,  
  key JournalEntryItem.PurchasingDocument,
  key JournalEntryItem.PurchasingDocumentItem,
      ReportedItemsLog.StatryRptCategory,
      ReportedItemsLog.StatryRptgEntity,
      ReportedItemsLog.StatryRptRunID,
      
      JournalEntryItem._Ledger,
      JournalEntryItem._CompanyCode,
      JournalEntryItem._FiscalYear,
      JournalEntryItem._JournalEntry,
      JournalEntryItem._PurchasingDocument,
      JournalEntryItem._PurchasingDocumentItem
}
where
      PostingDate between $parameters.P_FromPostingDate and $parameters.P_ToPostingDate
  and ( PurchasingDocument is not null and PurchasingDocument <> '' )
  and ( IsReversal is null or IsReversal = '' ) 
  and ( IsReversed is null or IsReversed = '' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM",
"I_STRPJOURNALENTRYLOG"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_FISCALYEARFORCOMPANYCODE",
"I_JOURNALENTRY",
"I_LEDGER",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"BASE":
[
"I_JOURNALENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/