VTBFHA

Transparent Table Application Table
100 Fields 22 CDS Views

Transaction

VTBFHA is an SAP database table in S/4HANA. Transaction. It contains 100 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
E_Financialtransaction view from EXTENSION Extension View of Financial Transaction
I_CmmdtyHdgFinTransActivity view from COMPOSITE Basic for Transaction Table
I_CmmdtyHdgFinTransActivity view union_all COMPOSITE Basic for Transaction Table
I_CmmdtyHedgeTransFlowActivity view inner COMPOSITE Financial Transaction Flow
I_CommodityHedgeTransaction view from BASIC Financial Transaction Details
I_FinancialTransaction view from BASIC Financial Transaction
I_FinTransSecurity view from COMPOSITE Fin Trans Securities Information
I_Ftr_Facility_Vh view from BASIC Facilities
P_CmmdtyFinTransactionHeader view from COMPOSITE Commodity Financial Transaction Header
P_CmmdtyHdgFXFinTransFlow view inner COMPOSITE Commodity FX Financial Transaction Flow
P_DerivativePosOptnDelta view left_outer COMPOSITE Derivative Position Option Delta Factor
P_FinTransactionActivity view inner COMPOSITE Financial Transaction Activity
P_Ftr_Asgn_Pos_With_Start view inner COMPOSITE Position Object with Start Information
P_Ftr_Vtbfha view from BASIC vtbfha table
P_FXTransactionNominal view from BASIC Nominal of a FX Transaction
P_FXTransactionNominal view union_all BASIC Nominal of a FX Transaction
P_IRM_Financial_Transaction view from BASIC leave it here incase future reuse
P_SecClassIntCond view from COMPOSITE Interest condition for Sec. Class
R_FinTransActiveActivity view from BASIC Fin Trans Active Activity
R_FinTransCashFlowActivity view inner BASIC Financial Transaction Cash Flow Activity
TOE_CDS_TRM_DEALS view_entity from cds view for deal nominals in TOENE
TOE_CDS_TRM_DEALS view_entity union_all cds view for deal nominals in TOENE

Fields (100)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
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
rmaid tb_rmaid Agreement
rfhazunr tb_rfhazun Activity Number
rfhazul tb_rfhazul Active activity
saktiv tb_saktiv Active Status
kontrh tb_kunnr_new Partner
srolext char3 3-Byte field
rgarant tb_rgarant_new Guarantor
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
rldepo vrldepo Securities Acct
zuonr tb_tfproj Finance Project
delfz tb_delfz Term End
abwtyp tb_abwtyp Processing Cat.
tbegru tbegru Authoriz. Group
vrfha tb_vorfha Ref. Transac.
sinclbe tb_sinclbe End Inclusive
snpvcal tb_snpvcal NPV Calculation
srndng tb_srndng Round
zuond tb_zuond Assignment
refer tb_refer Internal Ref.
merkm tb_merkm Characteristics
sfrgzust tb_frgzust Release Status
ranl vvranlw Security Class
rcomvalcl tpm_com_val_class Gen. Valn Class
facilitynr tb_facilitynr Facility
facilitybukrs tb_facilitybukrs CoCd of Facility
posacc tpm_pos_account_fut Futures Acct
rcomvalcl2 tpm_com_val_class Gen. Valn Class
fund fm_fund Fund
grant_nbr gm_grant_nbr Grant
timestamp_deal timestamp Time Stamp
commodity_id trco_comm_id Cmdty ID (obsolete)
rportb2 rportb Portfolio
commodity_id1 trco_comm_id Cmdty ID (obsolete)
commodity_id2 trco_comm_id Cmdty ID (obsolete)
clearing_option tpm_trea_clearing_opt Clear.Opt.
clearing_status tpm_trea_clearing_status Clearing Status
clearing_date tpm_trea_clearing_date Planned Cl.Date
ext_account tpm_ext_account External Account
clear_date_act tpm_trea_clearing_date_act Act. Clrg Date
scondition ftr_condition_used Condition Used
risk_mitigating ftr_threshold_risk_mitigating Risk Mitigation
fima_calculation tb_fima_calculation CF Calculation
trustee ftr_trustee Trustee
prctr prctr Profit Center
rcntr kostl Cost Center
ps_posid ps_psp_pnr WBS Element
rbusa gsber Business Area
hedge_class toe_hedging_classification Hedging Classificatn
init_classifier trpa_initial_stage Initial Stage
country land1 Country/Reg.
fb_segment fb_segment Segment
behalf_of_company trba_behalf_of_company On Behalf of CoCode
traded_currency ftr_traded_curr Traded Currency
hedge_request_id toe_request_id Hedge Request ID
cfi_code ftr_cfi_code CFI Code
upi ftr_upi Unique Prod. ID
isin ranl_isin Sec. ID (ISIN)
rtn ftr_rtn Rept Trackg No.
mic tba_mic MIC
contract_timestamp_utc ftr_contract_timestamp_utc Contract Timestamp
bupla bupla Business place
fkber fkber Functional Area
priceindex_used tb_index_on Index Calculation
hedge_book cmm_hedge_book Hedge Book
hedge_specification_id cmm_hs_id Hedge Spec. ID
hedge_spec_order_id cmm_hs_orderid Order ID
custom_diff_term_1 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_2 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_3 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_4 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_5 tpm_cust_diff_term_value Cust.Diff.Term Val.
flowuuid_active tb_flowuuid_active Active Flow UUID

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBFHA (
    MANDT,                   -- Client [mandt]
    BUKRS,                   -- Company Code [bukrs]
    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]
    RMAID,                   -- Agreement [tb_rmaid]
    RFHAZUNR,                -- Activity Number [tb_rfhazun]
    RFHAZUL,                 -- Active activity [tb_rfhazul]
    SAKTIV,                  -- Active Status [tb_saktiv]
    KONTRH,                  -- Partner [tb_kunnr_new]
    SROLEXT,                 -- 3-Byte field [char3]
    RGARANT,                 -- Guarantor [tb_rgarant_new]
    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]
    RLDEPO,                  -- Securities Acct [vrldepo]
    ZUONR,                   -- Finance Project [tb_tfproj]
    DELFZ,                   -- Term End [tb_delfz]
    ABWTYP,                  -- Processing Cat. [tb_abwtyp]
    TBEGRU,                  -- Authoriz. Group [tbegru]
    VRFHA,                   -- Ref. Transac. [tb_vorfha]
    SINCLBE,                 -- End Inclusive [tb_sinclbe]
    SNPVCAL,                 -- NPV Calculation [tb_snpvcal]
    SRNDNG,                  -- Round [tb_srndng]
    ZUOND,                   -- Assignment [tb_zuond]
    REFER,                   -- Internal Ref. [tb_refer]
    MERKM,                   -- Characteristics [tb_merkm]
    SFRGZUST,                -- Release Status [tb_frgzust]
    RANL,                    -- Security Class [vvranlw]
    RCOMVALCL,               -- Gen. Valn Class [tpm_com_val_class]
    FACILITYNR,              -- Facility [tb_facilitynr]
    FACILITYBUKRS,           -- CoCd of Facility [tb_facilitybukrs]
    POSACC,                  -- Futures Acct [tpm_pos_account_fut]
    RCOMVALCL2,              -- Gen. Valn Class [tpm_com_val_class]
    FUND,                    -- Fund [fm_fund]
    GRANT_NBR,               -- Grant [gm_grant_nbr]
    TIMESTAMP_DEAL,          -- Time Stamp [timestamp]
    COMMODITY_ID,            -- Cmdty ID (obsolete) [trco_comm_id]
    RPORTB2,                 -- Portfolio [rportb]
    COMMODITY_ID1,           -- Cmdty ID (obsolete) [trco_comm_id]
    COMMODITY_ID2,           -- Cmdty ID (obsolete) [trco_comm_id]
    CLEARING_OPTION,         -- Clear.Opt. [tpm_trea_clearing_opt]
    CLEARING_STATUS,         -- Clearing Status [tpm_trea_clearing_status]
    CLEARING_DATE,           -- Planned Cl.Date [tpm_trea_clearing_date]
    EXT_ACCOUNT,             -- External Account [tpm_ext_account]
    CLEAR_DATE_ACT,          -- Act. Clrg Date [tpm_trea_clearing_date_act]
    SCONDITION,              -- Condition Used [ftr_condition_used]
    RISK_MITIGATING,         -- Risk Mitigation [ftr_threshold_risk_mitigating]
    FIMA_CALCULATION,        -- CF Calculation [tb_fima_calculation]
    TRUSTEE,                 -- Trustee [ftr_trustee]
    PRCTR,                   -- Profit Center [prctr]
    RCNTR,                   -- Cost Center [kostl]
    PS_POSID,                -- WBS Element [ps_psp_pnr]
    RBUSA,                   -- Business Area [gsber]
    HEDGE_CLASS,             -- Hedging Classificatn [toe_hedging_classification]
    INIT_CLASSIFIER,         -- Initial Stage [trpa_initial_stage]
    COUNTRY,                 -- Country/Reg. [land1]
    FB_SEGMENT,              -- Segment [fb_segment]
    BEHALF_OF_COMPANY,       -- On Behalf of CoCode [trba_behalf_of_company]
    TRADED_CURRENCY,         -- Traded Currency [ftr_traded_curr]
    HEDGE_REQUEST_ID,        -- Hedge Request ID [toe_request_id]
    CFI_CODE,                -- CFI Code [ftr_cfi_code]
    UPI,                     -- Unique Prod. ID [ftr_upi]
    ISIN,                    -- Sec. ID (ISIN) [ranl_isin]
    RTN,                     -- Rept Trackg No. [ftr_rtn]
    MIC,                     -- MIC [tba_mic]
    CONTRACT_TIMESTAMP_UTC,  -- Contract Timestamp [ftr_contract_timestamp_utc]
    BUPLA,                   -- Business place [bupla]
    FKBER,                   -- Functional Area [fkber]
    PRICEINDEX_USED,         -- Index Calculation [tb_index_on]
    HEDGE_BOOK,              -- Hedge Book [cmm_hedge_book]
    HEDGE_SPECIFICATION_ID,  -- Hedge Spec. ID [cmm_hs_id]
    HEDGE_SPEC_ORDER_ID,     -- Order ID [cmm_hs_orderid]
    CUSTOM_DIFF_TERM_1,      -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_2,      -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_3,      -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_4,      -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_5,      -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    FLOWUUID_ACTIVE,         -- Active Flow UUID [tb_flowuuid_active]
    PRIMARY KEY (MANDT, BUKRS, RFHA)
);

Learn More