P_FinTransPremFlw

@AbapCatalog.sqlViewName: 'PFINTRANSPREMFLW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view P_FinTransPremFlw 
as select from R_FinTransCashFlowActivity as CashFlowActivity 
 left outer to one join R_FinTransFlow as Flow on (CashFlowActivity.CompanyCode = Flow.CompanyCode 
                                                and CashFlowActivity.FinancialTransaction = Flow.FinancialTransaction
                                                and CashFlowActivity.FinancialInstrumentActivity = Flow.FinancialInstrumentActivity) {
    key CashFlowActivity.CompanyCode,
    key CashFlowActivity.FinancialTransaction,
    Flow.FinTransFlowPaymentDate,
    Flow.FinTransFlowType,
    Flow.FinTransFlowPaytAmt,
    Flow.FinTransFlowPaytAmtCrcy,
    cast ( Flow.PremiumPriceQuotedInPointsRate as ftr_premium_price_in_points preserving type ) as PremiumPriceQuotedInPointsRate,
    cast ( Flow.PremiumPriceQuotedInPercent as ftr_premium_price_in_percent preserving type ) as PremiumPriceQuotedInPercent,
    cast ( case when Flow.PremiumPriceQuotedInPointsRate is not initial then '1' else '2' end as ttm_opt_premium_notation ) as OptionPremiumNotation
        
} where ( CashFlowActivity.FinancialInstrProductCategory = '760' and Flow.FinTransFlowCategory = '30' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_FINTRANSCASHFLOWACTIVITY",
"R_FINTRANSFLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/