VTIFHAPO

Transparent Table Application Table
139 Fields 4 CDS Views

Underlying transaction flows

VTIFHAPO is an SAP database table in S/4HANA. Underlying transaction flows. It contains 139 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FinTransUnderlyingFlow view from BASIC Fin Transaction Underlying Flow
P_FXTransactionNominal view inner BASIC
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

Fields (139)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
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.
sbewebe tb_sbewebe Posting Status
ssprgrd tb_ssprgrd Blocking Reason
sbfrei tb_sbfrei Posting Release
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
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
sbwgartref tb_sbwgref Ref. Flow Type
skhwfix tb_skhwfix Translation->LC
zuonr dzuonr Assignment
bpprc tb_bpprc_l Price (%)
buprc tb_buprc_l Price(UnitQuot)
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
dbestand tb_dbestand Position Value Date
sbasis sbasis Calculat. Base
regi_state tb_ira_registration_state Status
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
bdirty tb_bdirty Dirty Price
bamountcomp tb_amountcomp Cap. Amnt
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
commodity_id trco_comm_id Cmdty ID (obsolete)
price_curr_unit tb_runit Currency Unit
price_uom tpm_cty_uom Unit of Measure
dcsid tba_dcsid DCS ID
mic tba_mic MIC
bugrenz tfmbugrenz Lower Limit
bogrenz tfmbogrenz Upper Limit
sstaff tfmsstaff Scaled Calc.
logic_rkond ftr_cond_grp Condition Group
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.
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
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

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.

-- Underlying transaction flows
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIFHAPO (
    MANDT,                -- Client [mandt]
    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]
    SBEWEBE,              -- Posting Status [tb_sbewebe]
    SSPRGRD,              -- Blocking Reason [tb_ssprgrd]
    SBFREI,               -- Posting Release [tb_sbfrei]
    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]
    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]
    SBWGARTREF,           -- Ref. Flow Type [tb_sbwgref]
    SKHWFIX,              -- Translation->LC [tb_skhwfix]
    ZUONR,                -- Assignment [dzuonr]
    BPPRC,                -- Price (%) [tb_bpprc_l]
    BUPRC,                -- Price(UnitQuot) [tb_buprc_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]
    DBESTAND,             -- Position Value Date [tb_dbestand]
    SBASIS,               -- Calculat. Base [sbasis]
    REGI_STATE,           -- Status [tb_ira_registration_state]
    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]
    BDIRTY,               -- Dirty Price [tb_bdirty]
    BAMOUNTCOMP,          -- Cap. Amnt [tb_amountcomp]
    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]
    COMMODITY_ID,         -- Cmdty ID (obsolete) [trco_comm_id]
    PRICE_CURR_UNIT,      -- Currency Unit [tb_runit]
    PRICE_UOM,            -- Unit of Measure [tpm_cty_uom]
    DCSID,                -- DCS ID [tba_dcsid]
    MIC,                  -- MIC [tba_mic]
    BUGRENZ,              -- Lower Limit [tfmbugrenz]
    BOGRENZ,              -- Upper Limit [tfmbogrenz]
    SSTAFF,               -- Scaled Calc. [tfmsstaff]
    LOGIC_RKOND,          -- Condition Group [ftr_cond_grp]
    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]
    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]
    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]
    PRIMARY KEY (MANDT, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB)
);

Learn More