VTIFHA

Transparent Table Application Table
45 Fields 4 CDS Views

Underlying transaction

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FinTransUndrlgTransaction view from BASIC Fin Trans Underlying Transaction
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 (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