I_FinTransFlowType

DDL: I_FINTRANSFLOWTYPE SQL: IFTRFLOWTYPE Type: view BASIC

Financial Transaction Flow Type

I_FinTransFlowType is a Basic CDS View that provides data about "Financial Transaction Flow Type" in SAP S/4HANA. It reads from 2 data sources (tzb0a, at19) and exposes 6 fields with key fields TreasuryContractType, FinTransFlowType. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
tzb0a FlowType from
at19 FlowTypeSupplement inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FinTransFlowTypeText _Text $projection.TreasuryContractType = _Text.TreasuryContractType and $projection.FinTransFlowType = _Text.FinTransFlowType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFTRFLOWTYPE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey FinTransFlowType view
AbapCatalog.preserveKey true view
EndUserText.label Financial Transaction Flow Type view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TreasuryContractType tzb0a rantyp
KEY FinTransFlowType tzb0a sbewart
CashFlowCalculationCategory tzb0a sberfima
FinTransFlowCategory
TransFlowTypeIsRelevantForFee at19 sfee
_Text _Text
@AbapCatalog.sqlViewName: 'IFTRFLOWTYPE'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.representativeKey: 'FinTransFlowType'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Financial Transaction Flow Type'
define view I_FinTransFlowType
  as select from tzb0a as FlowType
    inner join   at19  as FlowTypeSupplement on  FlowType.rantyp  = FlowTypeSupplement.rantyp
                                             and FlowType.sbewart = FlowTypeSupplement.sbewart                                   
  association [0..*] to I_FinTransFlowTypeText as _Text on  $projection.TreasuryContractType = _Text.TreasuryContractType
                                                    and $projection.FinTransFlowType     = _Text.FinTransFlowType
{

  key FlowType.rantyp as TreasuryContractType,
      @ObjectModel.text.association: '_Text'
  key FlowType.sbewart          as FinTransFlowType,
      FlowType.sberfima         as CashFlowCalculationCategory,
      cast( FlowTypeSupplement.sbktyp as ftr_flow_category preserving type )
                                as FinTransFlowCategory,
      FlowTypeSupplement.sfee   as TransFlowTypeIsRelevantForFee,
      _Text
}