P_FinTransPremFlw

DDL: P_FINTRANSPREMFLW SQL: PFINTRANSPREMFLW Type: view COMPOSITE Package: FTTR_CORE

Premium Flow

P_FinTransPremFlw is a Composite CDS View that provides data about "Premium Flow" in SAP S/4HANA. It reads from 1 data source (R_FinTransCashFlowActivity) and exposes 9 fields with key fields CompanyCode, FinancialTransaction. Part of development package FTTR_CORE.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
R_FinTransCashFlowActivity CashFlowActivity from

Annotations (10)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode R_FinTransCashFlowActivity CompanyCode
KEY FinancialTransaction R_FinTransCashFlowActivity FinancialTransaction
FinTransFlowPaymentDate Flow FinTransFlowPaymentDate
FinTransFlowType Flow FinTransFlowType
FinTransFlowPaytAmt Flow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy Flow FinTransFlowPaytAmtCrcy
PremiumPriceQuotedInPointsRate
PremiumPriceQuotedInPercent
OptionPremiumNotation 
@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' )

Learn More