P_MX_InvoiceReceiptReference

@AbapCatalog.sqlViewName: 'PMXINVCRCPTREF'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #P

define view P_MX_InvoiceReceiptReference
  as select distinct from I_JournalEntryItem
  
  inner join I_StRpJournalEntryHeaderLog   on I_StRpJournalEntryHeaderLog.CompanyCode        = I_JournalEntryItem.CompanyCode
                                          and I_StRpJournalEntryHeaderLog.FiscalYear         = I_JournalEntryItem.FiscalYear
                                          and I_StRpJournalEntryHeaderLog.AccountingDocument = I_JournalEntryItem.AccountingDocument
                                    
  inner join I_StRpJournalEntryHeaderLog as ReferenceDocumentLog   
                                     on I_StRpJournalEntryHeaderLog.CompanyCode        = I_JournalEntryItem.CompanyCode
                                    and I_StRpJournalEntryHeaderLog.FiscalYear         = I_JournalEntryItem.FiscalYear
                                    and I_StRpJournalEntryHeaderLog.AccountingDocument = I_JournalEntryItem.ReferenceDocument
                                          and ReferenceDocumentLog.StatryRptCategory   = I_StRpJournalEntryHeaderLog.StatryRptCategory
                                          and ReferenceDocumentLog.StatryRptgEntity    = I_StRpJournalEntryHeaderLog.StatryRptgEntity
                                          and ReferenceDocumentLog.StatryRptRunID      = I_StRpJournalEntryHeaderLog.StatryRptRunID
{
  I_JournalEntryItem.CompanyCode,
  cast( I_JournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) as FiscalYear,
  I_JournalEntryItem.AccountingDocument,
  I_JournalEntryItem.AccountingDocumentItem     as AccountingDocumentItem,  
  I_JournalEntryItem.InvoiceReference           as InvoiceReference,
  cast( I_JournalEntryItem.InvoiceReferenceFiscalYear as fis_gjahr_no_conv preserving type ) as InvoiceReferenceFiscalYear,
  I_JournalEntryItem.ReferenceDocument          as ReferenceDocument,
  I_JournalEntryItem.ReferenceDocumentContext   as ReferenceDocumentContext,
  
  I_StRpJournalEntryHeaderLog.StatryRptCategory,
  I_StRpJournalEntryHeaderLog.StatryRptgEntity,
  I_StRpJournalEntryHeaderLog.StatryRptRunID
  
  }
where
     I_JournalEntryItem.ReferenceDocument <> '' 
 and I_JournalEntryItem.FinancialAccountType =  'K'
 and ReferenceDocumentType = 'RMRP'


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