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


  association [0..1] to I_DocSingleWorkflowInfo        as _Status       on  $projection.CompanyCode        = _Status.CompanyCode
                                                                        and $projection.AccountingDocument = _Status.AccountingDocument
                                                                        and $projection.FiscalYear         = _Status.FiscalYear

  //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.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(
    // normal document with wf

    case when ( _JournalEntry.TransactionCode = 'FBVB' )
           and ( _JournalEntry.AccountingDocumentCategory =  ''
             or  _JournalEntry.AccountingDocumentCategory =  'L'
             or  _JournalEntry.AccountingDocumentCategory =  'U' )
           and ( _Status.WorkItem <> '000000000000' )
           and ( _Status.AccountingDocument is not null )
              then _Status.AccountingDocumentStatus
         // parked with wf

         when ( _JournalEntry.TransactionCode = 'FBDC_P001'
             or _JournalEntry.TransactionCode = 'FBDC_P050'
             or _JournalEntry.TransactionCode = 'FBDC_P051' )
           and( _JournalEntry.AccountingDocumentCategory =  'Z'
             or _JournalEntry.AccountingDocumentCategory =  'V' )
           and ( _Status.AccountingDocument is not null )
               then _Status.AccountingDocumentStatus
         else
           // other documents mapped as Not Workflow Relevant

           'Q'
            end as fac_mje_wf_status preserving type )                     as AcctgDocumentWorkflowStatus,

  @Semantics.booleanIndicator
  case  when ( _JournalEntry.TransactionCode = 'FBVB' )
         and ( _JournalEntry.AccountingDocumentCategory =  ''
           or  _JournalEntry.AccountingDocumentCategory =  'L'
           or  _JournalEntry.AccountingDocumentCategory =  'U' )
         and ( _Status.WorkItem <> '000000000000' )
         and ( _Status.AccountingDocument is not null )
            then 'X'
        when ( _JournalEntry.TransactionCode = 'FBDC_P001'
            or _JournalEntry.TransactionCode = 'FBDC_P050'
            or _JournalEntry.TransactionCode = 'FBDC_P051')
         and(  _JournalEntry.AccountingDocumentCategory = 'Z'
            or _JournalEntry.AccountingDocumentCategory = 'V' )
         and ( _Status.AccountingDocument is not null )
            then 'X'
          else '' end  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,

  //DCL

  _AccountingDocumentType

}

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