VTIFHAZU

Transparent Table Application Table
42 Fields 4 CDS Views

Underlying transaction status table

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FinTransUnderlyingActivity view from BASIC Fin Trans Underlying Activity
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 (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rfha TB_RFHA Transaction
KEY rfhazu TB_RFHAZU Activity
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
sgsart VVSART Product Type
sfhaart TB_SFHAART Transactn Type
sfgzustt TB_SFGZUTY Activity Cat.
sfunktv TB_SFUNKTV Transit.Funct.
sfunktl TB_SFUNKTL Last Function
rofhazu TB_ROFHAZU Activity
rfhazux TB_RFHAZUX Suppl.activity
saktiv TB_SAKTIV Active Status
sstogrd SSTOGRD Reversal Reason
rdealer RDEALER Trader
dvtrab TB_DVTRAB Contract Date
tvtrab TB_TVTRAB ContrConcTime
gsppart TB_GSPPART Contact Person
xakt XAKT File Number
nordext NORDEXT ExtOrderNo
dblfz TB_DBLFZ Term Start
delfz TB_DELFZ Term End
dfix TB_DFIX Fixing Date
sincle TB_SINCLE Term End Incl.
dzstnd TB_DZSTND Activ. transitn
sznspro TB_SZNSPRO Int./Rollover
dznsstd TB_DZNSSTD Def.int.pmnt.dt
kkurs TB_KKURS Rate
kkassa TB_KKASSA Spot Rate
kswap TB_KSWAP Swap Rate
wlwaers TB_WLWAERS Lead. Currency
wfwaers TB_WFWAERS Following Crcy
limitart TB_LIMITAR Limit Type
limitdat TB_LIMITDA Limit Date
rkondgr TB_RKONDGR Direction
liwaers TB_LIWAERS Reference Crcy
kwliqui TX_KWLIQ Liquidity Eff.
forward_date FTR_FWDDATE Fwd Date

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 status table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIFHAZU (
    MANDT,         -- Client [MANDT]
    RFHA,          -- Transaction [TB_RFHA]
    RFHAZU,        -- Activity [TB_RFHAZU]
    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]
    SGSART,        -- Product Type [VVSART]
    SFHAART,       -- Transactn Type [TB_SFHAART]
    SFGZUSTT,      -- Activity Cat. [TB_SFGZUTY]
    SFUNKTV,       -- Transit.Funct. [TB_SFUNKTV]
    SFUNKTL,       -- Last Function [TB_SFUNKTL]
    ROFHAZU,       -- Activity [TB_ROFHAZU]
    RFHAZUX,       -- Suppl.activity [TB_RFHAZUX]
    SAKTIV,        -- Active Status [TB_SAKTIV]
    SSTOGRD,       -- Reversal Reason [SSTOGRD]
    RDEALER,       -- Trader [RDEALER]
    DVTRAB,        -- Contract Date [TB_DVTRAB]
    TVTRAB,        -- ContrConcTime [TB_TVTRAB]
    GSPPART,       -- Contact Person [TB_GSPPART]
    XAKT,          -- File Number [XAKT]
    NORDEXT,       -- ExtOrderNo [NORDEXT]
    DBLFZ,         -- Term Start [TB_DBLFZ]
    DELFZ,         -- Term End [TB_DELFZ]
    DFIX,          -- Fixing Date [TB_DFIX]
    SINCLE,        -- Term End Incl. [TB_SINCLE]
    DZSTND,        -- Activ. transitn [TB_DZSTND]
    SZNSPRO,       -- Int./Rollover [TB_SZNSPRO]
    DZNSSTD,       -- Def.int.pmnt.dt [TB_DZNSSTD]
    KKURS,         -- Rate [TB_KKURS]
    KKASSA,        -- Spot Rate [TB_KKASSA]
    KSWAP,         -- Swap Rate [TB_KSWAP]
    WLWAERS,       -- Lead. Currency [TB_WLWAERS]
    WFWAERS,       -- Following Crcy [TB_WFWAERS]
    LIMITART,      -- Limit Type [TB_LIMITAR]
    LIMITDAT,      -- Limit Date [TB_LIMITDA]
    RKONDGR,       -- Direction [TB_RKONDGR]
    LIWAERS,       -- Reference Crcy [TB_LIWAERS]
    KWLIQUI,       -- Liquidity Eff. [TX_KWLIQ]
    FORWARD_DATE,  -- Fwd Date [FTR_FWDDATE]
    PRIMARY KEY (MANDT, RFHA, RFHAZU)
);

Learn More