VTIFHA

Transparent Table Application Table
45 Fields 3 CDS Views

Underlying transaction

VTIFHA is an SAP database table in S/4HANA. Underlying transaction. It contains 45 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FinTransUndrlgTransaction view from BASIC Fin Trans Underlying Transaction
P_FXTransactionNominal view inner BASIC Nominal of a FX Transaction
TOE_CDS_TRM_DEALS view_entity inner cds view for deal nominals in TOENE

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rfha tb_rfha Transaction
cruser tb_cruser Entered By
dcrdat tb_dcrdat Entry Date
tcrtim tb_tcrtim Entry Time
upuser tb_upuser Changed By
dupdat tb_dupdat Changed On
tuptim tb_tuptim Time Changed
rantyp rantyp Contract Type
sanlf sanlf Prod. Category
sfgtyp tb_sfgtyp Transaction Cat
sgsart vvsart Product Type
sfhaart tb_sfhaart Transactn Type
rgatt ti_rgatt Class
rfhazunr tb_rfhazun Activity Number
rfhazul tb_rfhazul Active activity
saktiv tb_saktiv Active Status
kontrh tb_kunnr_new Partner
srolext dummy_3 Dummy
rrefkont rrefkont_obsolete Acct Assign.Ref
rrefkont2 rrefkont_obsolete Acct Assign.Ref
rportb rportb Portfolio
wgschft tb_wgschft Trans. Crcy
wgschft1 tb_wgschf1 Outg. Currency
wgschft2 tb_wgschf2 Incoming Curr.
amtinput tb_amtin Traded Indic.
dblfz tb_dblfz Term Start
skalid skalid Calendar
skalid2 skalid Calendar
jlimit tb_jlimit Limit Indicator
akuend tb_akuend Notice Period
skuend tb_skuend Unit
objnr j_objnr Object number
bukrs bukrs Company Code
rldepo rldepo Securities Acct
zuonr tb_tfproj Finance Project
delfz delfz End of Term
abwtyp tb_abwtyp Processing Cat.
vrfha tb_vorfha Ref. Transac.
ranl vvranlw Security Class
sinclbe tb_sinclbe End Inclusive
rcomvalcl tpm_com_val_class Gen. Valn Class
rolloverfl ti_rolloverfl Roll Over
commodity_id trco_comm_id Cmdty ID (obsolete)
fima_calculation tb_fima_calculation CF Calculation

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIFHA (
    MANDT,             -- Client [mandt]
    RFHA,              -- Transaction [tb_rfha]
    CRUSER,            -- Entered By [tb_cruser]
    DCRDAT,            -- Entry Date [tb_dcrdat]
    TCRTIM,            -- Entry Time [tb_tcrtim]
    UPUSER,            -- Changed By [tb_upuser]
    DUPDAT,            -- Changed On [tb_dupdat]
    TUPTIM,            -- Time Changed [tb_tuptim]
    RANTYP,            -- Contract Type [rantyp]
    SANLF,             -- Prod. Category [sanlf]
    SFGTYP,            -- Transaction Cat [tb_sfgtyp]
    SGSART,            -- Product Type [vvsart]
    SFHAART,           -- Transactn Type [tb_sfhaart]
    RGATT,             -- Class [ti_rgatt]
    RFHAZUNR,          -- Activity Number [tb_rfhazun]
    RFHAZUL,           -- Active activity [tb_rfhazul]
    SAKTIV,            -- Active Status [tb_saktiv]
    KONTRH,            -- Partner [tb_kunnr_new]
    SROLEXT,           -- Dummy [dummy_3]
    RREFKONT,          -- Acct Assign.Ref [rrefkont_obsolete]
    RREFKONT2,         -- Acct Assign.Ref [rrefkont_obsolete]
    RPORTB,            -- Portfolio [rportb]
    WGSCHFT,           -- Trans. Crcy [tb_wgschft]
    WGSCHFT1,          -- Outg. Currency [tb_wgschf1]
    WGSCHFT2,          -- Incoming Curr. [tb_wgschf2]
    AMTINPUT,          -- Traded Indic. [tb_amtin]
    DBLFZ,             -- Term Start [tb_dblfz]
    SKALID,            -- Calendar [skalid]
    SKALID2,           -- Calendar [skalid]
    JLIMIT,            -- Limit Indicator [tb_jlimit]
    AKUEND,            -- Notice Period [tb_akuend]
    SKUEND,            -- Unit [tb_skuend]
    OBJNR,             -- Object number [j_objnr]
    BUKRS,             -- Company Code [bukrs]
    RLDEPO,            -- Securities Acct [rldepo]
    ZUONR,             -- Finance Project [tb_tfproj]
    DELFZ,             -- End of Term [delfz]
    ABWTYP,            -- Processing Cat. [tb_abwtyp]
    VRFHA,             -- Ref. Transac. [tb_vorfha]
    RANL,              -- Security Class [vvranlw]
    SINCLBE,           -- End Inclusive [tb_sinclbe]
    RCOMVALCL,         -- Gen. Valn Class [tpm_com_val_class]
    ROLLOVERFL,        -- Roll Over [ti_rolloverfl]
    COMMODITY_ID,      -- Cmdty ID (obsolete) [trco_comm_id]
    FIMA_CALCULATION,  -- CF Calculation [tb_fima_calculation]
    PRIMARY KEY (MANDT, RFHA)
);

Learn More