OTC_CONV_FHAPO

Backup Table for Financial Transaction Flows | #transactional | Component: Transaction Manager
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RFHA FK Financial Transaction
RFHAZU Transaction Activity
DCRDAT Entered On
TCRTIM Entry Time
RFHAZB Transaction Flow
Column Name Description
💲 Payment Currency (WZBETR):
BZBETR Payment Amount in Payment Currency
BDIRTY Dirty Price
BAMOUNTCOMP Amount to be Capitalized
BUGRENZ Lower Limit for Amount
BOGRENZ Upper Limit for Amt
PRESENT_AMOUNT Presentation Amount
PRESENT_DECREASE_AMOUNT Presentation Decreased Amount
PRESENT_REA_CRE_LINE Amount of Released Credit Line
PRESENT_PAY_AMT Payment Amount in Payment Currency
BKOND Condition item currency amount
💲 Currency Key (T001.WAERS):
BHWBETR Payment Amount in Local Currency
BHWPREIS Price in Local Currency
💲 Price Currency (WPRICE):
BPRICE Price per Unit
BINDEX Value of a Point
BNWHR Nominal Amount
NOMINAL_ORG_AMT Original Nominal Amount
💲 Currency of Calculation Basis (WBASIS):
BBASIS Calculation Base Amount
💲 Currency of Position Amount (WBBETR):
BBBETR Amount that Changes the Position
BBBETR_IDXCLEAN Amount Index-Clean that Changes the Position
💲 Price Currency (WEBETR):
BEBETR Market Value in Quotation Currency
💲 Currency of Haircut Amount (IDCFM_USHA_CURR):
IDCFM_USHA_TOTA Enter Haircut Amount in PC
Column Name Description
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
📏 OTC Quantity Conversion UoM (TRADED_QUANTITY_UOM):
TRADED_QUANTITY OTC Quantity Conversion
Column Name Description
DCRDAT Entered On
TCRTIM Entry Time
DUPDAT Changed On
TUPTIM Time Changed
DGUEL_KP Condition Item Effective From
DBUCHUNG Posting Date in the Document
DFAELL Due Date
DZTERM Payment or Delivery Date
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DPKOND Fixing Date of Percentage Rate from Condition
DZFEST Interest rate fixing date
DVALUT Calculation Date
DVERRECH Settlement date
DBESTAND Position Value Date
DCOUPON Coupon date of next delivered coupon
DBPERIOD Period start
DEPERIOD Period End
DGUEL_KPREF Condition Item Effective From
PRESENT_DATE Presentation Date
SHIPMENT_DATE Shipment Date
FX_FIXING_DATE Fixing Date
FX_READ_DATE Date of the Exchange Rate Read
PRICEINDEX_FIX_DATE_LOW Index Fixing Date
PRICEINDEX_READ_DATE_LOW Index Read Date
PRICEINDEX_FIX_DATE_HIGH Index Fixing Date
PRICEINDEX_READ_DATE_HIGH Index Read Date
Column Name Description
RANTYP Contract Type Show values
SBKKLAS Classification of Flows and Conditions Show values
SSIGN Direction of Flow Show values
RKONDGR Direction of Transaction Show values
SBZVABW Alternative Payment Details Stated in Flow Show values
SZART Payment Transaction Show values
SPAYRQ Generate Payment Request Show values
SPRSNG Individual Payment Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
SBEWEBE Posting Status of Flow Show values
SSPRGRD Reason Why Flow Is Blocked for Posting Show values
SBFREI Release Given for Flow to Be Posted? Show values
SSTORNOBWG Flow Reversal in Treasury Show values
SZBMETH Interest Calculation Method Show values
JEXPOZINS Type of Compound Interest Calculation Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SINCLBIS Inclusive Indicator for the End of a Calculation Period Show values
SULTBIS Month-End Indicator for the End of a Calculation Period Show values
SEXCLVON Exclusive Indicator for the Start of a Calculation Period Show values
SULTVON Month-End Indicator for Start of a Calculation Period Show values
SAEND Change Indicator for FiMa Flow Records Show values
SVINCL Inclusive indicator for value date Show values
SVULT Month-End Indicator for Value Date Show values
JSOFVERR Indicator for Immediate Settlement (Financial Mathematics) Show values
SINCLVERR Inclusive Indicator for Clearing Date Show values
SULTVERR Month-End Indicator for Clearing Date Show values
SSTORNOMAN Manual Reversal of Flows Posted in FI Show values
SKHWFIX Indicator for Translation into Local Currency Show values
SSTCKKZ Accrued interest method Show values
SSTCKTG Accrued interest: Daily method Show values
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation Show values
SCOUPON Coupon ID for interest and accrued interest calculation Show values
REGI_STATE Status of Interest Rate Adjustment Show values
SPAEXCL Exclusive Indicator for Start Date of a Period Show values
SPAULT Month-End Indicator for Start Date of a Period Show values
SPEINCL Inclusive Indicator for End Date of a Period Show values
SPEULT Month-End Indicator for End of a Period Show values
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
TAINTED Manipulated Cash Flow Show values
CLEARED Clearing at Flow Level Show values
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
FX_TRANSLATION Defines when quotation crcy is converted into payment crcy Show values
SSTAFF Type of Scaled Calculation Show values
INTEREST_PAID_BY Identify whether applicant or beneficiary pays interest Show values
STATUS Status Show values
PRESENT_DISCREPANCY Discrepancy Show values
SROUNDFACTOR Rounding Category of a Factor Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SROUNDBASEFACTOR Rounding Category of a Base Factor Show values
SKBWFIX Indicator for translation into position currency Show values
SROUNDRATEFACTOR Rounding Category of Interest Factor Show values
STGBASIS Base Days Method Show values
JAVGCAP Use Upper Limit of Average Interest Rate Show values
JAVGFLOOR Use Lower Limit of Average Interest Rate Show values
SROUNDAVGINTEREST Rounding Category of Average Interest Rate Show values
FX_REGI_STATE Status of Rate Fixing Show values
PRICEINDEX_REGI_STATE Status of Rate Fixing Show values
IDCFM_USHA_TYPE Haircut Rate Type Show values
Column Name Description Domain name
CRUSER Entered By SYCHAR12
UPUSER Last Changed By SYCHAR12
SHERKUNFT Display Area of Flow or Condition T_XFELD04
RKOND Condition T_KOND
NSTUFE Level number of condition item for recurring payments NUMC2
RPZAHL Payer/Payee BU_PARTNER
RPBANK Partner Bank Details BVTYP
ZWELS List of Respected Payment Methods ZWELS
PAYGR Grouping Field for Automatic Payments CHAR20
PRKEY Key Number for Payment Request PRQ_KEYNO
BELNR Document Number of an Accounting Document BELNR
BELNR2 Second Journal Entry No. for Currency Swaps BELNR
GJAHR Fiscal Year GJAHR
KHWKURS Local Currency Rate UKURS
ASTUECK No. of Units for Financial Instruments ASTUECK
VVBASIS Price in Points T_PKTKUR
PWKURS Price as Percentage Quotation DEC3_7
PRKKURS Currency Option Premium with Price in Points TB_KKURS
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
PKOND Percentage rate for condition items DECV3_7
SKALIDWT Interest Calendar WFCID
ZUONR Assignment number ZUONR
RLDEPO Securities Account RLDEPO
RANL Security Class ID Number WP_RANL
RTRBELNR Internal Document Number of Derivatives Document TPM_DEDOC_RDOCNRINT
BUPRC Security Price Without Currency Ref. with Unit Quotation VVPKTKUR
BPPRC Security Price for Percentage Quotation VVPKTKUR
KZWKURS Payment Currency Rate UKURS
KBWKURS Position Currency Rate UKURS
AWKEY Reference Key AWKEY
INDEX_VALUE Index Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIO
SBASIS Calculation Base Indicator VVSBASIS
RPCODE Repetitive Code RPCODE
RP_TEXT Reference Text for Repetitive Code XTEXT50
HEDGE_ID Identification for Hedging Relationship
AMMRHY Frequency in months NUMC03
PPAYMENT Payment Rate TFM_PPAYMENT
NOM_FACTOR Factor
RLDEPO2 Securities Account RLDEPO
INDEX_PRICE Indicator: Security Price Including Price Index Value CHAR1
FLOWUUID Transaction Flow UUID UUID
FLAGBYTE1 Indicator for Financial Transaction Flow (See Documentation)
CONTRACT_PRICE Commodity Price FTR_COMPRICE
SPOT_PRICE Commodity Spot Price FTR_COMPRICE
CONTANGO_BACKWRD Commodity Contango / Backwardation FTR_COMPRICE
BPRC_SPOT1 Current Spot Rate in Percentage VVPKTKUR
BPRC_SPOT2 Spot Rate at Maturity in Percentage VVPKTKUR
COST_FWD Forward Rate Cost VVPKTKUR
INTEREST_FWD Forward Rate Interest DECV9_6
REF_FLOWUUID Flow Reference (UUID) UUID
RGATT Class T_RGATT
COMMODITY_ID Commodity ID (obsolete) TPM_CTY_ID
QUOTATION_NAME Quotation Name CPE_QUOTNAME
SPREAD Commodity Spread FTR_COMPRICE
DIV_PCTC_OTC Percentage of Dividend agreed for Payment in OTC Instruments T_DIV_PCTC_OTC
DCSID Derivative Contract Specification ID TBA_DCSID
MIC Market Identifier Code TBA_MIC
PRICE_TYPE Type of Price Quotation VVSKURSART
TIME_TO_MATURITY Time to Maturity TBA_TENOR
EXCH_RATE_TYPE Exchange Rate Type KURST
PRICE_PAYM_CURR Commodity Price in Payment Currency FTR_COMPRICE
SPREAD_PAYM_CURR Commodity Spread in Payment Currency FTR_COMPRICE
MNDID Unique Reference to Mandate for each Payee ID035
LOGIC_RKOND Condition Group T_KOND
RKONDREF Condition T_KOND
PRESENT_ID Presentation Item FTR_PRSNT_ID
SSTOGRD Reason for Reversal SSTOGRD
PRESENT_BANK Presentation Bank BU_PARTNER
ROUNDDECFACTOR Number of Rounding Decimal Places for a Factor TFM_ROUNDDECIMALS
FLOWFACTOR Flow Factor TFM_FACTOR
BASEFACTOR Base Factor TFM_FACTOR
ROUNDDECBASEFACTOR Number of Rounding Decimal Places for a Base Factor TFM_ROUNDDECIMALS
GROUPING_TERM Grouping Term for Derived Flows TB_DERIV_FLOW_GROUPING
SSEQUENCE Processing Sequence of Conditions TFM_SEQUENCE
ROUNDDECRATEFACTOR Number of Rounding Decimal Places for Interest Factor TFM_ROUNDDECIMALS
AAVGDAYS No. of Days for Interest Calc. with Average Interest Rate INT4
PAVGINTEREST Average Interest Rate DECV5_10
PAVGCAP Upper Limit of Average Interest Rate DECV5_10
PAVGFLOOR Lower Limit of Average Interest Rate DECV5_10
PAVGSPREAD Average Interest Rate Spread DECV5_10
ROUNDDECAVGINTEREST Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
AAVGWEIGHT Weighting of Interest Rate INT4
AAVGWEIGHTSUM Cumulative Weighting of Interest Rate INT4
CONV_FACTOR_TRADED_QTY Quantity Conversion Factor of Priced OTC Transaction TBA_QTY_CONV_FACTOR
CONV_FACTOR_PRICED_QTY Quantity Conversion Factor for OTC Transaction TBA_QTY_CONV_FACTOR
IB_SCHEDULE_VERSION Version Number TRBA_VERSION_NUMBER
IDCFM_USHA_PERC Percentage Value DECV3_7
IDCFM_USHA_FORM European Formula Calculation IDCFM_USHA_DOM_FORM
Master Data Relations Join Conditions
Company Code
  • OTC_CONV_FHAPO.MANDT == T001.MANDT
  • OTC_CONV_FHAPO.BUKRS == T001.BUKRS
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • OTC_CONV_FHAPO.LANDL == T005.LAND1
  • OTC_CONV_FHAPO.MANDT == T005.MANDT
State Central Bank Indicator
  • OTC_CONV_FHAPO.MANDT == T015L.MANDT
  • OTC_CONV_FHAPO.LZBKZ == T015L.LZBKZ
Client OTC_CONV_FHAPO.MANDT == T000.MANDT
Currency Unit of the Rate
  • OTC_CONV_FHAPO.MANDT == TZUNI.MANDT
  • OTC_CONV_FHAPO.PRICE_CURR_UNIT == TZUNI.SRUNIT
Quotation Source
Commodity Quotation Type
Short Key for Own House Bank
  • Short Key for Own House Bank
  • Company Code
  • OTC_CONV_FHAPO.MANDT == T012.MANDT
  • OTC_CONV_FHAPO.RAHABKI == T012.HBKID
  • OTC_CONV_FHAPO.BUKRS == T012.BUKRS
Short Key for House Bank Account
  • Company Code
  • Short Key for House Bank Account
  • Client
  • Short Key for Own House Bank
  • OTC_CONV_FHAPO.BUKRS == T012K.BUKRS
  • OTC_CONV_FHAPO.RAHKTID == T012K.HKTID
  • OTC_CONV_FHAPO.MANDT == T012K.MANDT
  • OTC_CONV_FHAPO.RAHABKI == T012K.HBKID
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • OTC_CONV_FHAPO.BUKRS == VTBFHA.BUKRS
  • OTC_CONV_FHAPO.MANDT == VTBFHA.MANDT
  • OTC_CONV_FHAPO.RFHA == VTBFHA.RFHA
Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • Company Code
  • ?
  • Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • OTC_CONV_FHAPO.MANDT == T037S.MANDT
  • OTC_CONV_FHAPO.BUKRS == T037S.BUKRS
  • OTC_CONV_FHAPO.[column in domain "RANTYP"] == T037S.RANTYP
  • OTC_CONV_FHAPO.RREFKONT == T037S.RREFKONT
Procedure for Generating Derived Flows
  • OTC_CONV_FHAPO.MANDT == AT22.MANDT
  • OTC_CONV_FHAPO.SABVERF == AT22.SABVERF
Calculation category for cash flow calculator OTC_CONV_FHAPO.SBERFIMA == AT40.SBERFIMA
Category of Flows and Conditions
  • Classification of Flows and Conditions
  • Category of Flows and Conditions
  • OTC_CONV_FHAPO.SBKKLAS == AT07.SBKKLAS
  • OTC_CONV_FHAPO.SBKTYP == AT07.SBKTYP
Referenced Flow Type
  • Referenced Flow Type
  • Client
  • ?
  • OTC_CONV_FHAPO.SBWGARTREF == TZB0A.SBEWART
  • OTC_CONV_FHAPO.MANDT == TZB0A.MANDT
  • OTC_CONV_FHAPO.[column in domain "RANTYP"] == TZB0A.RANTYP
Flow Type
  • Flow Type
  • Client
  • Contract Type
  • OTC_CONV_FHAPO.SFHAZBA == TZB0A.SBEWART
  • OTC_CONV_FHAPO.MANDT == TZB0A.MANDT
  • OTC_CONV_FHAPO.RANTYP == TZB0A.RANTYP
Condition Type (Smallest Subdivision of Condition Records)
  • Condition Type (Smallest Subdivision of Condition Records)
  • Contract Type
  • OTC_CONV_FHAPO.MANDT == TZK01.MANDT
  • OTC_CONV_FHAPO.SKOART == TZK01.SKOART
  • OTC_CONV_FHAPO.RANTYP == TZK01.RANTYP
Rate/Price Type - Treasury Instruments
  • OTC_CONV_FHAPO.MANDT == TW56.MANDT
  • OTC_CONV_FHAPO.SKURSART == TW56.SKURSART
Currency Unit of the Rate
  • OTC_CONV_FHAPO.MANDT == TZUNI.MANDT
  • OTC_CONV_FHAPO.SRUNIT == TZUNI.SRUNIT
Type of Manual Reversal of Flows Posted in FI
  • Type of Manual Reversal of Flows Posted in FI
  • Client
  • OTC_CONV_FHAPO.SSTORNOART == AT90.SSTORNOART
  • OTC_CONV_FHAPO.MANDT == AT90.MANDT
Payment method supplement
  • OTC_CONV_FHAPO.MANDT == T042F.MANDT
  • OTC_CONV_FHAPO.UZAWE == T042F.UZAWE
Currency of Calculation Basis
  • OTC_CONV_FHAPO.MANDT == TCURC.MANDT
  • OTC_CONV_FHAPO.WBASIS == TCURC.WAERS
Price Currency
  • OTC_CONV_FHAPO.MANDT == TCURC.MANDT
  • OTC_CONV_FHAPO.WPRICE == TCURC.WAERS
Payment Currency
  • OTC_CONV_FHAPO.MANDT == TCURC.MANDT
  • OTC_CONV_FHAPO.WZBETR == TCURC.WAERS
Payment Method
  • Payment Method
  • ?
  • OTC_CONV_FHAPO.MANDT == T042Z.MANDT
  • OTC_CONV_FHAPO.ZLSCH == T042Z.ZLSCH
  • OTC_CONV_FHAPO.[column in domain "LAND1"] == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Exchange
  • Exchange
  • Client
  • OTC_CONV_FHAPO.RHANDPL == TWH01.RHANDPL
  • OTC_CONV_FHAPO.MANDT == TWH01.MANDT