R_FinTransUnfixedFlow

Financial Transaction Unfixed Flow | view: RFINTRANSUNFFLOW | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: VTBFHAPO_UNFIXEDT001TKA02
Column Name Description
CompanyCode Company Code
FinancialTransaction Financial Transaction
FinancialInstrumentActivity Transaction Activity
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowNumber Transaction Flow
Column Name Description
💲 Payment Currency (FinTransFlowPaytAmtCrcy):
FinTransFlowPaytAmt Payment Amount in Payment Currency
💲 Payment Currency (FinTransFlowNomAmtCrcy):
FinTransFlowNomAmt Payment Amount in Payment Currency
💲 Currency Key (LocalCurrency):
FinTransFlowInLoclCrcyPaytAmt Payment Amount in Local Currency
💲 Currency of Calculation Basis (FinTransFlowCalcBaseAmountCrcy):
FinTransFlowCalcBaseAmount Calculation Base Amount
Column Name Description
Column Name Description
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowPaymentDate Payment or Delivery Date
FinTransFlowPaymentDueDate Due Date
FinTransFlowPostingDate Posting Date in the Document
FinTransFlowIntrstRateFixDate Interest rate fixing date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
ConditionItemValidityStartDate Condition Item Effective From
Column Name Description
TreasuryContractType Contract Type Show values
FinTransFlowPaytAmtDirection Direction of Flow Show values
CalcPeriodStartDateIsMonthEnd Month-End Indicator for Start of a Calculation Period Show values
CalcPeriodEndDateIsMonthEnd Month-End Indicator for the End of a Calculation Period Show values
InterestCalculationMethod Interest Calculation Method Show values
FinTransFlowPostingStatus Posting Status of Flow Show values
FinTransFlowPostingBlkgReason Reason Why Flow Is Blocked for Posting Show values
FinTransFlowPostingRelease Release Given for Flow to Be Posted? Show values
FinInterestRateAdjmtStatus Status of Interest Rate Adjustment Show values
TreasuryIndividualPayment Individual Payment Show values
TrsyPaytGroupingSameDrctnIsRqd Same Direction Necessary for Joint Payment? Show values
TreasuryPaymentRequestGrouping Determine Grouping Definition Show values
FinancialTransactionDirection Direction of Transaction Show values
Column Name Description Domain name
FinTransFlowLoclCrcyCnvrsnRate Local Currency Rate UKURS
NumberOfCalculationDays Number of Days INT6
ConditionPercentageRate Percentage rate for condition items DECV3_7
FinTransPresentationItemID Presentation Item FTR_PRSNT_ID
RepetitiveCode Repetitive Code RPCODE
PayerPayee Payer/Payee BU_PARTNER
PayerPayeeBankDetail Partner Bank Details BVTYP
PaymentMethodsList List of Respected Payment Methods ZWELS
TreasuryIntGrpgForPaytValue Grouping Field for Automatic Payments CHAR20
PaymentRequest Key Number for Payment Request PRQ_KEYNO
FinInstrConditionLogicGroup Condition Group T_KOND
FinConditionItem Condition T_KOND
FinConditionSubItem Level number of condition item for recurring payments NUMC2
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • R_FINTRANSUNFIXEDFLOW.COUNTRY == T005.LAND1
  • R_FINTRANSUNFIXEDFLOW.MANDT == T005.MANDT
Currency of Calculation Basis
  • Currency of Calculation Basis
  • Client
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWCALCBASEAMOUNTCRCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.MANDT == TCURC.MANDT
Category of Flows and Conditions
  • ?
  • Category of Flows and Conditions
  • R_FINTRANSUNFIXEDFLOW.[column in domain "TB_SBKKLAS"] == AT07.SBKKLAS
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWCATEGORY == AT07.SBKTYP
Payment Currency
  • Payment Currency
  • Payment Currency
  • Client
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWNOMAMTCRCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWPAYTAMTCRCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.MANDT == TCURC.MANDT
Payment Currency
  • Payment Currency
  • Payment Currency
  • Client
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWNOMAMTCRCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWPAYTAMTCRCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.MANDT == TCURC.MANDT
Flow Type
  • Contract Type
  • Flow Type
  • Client
  • R_FINTRANSUNFIXEDFLOW.TREASURYCONTRACTTYPE == TZB0A.RANTYP
  • R_FINTRANSUNFIXEDFLOW.FINTRANSFLOWTYPE == TZB0A.SBEWART
  • R_FINTRANSUNFIXEDFLOW.MANDT == TZB0A.MANDT
Short Key for Own House Bank
  • Short Key for Own House Bank
  • Company Code
  • Client
  • R_FINTRANSUNFIXEDFLOW.HOUSEBANK == T012.HBKID
  • R_FINTRANSUNFIXEDFLOW.COMPANYCODE == T012.BUKRS
  • R_FINTRANSUNFIXEDFLOW.MANDT == T012.MANDT
Short Key for House Bank Account
  • Short Key for Own House Bank
  • Short Key for House Bank Account
  • Company Code
  • Client
  • R_FINTRANSUNFIXEDFLOW.HOUSEBANK == T012K.HBKID
  • R_FINTRANSUNFIXEDFLOW.HOUSEBANKACCOUNT == T012K.HKTID
  • R_FINTRANSUNFIXEDFLOW.COMPANYCODE == T012K.BUKRS
  • R_FINTRANSUNFIXEDFLOW.MANDT == T012K.MANDT
Currency Key
  • Currency Key
  • Client
  • R_FINTRANSUNFIXEDFLOW.LOCALCURRENCY == TCURC.WAERS
  • R_FINTRANSUNFIXEDFLOW.MANDT == TCURC.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • R_FINTRANSUNFIXEDFLOW.[column in domain "LAND1"] == T042Z.LAND1
  • R_FINTRANSUNFIXEDFLOW.MANDT == T042Z.MANDT
  • R_FINTRANSUNFIXEDFLOW.PAYMENTMETHOD == T042Z.ZLSCH
Payment method supplement
  • Payment method supplement
  • Client
  • R_FINTRANSUNFIXEDFLOW.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • R_FINTRANSUNFIXEDFLOW.MANDT == T042F.MANDT