R_ManageJournalEntry

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Journal Entry'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

define view entity R_ManageJournalEntry
as select from P_ManageJournalEntry  as _JournalEntry

  //DCL

  association [0..1] to I_AccountingDocumentType        as _AccountingDocumentType          on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
{
  key _JournalEntry.CompanyCode,
  key _JournalEntry.FiscalYear,
  key _JournalEntry.AccountingDocument,
  
  _JournalEntry.AccountingDocumentCategory,
  _JournalEntry.AccountingDocumentHeaderText,
  _JournalEntry.SenderAccountingDocument,
  _JournalEntry.AccountingDocumentType,
 // _JournalEntry.acc_principle as AccountingPrinciple,

  _JournalEntry.AdditionalCurrency1,
 // _JournalEntry.kurs2 as AdditionalCrcy1ExchangeRate,

  _JournalEntry.AdditionalCurrency1Role,  
  _JournalEntry.AdditionalCurrency2,
//  _JournalEntry.kurs3 as AdditionalCrcy2ExchangeRate, 

  _JournalEntry.AdditionalCurrency2Role, 
  _JournalEntry.AlternativeReferenceDocument,
 // _JournalEntry.rldnr_auth as AuthorizationCheckLedger,

 // _JournalEntry.blart_brgru as AuthorizationGroupDocumentType,

  _JournalEntry.Branch,
  _JournalEntry.BusinessTransactionType,
  _JournalEntry.JrnlEntryBusinessTransType,
  _JournalEntry.CompanyCodeCurrency, 
  _JournalEntry.SenderCompanyCode, 
//  _JournalEntry.co_belnr_sender as ControllingDocumentSender, 

  _JournalEntry.AccountingDocCreatedByUser,
  _JournalEntry.AccountingDocumentCreationDate, 
  _JournalEntry.CreationTime, 
  _JournalEntry.CreationDateTime, 
 // _JournalEntry.locpudt as LocalCreationDate,

  _JournalEntry.DocumentDate, 
  _JournalEntry.DocumentReferenceID, 
  _JournalEntry.AbsoluteExchangeRate,  
  _JournalEntry.ExchangeRateDate, 
  _JournalEntry.TaxAbsoluteExchangeRate,
  _JournalEntry.CtryCrcyTxAbsoluteExchangeRate,
  _JournalEntry.MarketDataAbsoluteExchangeRate,
  _JournalEntry.TaxCountry,
  _JournalEntry.ExchangeRateType, 
  _JournalEntry.FiscalPeriod, 
  cast(concat(_JournalEntry.FiscalYear, _JournalEntry.FiscalPeriod) as fins_fyearperiod) as FiscalYearPeriod,
  _JournalEntry.SenderFiscalYear, 

  _JournalEntry.JrnlEntryCntrySpecificRef1,
  _JournalEntry.JrnlEntryCntrySpecificDate1,
  _JournalEntry.JrnlEntryCntrySpecificRef2,
  _JournalEntry.JrnlEntryCntrySpecificDate2,
  _JournalEntry.JrnlEntryCntrySpecificRef3,
  _JournalEntry.JrnlEntryCntrySpecificDate3,
  _JournalEntry.JrnlEntryCntrySpecificRef4,
  _JournalEntry.JrnlEntryCntrySpecificDate4,
  _JournalEntry.JrnlEntryCntrySpecificRef5,
  _JournalEntry.JrnlEntryCntrySpecificDate5,
  _JournalEntry.JrnlEntryCntrySpecificBP1,
  _JournalEntry.JrnlEntryCntrySpecificBP2,
//  _JournalEntry.kzwrs as GroupCurrency

  _JournalEntry.IntercompanyTransaction, 
  _JournalEntry.InvoiceReceiptDate, 
  _JournalEntry.LastManualChangeDate,
  _JournalEntry.LastAutomaticChangeDate,
  _JournalEntry.Ledger,
  _JournalEntry.LedgerGroup,
  _JournalEntry.SenderLogicalSystem,
 // _JournalEntry.kursx as MarketDataExchangeRate, 

  _JournalEntry.NmbrOfPages,
  _JournalEntry.OriginalReferenceDocument,  
  
  _JournalEntry.ParkingTime, 
  _JournalEntry.ParkedByUser, 
 // _JournalEntry.ppnam_txt as ParkedByUserName,

  _JournalEntry.ParkingDate, 
  _JournalEntry.ParkingDateTime, 
//  _JournalEntry.loppdat as LocalParkedDate, calculated

//  _JournalEntry.pptcod as ParkTransaction,

  _JournalEntry.PostingDate,
//  _JournalEntry.dbblg_bukrs as RecrrgAccDocTemplCompanyCode,

//  _JournalEntry.dbblg_gjahr as RecurringAccDocTemplFiscalYear, 

  _JournalEntry.RecurringAccountingDocument,
  _JournalEntry.Reference1InDocumentHeader, 
  _JournalEntry.Reference2InDocumentHeader, 
  _JournalEntry.ReferenceDocumentType,
//  _JournalEntry.xreversal as ReversalFunction,

  _JournalEntry.ReversalReason,
  _JournalEntry.IsReversal,
  _JournalEntry.IsReversed,
  _JournalEntry.ReversedReferenceDocument,
  _JournalEntry.ReversalReferenceDocument,
  _JournalEntry.ReversedDocument,
  _JournalEntry.ReverseDocument,
  //_JournalEntry.,

  _JournalEntry.ReverseDocumentFiscalYear, 
  _JournalEntry.PlannedReversalDate, 
  _JournalEntry.TaxBaseAmountIsNetAmount, 
  _JournalEntry.TaxBaseAmountOrigin,
  _JournalEntry.TaxFulfillmentDate, 
  _JournalEntry.TaxIsCalculatedAutomatically, 
  _JournalEntry.TaxCalculationType,
  _JournalEntry.TaxReportingDate, 
  _JournalEntry.WithholdingTaxReportingDate, 
  _JournalEntry.TransactionCode, 
  _JournalEntry.TransactionCurrency,
  
  // Needed for Related Documents Tab

  _JournalEntry.ReferenceDocumentLogicalSystem,

  cast( 'Q' as fac_mje_wf_status preserving type ) as AcctgDocumentWorkflowStatus,
    
  @Semantics.booleanIndicator        
  ''  as WrkflwScenIsActv,
     
  @Semantics.booleanIndicator 
  case when   _JournalEntry.IsReversed = ''
        and ( _JournalEntry.ReferenceDocumentType = 'BKPF' or
              _JournalEntry.ReferenceDocumentType = 'BKPFF' or
              _JournalEntry.ReferenceDocumentType = 'IBKPF' or
              _JournalEntry.ReferenceDocumentType = 'FEBEP' or
              _JournalEntry.ReferenceDocumentType = 'GLYEC' or
              _JournalEntry.ReferenceDocumentType = 'ACES4' or
              _JournalEntry.AccountingDocumentCategory = 'O' )
        // parked documents cannot be reversed

        and _JournalEntry.AccountingDocumentCategory <> 'V'
        and _JournalEntry.AccountingDocumentCategory <> 'W'
        and _JournalEntry.AccountingDocumentCategory <> 'Z' 
            then 'X'
          else '' end as AccountingDocumentIsReversible,   

  _JournalEntry.JournalEntryLastChangeDateTime,
  
  _JournalEntry.ParkingTransactionCode,
  _JournalEntry.JournalEntryIsSecondaryEntry,
  _JournalEntry.EntryViewPostingControl,
  
  //DCL

  _AccountingDocumentType                

}