P_RecnclnCashFlowBasic

@AbapCatalog.sqlViewName: 'PCASHCOMBN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
define view P_RecnclnCashFlowBasic
  as select from I_CashPositionFlow as one_exposure
{ --I_CashPositionFlow P_CashFlowCombn
  key one_exposure.ValidFrom,
  key one_exposure.OriginSystem,
  key one_exposure.OriginApplication,
  key one_exposure.OriginDocument,
  key one_exposure.OriginTransaction,
  key one_exposure.OriginTransactionQualifier,
  key one_exposure.CashFlow,

      one_exposure.ExpirationDate,

      one_exposure.TransactionDate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      one_exposure.AmountInTransactionCurrency,
      @Semantics.currencyCode: true
      one_exposure.TransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      one_exposure.AmountInCompanyCodeCurrency,
      @Semantics.currencyCode: true
      one_exposure.CompanyCodeCurrency,
      one_exposure.DocumentItemText,
      one_exposure.BankAccountInternalID,
      one_exposure.CompanyCode,
      one_exposure.PlanningLevel,
      one_exposure.LiquidityItem,
      one_exposure.CertaintyLevel,
      one_exposure.AccountingDocument,

      BankStatementItem,
      BankStatementShortID,
      cast(case when one_exposure.CertaintyLevel = 'INTRAM' or one_exposure.CertaintyLevel = 'MEMO' or  one_exposure.CertaintyLevel = 'RFC'
      then  lpad(substring(one_exposure.OriginDocument,1,10),10,'0') end as fclm_mr_doc_id ) as MemoRecord
}
where
  (
           one_exposure.CertaintyLevel =  'INTRAM'
    or     one_exposure.CertaintyLevel =  'REC_N'
    or     one_exposure.CertaintyLevel =  'PAY_N'
    or     one_exposure.CertaintyLevel =  'SI_CIT'
    or     one_exposure.CertaintyLevel =  'CMIDOC'
    or     one_exposure.CertaintyLevel =  'MEMO'
    or     one_exposure.CertaintyLevel =  'RFC'
  )
  and      one_exposure.IsValid        =  'X'
  and(
           one_exposure.NetDueDate     =  '00000000'
    or(
           one_exposure.CertaintyLevel <> 'INTRAM'
      and  one_exposure.CertaintyLevel <> 'MEMO'
    )
    or(
      (
           one_exposure.CertaintyLevel =  'INTRAM'
        or one_exposure.CertaintyLevel =  'MEMO'
      )
      and  one_exposure.NetDueDate     >= $session.user_date
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHPOSITIONFLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/