P_RU_InvoiceClearingDocItem

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUINVCLRDOCIT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_InvoiceClearingDocItem
  as select from I_OperationalAcctgDocItem

{
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  ClearingJournalEntry as ClearingAccountingDocument,
  ClearingJournalEntryFiscalYear as ClearingDocFiscalYear,
  InvoiceReference,
  InvoiceReferenceFiscalYear,

//  FinancialAccountType,

//  ReferenceDocumentType,


  case when AmountInCompanyCodeCurrency > 0
            then 1
            else -1
       end                                              as AmountSign

//case IsNegativePosting  when 'X' then  case DebitCreditCode  when 'S' then -1

//                                                             when 'H' then 1

//                                       end

//                        else case DebitCreditCode  when 'S' then 1

//                                                   when 'H' then -1

//                             end

//

//       end                                              as AmountSign

}
where
  (
       FinancialAccountType = 'K'
    or FinancialAccountType = 'D'
  )
//and ReferenceDocumentType <> 'RMRP'