I_FinTransFlowType

DDL: I_FINTRANSFLOWTYPE SQL: IFTRFLOWTYPE Type: view BASIC Package: FTR_IRM_CORE

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 7 fields with key fields TreasuryContractType, FinTransFlowType. It has 2 associations to related views. Part of development package FTR_IRM_CORE.

Data Sources (2)

SourceAliasJoin Type
tzb0a FlowType from
at19 FlowTypeSupplement inner

Associations (2)

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

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 #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey FinTransFlowType view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Financial Transaction Flow Type view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TreasuryContractType tzb0a rantyp
KEY FinTransFlowType tzb0a sbewart
CashFlowCalculationCategory tzb0a sberfima
FinTransFlowCategory
TransFlowTypeIsRelevantForFee at19 sfee
_Text _Text
_TreasuryContractType _TreasuryContractType
@AbapCatalog.sqlViewName: 'IFTRFLOWTYPE'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.representativeKey: 'FinTransFlowType'
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,#CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@Metadata.ignorePropagatedAnnotations: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
  association [0..1] to I_TreasuryContractType  as _TreasuryContractType on $projection.TreasuryContractType = _TreasuryContractType.TreasuryContractType
{
      @ObjectModel.foreignKey.association: '_TreasuryContractType'
  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,
      _TreasuryContractType
}