VTBFHAZU

Transparent Table Application Table
76 Fields 13 CDS Views

Transaction Activity

VTBFHAZU is an SAP database table in S/4HANA. Transaction Activity. It contains 76 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTransActyHistory view from BASIC Transaction Flow
I_FinTransActivity view from BASIC Financial Transaction Activity
P_FinTransactionActivity view from COMPOSITE
P_FINTRANSINTCOND view left_outer COMPOSITE
P_FXTransactionNominal view inner BASIC
P_IRM_Financial_Transaction view inner BASIC
P_TFTRANSCASHFLOW view left_outer COMPOSITE
P_TFTRANSFEECOND view left_outer COMPOSITE
R_FinTransActiveActivity view inner BASIC Fin Trans Active Activity
R_FinTransCashFlowActivity view left_outer BASIC Financial Transaction Cash Flow Activity
R_FinTransContractActivity view from BASIC Financial Transaction Contract Activity
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 (76)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
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 tb_nordext External Ref.
dblfz tb_dblfz Term Start
delfz tb_delfz Term End
dfix tb_dfix Fixing Date
fixing_ref_id ftr_fixing_ref_id Fixing Ref. ID
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.
sconfirm tb_conf Confirmation
dexdat tb_dconf Confirm. Date
uexnam tb_uconf User
sreconfirm tb_reconf Counterconfirm.
dredat tb_dredat Counterc. Date
urenam tb_urenam User
dorder tb_dorder Order Date
danst tb_danst Reserv. Date
tanst tb_tanst Order Time
sanst tb_sanst Reserv. Reason
sspesen tb_spesen Expenses Key
buprclim tb_buprclim_l Limit price
srunitlim tb_runit Currency Unit
bpprclim tb_bpprclim_l Limit price
jverk6b tb_verk6b Sale §6b
peffzins tb_pyield Effect.Int.Rate
peffzins_given tb_pyield_given GivenEff.Int.Rt
peffzcall tb_pyieldcall Eff. IR Term.
seffmeth seffmeth Eff.Int. Method
notice_date tb_notice_date Notice Date
rounding_rule tpm_rounding_rule Rounding Rule
bpprc_spot2 tb_bpprc_spot_mat_l SpotRate at Mat
bpprc_spot1 tb_bpprc_spot1_l Spot 1
bpprc_marg tb_bpprc_marg Margin rate
coc_rate tb_bpprc_coc2 Int. Rate CoC
forward_date ftr_fwddate Fwd Date
snotdelivered ftr_not_del_flg Not Delivered
peffz_worst tb_worst_yield Yield to Worst
peffz_worst_dt tb_worst_yield_dt Yield to Worst Date
zvtrab tb_zvtrab Time Zone Contr.Date
nom_up_limit ftr_bzbetr_upper Upper limit amount
nom_low_limit ftr_bzbetr_lower Lower limit amount
termination_strategy ttm_termination_strategy Term. Strategy

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 Activity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBFHAZU (
    MANDT,                 -- Client [mandt]
    BUKRS,                 -- Company Code [bukrs]
    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,               -- External Ref. [tb_nordext]
    DBLFZ,                 -- Term Start [tb_dblfz]
    DELFZ,                 -- Term End [tb_delfz]
    DFIX,                  -- Fixing Date [tb_dfix]
    FIXING_REF_ID,         -- Fixing Ref. ID [ftr_fixing_ref_id]
    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]
    SCONFIRM,              -- Confirmation [tb_conf]
    DEXDAT,                -- Confirm. Date [tb_dconf]
    UEXNAM,                -- User [tb_uconf]
    SRECONFIRM,            -- Counterconfirm. [tb_reconf]
    DREDAT,                -- Counterc. Date [tb_dredat]
    URENAM,                -- User [tb_urenam]
    DORDER,                -- Order Date [tb_dorder]
    DANST,                 -- Reserv. Date [tb_danst]
    TANST,                 -- Order Time [tb_tanst]
    SANST,                 -- Reserv. Reason [tb_sanst]
    SSPESEN,               -- Expenses Key [tb_spesen]
    BUPRCLIM,              -- Limit price [tb_buprclim_l]
    SRUNITLIM,             -- Currency Unit [tb_runit]
    BPPRCLIM,              -- Limit price [tb_bpprclim_l]
    JVERK6B,               -- Sale §6b [tb_verk6b]
    PEFFZINS,              -- Effect.Int.Rate [tb_pyield]
    PEFFZINS_GIVEN,        -- GivenEff.Int.Rt [tb_pyield_given]
    PEFFZCALL,             -- Eff. IR Term. [tb_pyieldcall]
    SEFFMETH,              -- Eff.Int. Method [seffmeth]
    NOTICE_DATE,           -- Notice Date [tb_notice_date]
    ROUNDING_RULE,         -- Rounding Rule [tpm_rounding_rule]
    BPPRC_SPOT2,           -- SpotRate at Mat [tb_bpprc_spot_mat_l]
    BPPRC_SPOT1,           -- Spot 1 [tb_bpprc_spot1_l]
    BPPRC_MARG,            -- Margin rate [tb_bpprc_marg]
    COC_RATE,              -- Int. Rate CoC [tb_bpprc_coc2]
    FORWARD_DATE,          -- Fwd Date [ftr_fwddate]
    SNOTDELIVERED,         -- Not Delivered [ftr_not_del_flg]
    PEFFZ_WORST,           -- Yield to Worst [tb_worst_yield]
    PEFFZ_WORST_DT,        -- Yield to Worst Date [tb_worst_yield_dt]
    ZVTRAB,                -- Time Zone Contr.Date [tb_zvtrab]
    NOM_UP_LIMIT,          -- Upper limit amount [ftr_bzbetr_upper]
    NOM_LOW_LIMIT,         -- Lower limit amount [ftr_bzbetr_lower]
    TERMINATION_STRATEGY,  -- Term. Strategy [ttm_termination_strategy]
    PRIMARY KEY (MANDT, BUKRS, RFHA, RFHAZU)
);

Learn More