P_PostedParkedJournalEntry

@AbapCatalog.sqlViewName: 'PFIPOSTPARKJE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'AccountingDocument'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true 
@VDM.private:true

define view P_PostedParkedJournalEntry as select from I_JournalEntry {

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

    I_JournalEntry.AccountingDocCreatedByUser, 
    I_JournalEntry.AccountingDocumentCategory, 
    I_JournalEntry.AccountingDocumentClass, 
    I_JournalEntry.AccountingDocumentCreationDate, 
    I_JournalEntry.AccountingDocumentHeaderText, 
    I_JournalEntry.AccountingDocumentType, 
    I_JournalEntry.AdditionalCurrency1, 
    I_JournalEntry.AdditionalCurrency2, 
    I_JournalEntry.AlternativeReferenceDocument, 
//    I_JournalEntry.BatchInputSession, 

    I_JournalEntry.Branch, 
    I_JournalEntry.BusinessTransactionType, 
    I_JournalEntry.CompanyCodeCurrency, 
    I_JournalEntry.CreationTime, 
    I_JournalEntry.DocumentDate, 
    I_JournalEntry.DocumentReferenceID, 
    I_JournalEntry.ExchangeRate, 
    I_JournalEntry.ExchangeRateDate, 
    I_JournalEntry.ExchangeRateType, 
    I_JournalEntry.FinancialManagementArea, 
    I_JournalEntry.FiscalPeriod, 
    I_JournalEntry.IntercompanyTransaction, 
    I_JournalEntry.InvoiceReceiptDate, 
//    I_JournalEntry.IsDiscountDocument, 

    I_JournalEntry.IsReversal, 
    I_JournalEntry.IsReversed, 
    I_JournalEntry.LastChangeDate, 
//    I_JournalEntry.LatePaymentReason, 

//    I_JournalEntry.Ledger, 

    I_JournalEntry.LedgerGroup, 

//    I_JournalEntry.NmbrOfPages, 

    I_JournalEntry.OriginalReferenceDocument, 
//    I_JournalEntry.PlannedReversalDate, 

    I_JournalEntry.PostingDate, 
//    I_JournalEntry.RecurringAccountingDocument, 

    I_JournalEntry.Reference1InDocumentHeader, 
    I_JournalEntry.Reference2InDocumentHeader, 
    I_JournalEntry.LogicalSystem as ReferenceDocumentLogicalSystem, 
    I_JournalEntry.ReferenceDocumentType, 
//    I_JournalEntry.ReversalIsPlanned, 

    I_JournalEntry.ReversalReason, 
    I_JournalEntry.ReverseDocument, 
    I_JournalEntry.ReverseDocumentFiscalYear, 
//    I_JournalEntry.SalesDocumentCondition, 

//    I_JournalEntry.SenderAccountingDocument, 

//    I_JournalEntry.SenderCompanyCode, 

//    I_JournalEntry.SenderFiscalYear, 

//    I_JournalEntry.SenderLogicalSystem, 

//    I_JournalEntry.SourceCompanyCode, 

//    I_JournalEntry.TaxBaseAmountIsNetAmount, 

    I_JournalEntry.TaxExchangeRate, 
    I_JournalEntry.TaxIsCalculatedAutomatically, 
    I_JournalEntry.TaxReportingDate, 
    I_JournalEntry.TransactionCode, 
    I_JournalEntry.TransactionCurrency  
    
}

union all
select from I_ParkedAccountingDocument

{
key I_ParkedAccountingDocument.CompanyCode, 
key I_ParkedAccountingDocument.AccountingDocument, 
key I_ParkedAccountingDocument.FiscalYear, 

I_ParkedAccountingDocument.AccountingDocCreatedByUser, 
I_ParkedAccountingDocument.AccountingDocumentCategory, 
cast( '' as fis_accdoc_class ) as AccountingDocumentClass,
I_ParkedAccountingDocument.AccountingDocumentCreationDate,
I_ParkedAccountingDocument.AccountingDocumentHeaderText,
I_ParkedAccountingDocument.AccountingDocumentType,
I_ParkedAccountingDocument.AdditionalCurrency1, 
I_ParkedAccountingDocument.AdditionalCurrency2, 
cast ( '' as fis_xblnr_alt ) as AlternativeReferenceDocument,
I_ParkedAccountingDocument.Branch, 
cast( '' as fins_bttype ) as BusinessTransactionType,
I_ParkedAccountingDocument.CompanyCodeCurrency, 
I_ParkedAccountingDocument.CreationTime, 
 
I_ParkedAccountingDocument.DocumentDate, 
I_ParkedAccountingDocument.DocumentReferenceID, 
I_ParkedAccountingDocument.ExchangeRate, 
I_ParkedAccountingDocument.ExchangeRateDate,
cast( '' as kurst ) as ExchangeRateType, 
I_ParkedAccountingDocument.FinancialManagementArea, 
I_ParkedAccountingDocument.FiscalPeriod, 
I_ParkedAccountingDocument.IntercompanyTransaction, 
I_ParkedAccountingDocument.InvoiceReceiptDate, 
cast( '' as fins_xreversing ) as IsReversal,
cast( '' as fins_xreversed ) as IsReversed,
I_ParkedAccountingDocument.LastChangeDate, 
I_ParkedAccountingDocument.LedgerGroup, 
I_ParkedAccountingDocument.OriginalReferenceDocument, 
//I_ParkedAccountingDocument.PartnerCompany, 

I_ParkedAccountingDocument.PostingDate, 
cast( '' as fins_xref1_hd ) as Reference1InDocumentHeader, 
cast( '' as fins_xref1_hd ) as Reference2InDocumentHeader,
I_ParkedAccountingDocument.ReferenceDocumentLogicalSystem, 
I_ParkedAccountingDocument.ReferenceDocumentType, 
cast( '' as stgrd ) as ReversalReason,
cast( '' as fis_stblg ) as ReverseDocument, 
cast( '' as fis_stjah_no_conv ) as ReverseDocumentFiscalYear,
//I_ParkedAccountingDocument.SourceCompanyCode, 

I_ParkedAccountingDocument.TaxExchangeRate, 
I_ParkedAccountingDocument.TaxIsCalculatedAutomatically, 
I_ParkedAccountingDocument.TaxReportingDate, 
I_ParkedAccountingDocument.TransactionCode,
I_ParkedAccountingDocument.Currency as TransactionCurrency

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