VTBFHAPO

Transparent Table Application Table

Transaction Flow

VTBFHAPO is an SAP database table in S/4HANA. Transaction Flow. It contains 241 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_BrkrRecnclnTransFlowActivity view from BASIC Financial Transaction Flow
I_CmmdtyFinTransactionFlow view from BASIC Commodity Financial Transaction Flows
I_CmmdtyHdgTrdOrdTransFlowDet view from BASIC Commodity Hedge Constellation Deal Flow Details
I_CmmdtyHedgeTransactionFlow view from BASIC Financial Transaction flow details
P_CmmdtyHedgeTransFlowDetails view from BASIC Commodity Hedge Constellation Designated
P_FXTransactionNominal view inner BASIC
R_FinTransFlow view from BASIC Financial Transaction Flow
R_FinTransSecurityPaytFlow view from BASIC Fin Trans Security Payment Flow
R_FinTransSecurityQuantityFlow view from BASIC Fin Trans Security Quantity Flow
TOE_CDS_TRM_DEALS view inner cds view for deal nominals in TOENE
toe_cds_trm_deals_rfc view_entity inner View for Deal Nominals with RiskFreeCurr
toe_cds_trm_exp_deals view_entity inner Deal Selection for OTC Exposures
toe_cds_trm_exp_deals_rfc view_entity inner OTC Exposures with Risk-Free Currency

Fields (241)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY rfha TB_RFHA Transaction
KEY rfhazu TB_RFHAZU Activity
KEY dcrdat TB_CRDAT Entry Date
KEY tcrtim TB_TCRTIM Entry Time
KEY rfhazb TB_RFHAZB Flow
cruser TB_CRUSER Entered By
upuser TB_UPUSER Changed By
dupdat TB_DUPDAT Changed On
tuptim TB_TUPTIM Time Changed
rantyp RANTYP Contract Type
sfhazba TB_SFHAZBA Flow Type
sbkklas TB_SBKKLAS Classification
sbktyp TB_SBKTYP Category
sberfima SBEWFIMA Calc. Category
ssign TB_SSIGN Direction
sherkunft TB_SHERK Source
sabverf TB_SABVERF Deriv.Procedure
rkondgr TB_RKONDGR Direction
rkond TB_KOND Condition
dguel_kp DGUEL_KP Item Eff. From
nstufe NSTUFE Level Number
skoart SKOART Condition Type
rrefkont RREFKONT_OBSOLETE Acct Assign.Ref
sbzvabw TB_SBZVABW Alt.Pay.Details
rahabki TB_RHABKI House Bank
rahktid TB_RHKTID House Bank Acct
rpzahl TB_RPZAHL_NEW Payer/Payee
rpbank TB_RPBANK Partner Bank
szart TB_SZART Pmnt Transact.
zlsch DZLSCH Pymt Meth.
uzawe UZAWE Pmnt Meth. Sup.
spayrq TB_SPAYRQK Payment Request
sprsng TB_SPRSNGK Individual Pmnt
sprgrd TB_SPRGRD Group Determ.
scspay TB_SCSPAY Same Direction
zwels DZWELS Payment Methods
paygr PAYGR Grouping
sbewebe TB_SBEWEBE Posting Status
ssprgrd TB_SSPRGRD Blocking Reason
sbfrei TB_SBFREI Posting Release
sstornobwg TB_SBWGSTO Flow Reversal
prkey PRQ_KEYNO Key Number
belnr BELNR_D Document Number
belnr2 TB_BELNR2 JE No. 2
gjahr GJAHR Fiscal Year
dbuchung BUDAT Posting Date
dfaell TB_DFAELL Due Date
dzterm TB_DZTERM Payment Date
bzbetr TB_BZBETR Payment Amnt in PyC
wzbetr TB_WZBETR Payment Currency
bhwbetr TB_HWBETR Pmnt Amnt in LCurr
khwkurs TB_KHWKURS Local Crcy Rate
astueck TB_ASTUECK_L Number of Units
bprice TB_BPRICE Price per Unit
wprice TB_WPRICE Price Currency
bhwpreis TB_HWPREIS Loc.Curr.Price
bindex TB_BINDEX Point Value
vvbasis TB_VVBASIS Price Points
pwkurs TB_PWKURS PercentagePrice
prkkurs TI_PRKUR Price in Points
bnwhr TB_BNWHR Nominal Amnt
rhandpl VVRHANDPL Exchange
skursart TI_KURSART Rate/Price Type
dbervon DBERVON CalculationFrom
dberbis DBERBIS Calculation To
atage VVATAGE Number of Days
abastage ABASTAGE No. base days
pkond PKOND Percentage Rate
dpkond VVDPKOND Perc Fixing Dte
dzfest TB_DZFEST Int.Fixing Date
szbmeth SZBMETH Int.calc.method
skalidwt TFMSKALIDWT Int. Calendar
bbasis BBASIS Base Amount
wbasis TB_WBASIS Calc.Basis Crcy
jexpozins TFM_SINTCOMP Exponential
sincl VVSINCL Inclusive Ind.
sinclbis VVSINCLBIS Incl. End Date
sultbis VVSULTBIS Month-End EndDt
sexclvon VVSEXCLVON Exclusive Start
sultvon VVSULTVON Mth-End StartDt
saend TFM_SAEND Change ID
dvalut DVALUT Calculat. date
svincl VVSVINCL Inclusive_valDt
svult VVSVULT Mon-End Val.Dte
jsofverr TFMSOFVERR Immed.Settlemnt
dverrech VVDVERRECH Settlem. date
sinclverr VVSINCLVER Incl. Clrg Date
sultverr VVSULTVERR MnthEndClearing
sstornoman TB_SBWGSTM Manual Reversal
sstornoart TB_SSTOART Reversal Type
sbwgartref TB_SBWGREF Ref. Flow Type
skhwfix TB_SKHWFIX Translation->LC
zuonr DZUONR Assignment
rldepo RLDEPO Securities Acct
ranl VVRANLW Security Class
rtrbelnr TPM_DEDOC_RDOCNRINT InternalDoc.No.
buprc TB_BUPRC_L Price(UnitQuot)
bpprc TB_BPPRC_L Price (%)
wbbetr TB_WBBETR Position Crcy
bbbetr TB_BBBETR Amt in Pos.Crcy
webetr TB_WEBETR Price Currency
bebetr TB_BEBETR Mkt Val. in QC
srunit TB_RUNIT Currency Unit
kzwkurs TB_KZWKURS PC Rate
kbwkurs TB_KBWKURS PositionCurrRte
wsbetr TB_WFROM Source Currency
dbestand TB_DBESTAND Position Value Date
sstckkz SSTCKKZ Acc.int.meth.
sstcktg SSTCKTG Daily Method
sflat VVSFLAT Traded flat
scoupon VVSCOUPON Coupon
dcoupon VVDCOUPON Coupon date
awkey AWKEY Reference Key
index_value TIDX_INDEX_VALUE_NO_RATIO Value W/o Basis
sbasis SBASIS Calculat. Base
regi_state TB_IRA_REGISTRATION_STATE Status
rpcode RPCODE Repetitive Code
rp_text RPCODE_TEXT Reference Text
hedge_id TPM_HEDGE_ID Hedge ID
dbperiod VVDBPERIOD Period start
spaexcl TFMSPAEXCL Exclusive Start
spault TFMSPAULT MonEndIndStPer
deperiod VVDEPERIOD Period end
speincl TFMSPEINCL InclusiveEndPer
speult TFMSPEULT MthEndPerEnd
ammrhy AMMRHY Freq. in months
ppayment TFM_PPAYMENT Payment Rate
ammrhyzv TFM_AMMRHYZV Int.Sttlm.Freq
lzbkz LZBKZ SCB Ind.
landl LANDL Supply C/R
bdirty TB_BDIRTY Dirty Price
bamountcomp TB_AMOUNTCOMP Cap. Amnt
nominal_org_amt TB_BNWHR_ORG Orig. Nominal Amount
nom_factor RDPT_FACTOR_VAL Factor
rldepo2 VRLDEPO Securities Acct
index_price TB_INDEX_PRICE Price incl. Index
flowuuid TB_FLOWUUID Flow UUID
flagbyte1 TB_FLAGBYTE1 Flag Byte 1
quantity FTR_QUAN Qty
unit_of_measure TPM_CTY_UOM Unit of Measure
contract_price FTR_COMPRICE Price
spot_price FTR_COMSPOT SpotPrice
contango_backwrd FTR_CONBACK Comm Contg
bprc_spot1 TB_BPPRC_SPOT1_L Spot 1
bprc_spot2 TB_BPPRC_SPOT_MAT_L SpotRate at Mat
cost_fwd TB_COSTFWD Cost
interest_fwd TB_INTERESTFWD Interest
ref_flowuuid TB_REFFLOWUUID Reference UUID
rgatt TI_RGATT Class
commodity_id TRCO_COMM_ID Cmdty ID (obsolete)
quotation_name CPET_QUOTNAME Quotation Name
quotation_source TCR_CTY_QUOTSRC Quot Source
quotation_type TCR_CTY_QUOTTYPE Quotation Type
spread FTR_COMSPREAD Spread
price_curr_unit TB_RUNIT Currency Unit
price_uom TPM_CTY_UOM Unit of Measure
div_pctc_otc TB_DIV_PCTC_OTC Div. Percentage
tainted TB_TAINTED_CASHFLOW Manipulated CF
cleared FTR_FLOW_CLEARED Cleared
dcsid TBA_DCSID DCS ID
mic TBA_MIC MIC
price_type TBA_PRICETYPE Price Type
time_to_maturity TBA_TENOR Time to Maturity
timing TBA_TIMING Timing
exch_rate_type KURST_CURR Exch. Rate Type
price_paym_curr FTR_COMPRICE_PAYMENT_CURR Price Paymt Crcy
spread_paym_curr FTR_COMSPREAD_PAYMENT_CURR Spread in PymtC
fx_translation FTR_CURRENCY_CONV_POINT_IN_TIM FX Translation
mndid SEPA_MNDID Mandate Ref.
bugrenz TFMBUGRENZ Lower Limit
bogrenz TFMBOGRENZ Upper Limit
sstaff TFMSSTAFF Scaled Calc.
logic_rkond FTR_COND_GRP Condition Group
rkondref TB_KOND Condition
dguel_kpref DGUEL_KP Item Eff. From
present_date FTR_PRE_DATE Presentatn Date
interest_paid_by FTR_INTEREST_PAY_BY Interest Paid By
shipment_date FTR_SHIP_DATE Shipment Date
status FTR_STATUS Status
present_id FTR_PERSENT_ID Presentatn Itm
sstogrd SSTOGRD Reversal Reason
present_amount FTR_PRESENT_AMT PresentationAmt
present_bank FTR_PRESENT_BANK Pres. Bank
present_discrepancy FTR_DISCREPANCY Discrepancy Amount
present_decrease_amount FTR_PRESENT_DEC_AMT Decreased Amnt
present_rea_cre_line FTR_PRESENT_REA_AMT Released Amount
present_pay_amt TB_BZBETR Payment Amnt in PyC
sroundfactor TFM_SROUNDFACTOR Factor RC
rounddecfactor TFM_ROUNDDECFACTOR Dec. Fac. Round
jexpointfactor TFM_JEXPOINTFACTOR Expo Int Factor
flowfactor TFM_FLOWFACTOR Flow Factor
basefactor TFM_BASEFACTOR Base Factor
sroundbasefactor TFM_SROUNDBASEFACTOR Base Factor RC
rounddecbasefactor TFM_ROUNDDECBASEFACTOR Dec. BF Round.
skbwfix TB_SKBWFIX Translation->PC
grouping_term TB_DERIV_FLOW_GROUPING Grouping Term
ssequence TFM_SEQUENCE Sequence Number
sroundratefactor TFM_SROUNDRATEFACTOR Int. Factor RC
rounddecratefactor TFM_ROUNDDECRATEFACTOR Dec. Int. Fac.
aavgdays TFM_AAVGDAYS Days AIR
pavginterest TFM_PAVGINTEREST Aver. Int. Rate
stgbasis VVSTGBASIS Base Days Meth.
javgcap TFM_JAVGCAP Upper Limit
pavgcap TFM_PAVGCAP Upper Limit
javgfloor TFM_JAVGFLOOR Lower Limit
pavgfloor TFM_PAVGFLOOR Lower Limit
pavgspread TFM_PAVGSPREAD Spread
sroundavginterest TFM_SROUNDAVGINTEREST RC of AIR
rounddecavginterest TFM_ROUNDDECAVGINTEREST AIR Round. Dec.
aavgweight TFM_AWEIGHT Weighting of IR
aavgweightsum TFM_AWEIGHTSUM Cumul. Weight
fx_fixing_date TB_DFIX Fixing Date
fx_regi_state FTR_FIXING_REF_REGI_STATE Fixing Status
fx_read_date FTR_FIXING_REF_READ_DATE Date of FX Rate
priceindex_fix_date_low TFM_INDEX_FIXDATELOW IdxFixDateLow
priceindex_read_date_low FTR_PIDX_READ_DATE_LOW Idx Read Low
priceindex_fix_date_high TFM_INDEX_FIXDATEHIGH IdxFixDateHigh
priceindex_read_date_high FTR_PIDX_READ_DATE_HIGH Idx Read High
priceindex_regi_state FTR_FIXING_REF_REGI_STATE Fixing Status
bbbetr_idxclean TB_BBBETR_IDXCLEAN Amt Index-Clean
payment_reason FARP_PAYT_RSN Payment Reason
payment_reason_changed FTR_PAYMENT_REASON_CHANGED ChangeIndPaymReason
traded_quantity TBA_TRADED_OTC_QUANTITY Traded Quantity
traded_quantity_uom TBA_TRADED_QUANTITY_UOM Unit of Measure
conv_factor_traded_qty TBA_CONV_FACTOR_TRADED_QTY Qty Cnv Fct (Priced)
conv_factor_traded_qty_uom TBA_CONV_FACTOR_TRADED_QTY_UOM Unit of Measure
conv_factor_priced_qty TBA_CONV_FACTOR_PRICED_QTY Qty Cnv Fct
conv_factor_priced_qty_uom TBA_CONV_FACTOR_PRICED_QTY_UOM Unit of Measure
bkond TFM_BKOND Condition amnt
ib_schedule_version TRBA_VERSION_NUMBER Version
nominal_value_per_unit FTR_NOMINAL_VALUE_PER_UNIT Nominal Value
sum_rkond TB_SUM_RKOND Accum. Cond.Grp
sum_id_source TB_SUM_ID_SOURCE Rel.AccumFlowID
sum_id_sum TB_SUM_ID_SUM Accum. Flow ID
idcfm_usha_type IDCFM_USHA_DEL_TYPE Haircut Rate Type
idcfm_usha_perc IDCFM_USHA_DEL_PERC Percentage Value
idcfm_usha_tota IDCFM_USHA_DEL_TOTA Haircut Amount
idcfm_usha_curr IDCFM_USHA_DEL_CURR Haircut Currency
idcfm_usha_form IDCFM_USHA_DEL_FORM European Formula

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Transaction Flow
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBFHAPO (
    MANDT,                       -- Client [MANDT]
    BUKRS,                       -- Company Code [BUKRS]
    RFHA,                        -- Transaction [TB_RFHA]
    RFHAZU,                      -- Activity [TB_RFHAZU]
    DCRDAT,                      -- Entry Date [TB_CRDAT]
    TCRTIM,                      -- Entry Time [TB_TCRTIM]
    RFHAZB,                      -- Flow [TB_RFHAZB]
    CRUSER,                      -- Entered By [TB_CRUSER]
    UPUSER,                      -- Changed By [TB_UPUSER]
    DUPDAT,                      -- Changed On [TB_DUPDAT]
    TUPTIM,                      -- Time Changed [TB_TUPTIM]
    RANTYP,                      -- Contract Type [RANTYP]
    SFHAZBA,                     -- Flow Type [TB_SFHAZBA]
    SBKKLAS,                     -- Classification [TB_SBKKLAS]
    SBKTYP,                      -- Category [TB_SBKTYP]
    SBERFIMA,                    -- Calc. Category [SBEWFIMA]
    SSIGN,                       -- Direction [TB_SSIGN]
    SHERKUNFT,                   -- Source [TB_SHERK]
    SABVERF,                     -- Deriv.Procedure [TB_SABVERF]
    RKONDGR,                     -- Direction [TB_RKONDGR]
    RKOND,                       -- Condition [TB_KOND]
    DGUEL_KP,                    -- Item Eff. From [DGUEL_KP]
    NSTUFE,                      -- Level Number [NSTUFE]
    SKOART,                      -- Condition Type [SKOART]
    RREFKONT,                    -- Acct Assign.Ref [RREFKONT_OBSOLETE]
    SBZVABW,                     -- Alt.Pay.Details [TB_SBZVABW]
    RAHABKI,                     -- House Bank [TB_RHABKI]
    RAHKTID,                     -- House Bank Acct [TB_RHKTID]
    RPZAHL,                      -- Payer/Payee [TB_RPZAHL_NEW]
    RPBANK,                      -- Partner Bank [TB_RPBANK]
    SZART,                       -- Pmnt Transact. [TB_SZART]
    ZLSCH,                       -- Pymt Meth. [DZLSCH]
    UZAWE,                       -- Pmnt Meth. Sup. [UZAWE]
    SPAYRQ,                      -- Payment Request [TB_SPAYRQK]
    SPRSNG,                      -- Individual Pmnt [TB_SPRSNGK]
    SPRGRD,                      -- Group Determ. [TB_SPRGRD]
    SCSPAY,                      -- Same Direction [TB_SCSPAY]
    ZWELS,                       -- Payment Methods [DZWELS]
    PAYGR,                       -- Grouping [PAYGR]
    SBEWEBE,                     -- Posting Status [TB_SBEWEBE]
    SSPRGRD,                     -- Blocking Reason [TB_SSPRGRD]
    SBFREI,                      -- Posting Release [TB_SBFREI]
    SSTORNOBWG,                  -- Flow Reversal [TB_SBWGSTO]
    PRKEY,                       -- Key Number [PRQ_KEYNO]
    BELNR,                       -- Document Number [BELNR_D]
    BELNR2,                      -- JE No. 2 [TB_BELNR2]
    GJAHR,                       -- Fiscal Year [GJAHR]
    DBUCHUNG,                    -- Posting Date [BUDAT]
    DFAELL,                      -- Due Date [TB_DFAELL]
    DZTERM,                      -- Payment Date [TB_DZTERM]
    BZBETR,                      -- Payment Amnt in PyC [TB_BZBETR]
    WZBETR,                      -- Payment Currency [TB_WZBETR]
    BHWBETR,                     -- Pmnt Amnt in LCurr [TB_HWBETR]
    KHWKURS,                     -- Local Crcy Rate [TB_KHWKURS]
    ASTUECK,                     -- Number of Units [TB_ASTUECK_L]
    BPRICE,                      -- Price per Unit [TB_BPRICE]
    WPRICE,                      -- Price Currency [TB_WPRICE]
    BHWPREIS,                    -- Loc.Curr.Price [TB_HWPREIS]
    BINDEX,                      -- Point Value [TB_BINDEX]
    VVBASIS,                     -- Price Points [TB_VVBASIS]
    PWKURS,                      -- PercentagePrice [TB_PWKURS]
    PRKKURS,                     -- Price in Points [TI_PRKUR]
    BNWHR,                       -- Nominal Amnt [TB_BNWHR]
    RHANDPL,                     -- Exchange [VVRHANDPL]
    SKURSART,                    -- Rate/Price Type [TI_KURSART]
    DBERVON,                     -- CalculationFrom [DBERVON]
    DBERBIS,                     -- Calculation To [DBERBIS]
    ATAGE,                       -- Number of Days [VVATAGE]
    ABASTAGE,                    -- No. base days [ABASTAGE]
    PKOND,                       -- Percentage Rate [PKOND]
    DPKOND,                      -- Perc Fixing Dte [VVDPKOND]
    DZFEST,                      -- Int.Fixing Date [TB_DZFEST]
    SZBMETH,                     -- Int.calc.method [SZBMETH]
    SKALIDWT,                    -- Int. Calendar [TFMSKALIDWT]
    BBASIS,                      -- Base Amount [BBASIS]
    WBASIS,                      -- Calc.Basis Crcy [TB_WBASIS]
    JEXPOZINS,                   -- Exponential [TFM_SINTCOMP]
    SINCL,                       -- Inclusive Ind. [VVSINCL]
    SINCLBIS,                    -- Incl. End Date [VVSINCLBIS]
    SULTBIS,                     -- Month-End EndDt [VVSULTBIS]
    SEXCLVON,                    -- Exclusive Start [VVSEXCLVON]
    SULTVON,                     -- Mth-End StartDt [VVSULTVON]
    SAEND,                       -- Change ID [TFM_SAEND]
    DVALUT,                      -- Calculat. date [DVALUT]
    SVINCL,                      -- Inclusive_valDt [VVSVINCL]
    SVULT,                       -- Mon-End Val.Dte [VVSVULT]
    JSOFVERR,                    -- Immed.Settlemnt [TFMSOFVERR]
    DVERRECH,                    -- Settlem. date [VVDVERRECH]
    SINCLVERR,                   -- Incl. Clrg Date [VVSINCLVER]
    SULTVERR,                    -- MnthEndClearing [VVSULTVERR]
    SSTORNOMAN,                  -- Manual Reversal [TB_SBWGSTM]
    SSTORNOART,                  -- Reversal Type [TB_SSTOART]
    SBWGARTREF,                  -- Ref. Flow Type [TB_SBWGREF]
    SKHWFIX,                     -- Translation->LC [TB_SKHWFIX]
    ZUONR,                       -- Assignment [DZUONR]
    RLDEPO,                      -- Securities Acct [RLDEPO]
    RANL,                        -- Security Class [VVRANLW]
    RTRBELNR,                    -- InternalDoc.No. [TPM_DEDOC_RDOCNRINT]
    BUPRC,                       -- Price(UnitQuot) [TB_BUPRC_L]
    BPPRC,                       -- Price (%) [TB_BPPRC_L]
    WBBETR,                      -- Position Crcy [TB_WBBETR]
    BBBETR,                      -- Amt in Pos.Crcy [TB_BBBETR]
    WEBETR,                      -- Price Currency [TB_WEBETR]
    BEBETR,                      -- Mkt Val. in QC [TB_BEBETR]
    SRUNIT,                      -- Currency Unit [TB_RUNIT]
    KZWKURS,                     -- PC Rate [TB_KZWKURS]
    KBWKURS,                     -- PositionCurrRte [TB_KBWKURS]
    WSBETR,                      -- Source Currency [TB_WFROM]
    DBESTAND,                    -- Position Value Date [TB_DBESTAND]
    SSTCKKZ,                     -- Acc.int.meth. [SSTCKKZ]
    SSTCKTG,                     -- Daily Method [SSTCKTG]
    SFLAT,                       -- Traded flat [VVSFLAT]
    SCOUPON,                     -- Coupon [VVSCOUPON]
    DCOUPON,                     -- Coupon date [VVDCOUPON]
    AWKEY,                       -- Reference Key [AWKEY]
    INDEX_VALUE,                 -- Value W/o Basis [TIDX_INDEX_VALUE_NO_RATIO]
    SBASIS,                      -- Calculat. Base [SBASIS]
    REGI_STATE,                  -- Status [TB_IRA_REGISTRATION_STATE]
    RPCODE,                      -- Repetitive Code [RPCODE]
    RP_TEXT,                     -- Reference Text [RPCODE_TEXT]
    HEDGE_ID,                    -- Hedge ID [TPM_HEDGE_ID]
    DBPERIOD,                    -- Period start [VVDBPERIOD]
    SPAEXCL,                     -- Exclusive Start [TFMSPAEXCL]
    SPAULT,                      -- MonEndIndStPer [TFMSPAULT]
    DEPERIOD,                    -- Period end [VVDEPERIOD]
    SPEINCL,                     -- InclusiveEndPer [TFMSPEINCL]
    SPEULT,                      -- MthEndPerEnd [TFMSPEULT]
    AMMRHY,                      -- Freq. in months [AMMRHY]
    PPAYMENT,                    -- Payment Rate [TFM_PPAYMENT]
    AMMRHYZV,                    -- Int.Sttlm.Freq [TFM_AMMRHYZV]
    LZBKZ,                       -- SCB Ind. [LZBKZ]
    LANDL,                       -- Supply C/R [LANDL]
    BDIRTY,                      -- Dirty Price [TB_BDIRTY]
    BAMOUNTCOMP,                 -- Cap. Amnt [TB_AMOUNTCOMP]
    NOMINAL_ORG_AMT,             -- Orig. Nominal Amount [TB_BNWHR_ORG]
    NOM_FACTOR,                  -- Factor [RDPT_FACTOR_VAL]
    RLDEPO2,                     -- Securities Acct [VRLDEPO]
    INDEX_PRICE,                 -- Price incl. Index [TB_INDEX_PRICE]
    FLOWUUID,                    -- Flow UUID [TB_FLOWUUID]
    FLAGBYTE1,                   -- Flag Byte 1 [TB_FLAGBYTE1]
    QUANTITY,                    -- Qty [FTR_QUAN]
    UNIT_OF_MEASURE,             -- Unit of Measure [TPM_CTY_UOM]
    CONTRACT_PRICE,              -- Price [FTR_COMPRICE]
    SPOT_PRICE,                  -- SpotPrice [FTR_COMSPOT]
    CONTANGO_BACKWRD,            -- Comm Contg [FTR_CONBACK]
    BPRC_SPOT1,                  -- Spot 1 [TB_BPPRC_SPOT1_L]
    BPRC_SPOT2,                  -- SpotRate at Mat [TB_BPPRC_SPOT_MAT_L]
    COST_FWD,                    -- Cost [TB_COSTFWD]
    INTEREST_FWD,                -- Interest [TB_INTERESTFWD]
    REF_FLOWUUID,                -- Reference UUID [TB_REFFLOWUUID]
    RGATT,                       -- Class [TI_RGATT]
    COMMODITY_ID,                -- Cmdty ID (obsolete) [TRCO_COMM_ID]
    QUOTATION_NAME,              -- Quotation Name [CPET_QUOTNAME]
    QUOTATION_SOURCE,            -- Quot Source [TCR_CTY_QUOTSRC]
    QUOTATION_TYPE,              -- Quotation Type [TCR_CTY_QUOTTYPE]
    SPREAD,                      -- Spread [FTR_COMSPREAD]
    PRICE_CURR_UNIT,             -- Currency Unit [TB_RUNIT]
    PRICE_UOM,                   -- Unit of Measure [TPM_CTY_UOM]
    DIV_PCTC_OTC,                -- Div. Percentage [TB_DIV_PCTC_OTC]
    TAINTED,                     -- Manipulated CF [TB_TAINTED_CASHFLOW]
    CLEARED,                     -- Cleared [FTR_FLOW_CLEARED]
    DCSID,                       -- DCS ID [TBA_DCSID]
    MIC,                         -- MIC [TBA_MIC]
    PRICE_TYPE,                  -- Price Type [TBA_PRICETYPE]
    TIME_TO_MATURITY,            -- Time to Maturity [TBA_TENOR]
    TIMING,                      -- Timing [TBA_TIMING]
    EXCH_RATE_TYPE,              -- Exch. Rate Type [KURST_CURR]
    PRICE_PAYM_CURR,             -- Price Paymt Crcy [FTR_COMPRICE_PAYMENT_CURR]
    SPREAD_PAYM_CURR,            -- Spread in PymtC [FTR_COMSPREAD_PAYMENT_CURR]
    FX_TRANSLATION,              -- FX Translation [FTR_CURRENCY_CONV_POINT_IN_TIM]
    MNDID,                       -- Mandate Ref. [SEPA_MNDID]
    BUGRENZ,                     -- Lower Limit [TFMBUGRENZ]
    BOGRENZ,                     -- Upper Limit [TFMBOGRENZ]
    SSTAFF,                      -- Scaled Calc. [TFMSSTAFF]
    LOGIC_RKOND,                 -- Condition Group [FTR_COND_GRP]
    RKONDREF,                    -- Condition [TB_KOND]
    DGUEL_KPREF,                 -- Item Eff. From [DGUEL_KP]
    PRESENT_DATE,                -- Presentatn Date [FTR_PRE_DATE]
    INTEREST_PAID_BY,            -- Interest Paid By [FTR_INTEREST_PAY_BY]
    SHIPMENT_DATE,               -- Shipment Date [FTR_SHIP_DATE]
    STATUS,                      -- Status [FTR_STATUS]
    PRESENT_ID,                  -- Presentatn Itm [FTR_PERSENT_ID]
    SSTOGRD,                     -- Reversal Reason [SSTOGRD]
    PRESENT_AMOUNT,              -- PresentationAmt [FTR_PRESENT_AMT]
    PRESENT_BANK,                -- Pres. Bank [FTR_PRESENT_BANK]
    PRESENT_DISCREPANCY,         -- Discrepancy Amount [FTR_DISCREPANCY]
    PRESENT_DECREASE_AMOUNT,     -- Decreased Amnt [FTR_PRESENT_DEC_AMT]
    PRESENT_REA_CRE_LINE,        -- Released Amount [FTR_PRESENT_REA_AMT]
    PRESENT_PAY_AMT,             -- Payment Amnt in PyC [TB_BZBETR]
    SROUNDFACTOR,                -- Factor RC [TFM_SROUNDFACTOR]
    ROUNDDECFACTOR,              -- Dec. Fac. Round [TFM_ROUNDDECFACTOR]
    JEXPOINTFACTOR,              -- Expo Int Factor [TFM_JEXPOINTFACTOR]
    FLOWFACTOR,                  -- Flow Factor [TFM_FLOWFACTOR]
    BASEFACTOR,                  -- Base Factor [TFM_BASEFACTOR]
    SROUNDBASEFACTOR,            -- Base Factor RC [TFM_SROUNDBASEFACTOR]
    ROUNDDECBASEFACTOR,          -- Dec. BF Round. [TFM_ROUNDDECBASEFACTOR]
    SKBWFIX,                     -- Translation->PC [TB_SKBWFIX]
    GROUPING_TERM,               -- Grouping Term [TB_DERIV_FLOW_GROUPING]
    SSEQUENCE,                   -- Sequence Number [TFM_SEQUENCE]
    SROUNDRATEFACTOR,            -- Int. Factor RC [TFM_SROUNDRATEFACTOR]
    ROUNDDECRATEFACTOR,          -- Dec. Int. Fac. [TFM_ROUNDDECRATEFACTOR]
    AAVGDAYS,                    -- Days AIR [TFM_AAVGDAYS]
    PAVGINTEREST,                -- Aver. Int. Rate [TFM_PAVGINTEREST]
    STGBASIS,                    -- Base Days Meth. [VVSTGBASIS]
    JAVGCAP,                     -- Upper Limit [TFM_JAVGCAP]
    PAVGCAP,                     -- Upper Limit [TFM_PAVGCAP]
    JAVGFLOOR,                   -- Lower Limit [TFM_JAVGFLOOR]
    PAVGFLOOR,                   -- Lower Limit [TFM_PAVGFLOOR]
    PAVGSPREAD,                  -- Spread [TFM_PAVGSPREAD]
    SROUNDAVGINTEREST,           -- RC of AIR [TFM_SROUNDAVGINTEREST]
    ROUNDDECAVGINTEREST,         -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
    AAVGWEIGHT,                  -- Weighting of IR [TFM_AWEIGHT]
    AAVGWEIGHTSUM,               -- Cumul. Weight [TFM_AWEIGHTSUM]
    FX_FIXING_DATE,              -- Fixing Date [TB_DFIX]
    FX_REGI_STATE,               -- Fixing Status [FTR_FIXING_REF_REGI_STATE]
    FX_READ_DATE,                -- Date of FX Rate [FTR_FIXING_REF_READ_DATE]
    PRICEINDEX_FIX_DATE_LOW,     -- IdxFixDateLow [TFM_INDEX_FIXDATELOW]
    PRICEINDEX_READ_DATE_LOW,    -- Idx Read Low [FTR_PIDX_READ_DATE_LOW]
    PRICEINDEX_FIX_DATE_HIGH,    -- IdxFixDateHigh [TFM_INDEX_FIXDATEHIGH]
    PRICEINDEX_READ_DATE_HIGH,   -- Idx Read High [FTR_PIDX_READ_DATE_HIGH]
    PRICEINDEX_REGI_STATE,       -- Fixing Status [FTR_FIXING_REF_REGI_STATE]
    BBBETR_IDXCLEAN,             -- Amt Index-Clean [TB_BBBETR_IDXCLEAN]
    PAYMENT_REASON,              -- Payment Reason [FARP_PAYT_RSN]
    PAYMENT_REASON_CHANGED,      -- ChangeIndPaymReason [FTR_PAYMENT_REASON_CHANGED]
    TRADED_QUANTITY,             -- Traded Quantity [TBA_TRADED_OTC_QUANTITY]
    TRADED_QUANTITY_UOM,         -- Unit of Measure [TBA_TRADED_QUANTITY_UOM]
    CONV_FACTOR_TRADED_QTY,      -- Qty Cnv Fct (Priced) [TBA_CONV_FACTOR_TRADED_QTY]
    CONV_FACTOR_TRADED_QTY_UOM,  -- Unit of Measure [TBA_CONV_FACTOR_TRADED_QTY_UOM]
    CONV_FACTOR_PRICED_QTY,      -- Qty Cnv Fct [TBA_CONV_FACTOR_PRICED_QTY]
    CONV_FACTOR_PRICED_QTY_UOM,  -- Unit of Measure [TBA_CONV_FACTOR_PRICED_QTY_UOM]
    BKOND,                       -- Condition amnt [TFM_BKOND]
    IB_SCHEDULE_VERSION,         -- Version [TRBA_VERSION_NUMBER]
    NOMINAL_VALUE_PER_UNIT,      -- Nominal Value [FTR_NOMINAL_VALUE_PER_UNIT]
    SUM_RKOND,                   -- Accum. Cond.Grp [TB_SUM_RKOND]
    SUM_ID_SOURCE,               -- Rel.AccumFlowID [TB_SUM_ID_SOURCE]
    SUM_ID_SUM,                  -- Accum. Flow ID [TB_SUM_ID_SUM]
    IDCFM_USHA_TYPE,             -- Haircut Rate Type [IDCFM_USHA_DEL_TYPE]
    IDCFM_USHA_PERC,             -- Percentage Value [IDCFM_USHA_DEL_PERC]
    IDCFM_USHA_TOTA,             -- Haircut Amount [IDCFM_USHA_DEL_TOTA]
    IDCFM_USHA_CURR,             -- Haircut Currency [IDCFM_USHA_DEL_CURR]
    IDCFM_USHA_FORM,             -- European Formula [IDCFM_USHA_DEL_FORM]
    PRIMARY KEY (MANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB)
);