1. Home
  2. Resources
  3. SAP Tables
  4. VTXIZU - Forex Transaction Status Table

SAP Table VTXIZU

Forex Transaction Status Table

VTXIZU (Forex Transaction Status Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VTXIZU to other SAP tables.

VTXIZU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RFHA Financial Transaction TB_RFHA VTBFHA CHAR 13 0
RFHAZU Transaction activity TB_RFHAZU NUMC 5 0
CRUSER Entered by TB_CRUSER CHAR 12 0
DCRDAT Entered On TB_DCRDAT DATS 8 0
TCRTIM Entry Time TB_TCRTIM TIMS 6 0
UPUSER Last Changed by TB_UPUSER CHAR 12 0
DUPDAT Changed on TB_DUPDAT DATS 8 0
TUPTIM Time changed TB_TUPTIM TIMS 6 0
SGSART Product Type VVSART TZPA CHAR 3 0
SFHAART Financial Transaction Type TB_SFHAART AT10 CHAR 3 0
SFGZUSTT Transaction Activity Category TB_SFGZUTY AT02 NUMC 2 0
SFUNKTV Transition Function from Directly Preceding Activity TB_SFUNKTV AT60 CHAR 4 0
SFUNKTL Latest function used in editing activity TB_SFUNKTL AT60 CHAR 4 0
ROFHAZU Previous Activity TB_ROFHAZU NUMC 5 0
RFHAZUX Previous activity, which is supplemented by current activity TB_RFHAZUX NUMC 5 0
SAKTIV Active Status of Transaction or Activity TB_SAKTIV NUMC 1 0
0 Active
1 Concluded
2 Replaced
3 Reversed
4 Offer
5 Simulation
6 Old Transaction - No Editing Possible
SSTOGRD Reason for Reversal SSTOGRD TZST CHAR 2 0
RDEALER Trader RDEALER TZDEA CHAR 12 0
DVTRAB Contract Conclusion Date TB_DVTRAB DATS 8 0
TVTRAB Time of contract conclusion TB_TVTRAB TIMS 6 0
GSPPART Contact Person TB_GSPPART CHAR 19 0
XAKT File Number XAKT CHAR 32 0
NORDEXT External Reference TB_NORDEXT CHAR 16 0
DBLFZ Term Start TB_DBLFZ DATS 8 0
DELFZ Term End TB_DELFZ DATS 8 0
DFIX Fixing date TB_DFIX DATS 8 0
SINCLE End of Term Inclusive Indicator TB_SINCLE CHAR 1 0
X Yes
NULL No
DZSTND Last activity transition date (e.g. for rollover) TB_DZSTND DATS 8 0
SZNSPRO Interest Handling with Rollover TB_SZNSPRO NUMC 1 0
0 Payment
1 Capitalization
2 Deferral
DZNSSTD Payment date for deferred interest TB_DZNSSTD DATS 8 0
KKURS Rate of Forex Transaction TB_KKURS DEC 13 9
KKASSA Spot Rate TB_KKASSA DEC 13 9
KSWAP Swap Rate TB_KSWAP DEC 13 9
WLWAERS Leading currency TB_WLWAERS TCURC CUKY 5 0
WFWAERS Following Currency TB_WFWAERS TCURL CUKY 5 0
LIMITART Limit type TB_LIMITAR ATOR CHAR 2 0
LIMITDAT Limit date TB_LIMITDA DATS 8 0
RKONDGR Direction of Transaction TB_RKONDGR NUMC 1 0
0 Incoming and outgoing
1 Outgoing
2 Incoming
LIWAERS Reference currency for limit TB_LIWAERS TCURC CUKY 5 0
KWLIQUI Liquidity effect for rollover TX_KWLIQ DEC 13 9
SCONFIRM Confirmation Status TB_CONF NUMC 1 0
0 Not Required
1 Required
2 Executed
3 Sent
4 Incorrect
DEXDAT Confirmation Date TB_DCONF DATS 8 0
UEXNAM Confirmation Executed By (User Responsible) TB_UCONF CHAR 12 0
SRECONFIRM Counterconfirmation TB_RECONF NUMC 1 0
0 Not Required
1 Required
2 Reminder Sent
3 Matched
4 Incorrect
5 Cannot Be Assigned
DREDAT Counterconfirmation Date TB_DREDAT DATS 8 0
URENAM Counterconfirmation Executed by (User Responsible) TB_URENAM CHAR 12 0
DORDER Order date TB_DORDER DATS 8 0
DANST Reservation date TB_DANST DATS 8 0
TANST Order time of day TB_TANST TIMS 6 0
SANST Reservation Reason TB_SANST TW14 CHAR 2 0
SSPESEN Expenses key TB_SPESEN CHAR 1 0
1 Without charges
2 With charges
3 Charges included in price
BUPRCLIM Limit Price for Unit Quotation TB_BUPRCLIM DEC 15 6
SRUNITLIM Currency Unit of the Rate TB_RUNIT CHAR 5 0
BPPRCLIM Limit Price for Percentage Quotation TB_BPPRCLIM DEC 15 6
JVERK6B Flag for sale from �6b - position TB_VERK6B CHAR 1 0
PEFFZINS Effective Interest Rate TB_PYIELD DEC 10 7
PEFFZINS_GIVEN Given Effective Interest Rate TB_PYIELD_GIVEN DEC 10 7
PEFFZCALL Effective interest rate - termination of issuer TB_PYIELDCALL DEC 10 7
SEFFMETH Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
NOTICE_DATE OTC Notice Date TB_NOTICE_DATE DATS 8 0
ROUNDING_RULE Rounding Rule TPM_ROUNDING_RULE TRSC_ROUND_RULE CHAR 4 0
BPPRC_SPOT2 Spot Rate at Maturity in Percentage TB_BPPRC_SPOT_MAT DEC 15 6
BPPRC_SPOT1 Current Spot Rate in Percentage TB_BPPRC_SPOT1 DEC 15 6
BPPRC_MARG Margin Rate in Percentage TB_BPPRC_MARG DEC 15 5
COC_RATE Interest Rate for Cost of Carryforward TB_BPPRC_COC2 DEC 15 6
FORWARD_DATE Forward Date FTR_FWDDATE DATS 8 0
SNOTDELIVERED Security not delivered FTR_NOT_DEL_FLG CHAR 1 0
X Yes
NULL No
DVALUTA Value date of forex transaction TB_DVALUTA DATS 8 0
XDVALUTA Value Date TX_DVALUTA CHAR 10 0
XDFIX Fixing date as text field TX_DFIX CHAR 10 0
XWDARST Invert 'Leading currency'/'Following currency' TX_XWDARST CHAR 1 0
X Yes
NULL No
XCURRPAIR Character Length 11 CHAR11 CHAR 11 0
VALRATETIM Time of current rate TB_ACTRATETIM TIMS 6 0
VALRATE1 Current market rate TB_ACTKURS DEC 13 9
XVALRATE1PAIR Character Length 11 CHAR11 CHAR 11 0
VALSWAP1 Swap Rate TB_KSWAP DEC 13 9
VALRATE2 Current market rate TB_ACTKURS DEC 13 9
VALSWAP2 Swap Rate TB_KSWAP DEC 13 9
XVALRATE2PAIR Character Length 11 CHAR11 CHAR 11 0
XFORWARD_DATE Text Input Field: Forward Date TX_FWD_DATE CHAR 10 0

VTXIZU foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTXIZU BUKRS VTXIZU MANDT T001 Company Codes MANDT
VTXIZU BUKRS VTXIZU BUKRS T001 Company Codes BUKRS
VTXIZU LIMITART VTXIZU MANDT ATOR Table of Limit Types MANDT
VTXIZU LIMITART VTXIZU LIMITART ATOR Table of Limit Types LIMITART
VTXIZU LIWAERS VTXIZU MANDT TCURC Currency Codes MANDT
VTXIZU LIWAERS VTXIZU LIWAERS TCURC Currency Codes WAERS
VTXIZU MANDT VTXIZU MANDT T000 Clients MANDT
VTXIZU RDEALER VTXIZU MANDT TZDEA Trader register MANDT
VTXIZU RDEALER VTXIZU BUKRS TZDEA Trader register BUKRS
VTXIZU RDEALER VTXIZU RDEALER TZDEA Trader register RDEALER
VTXIZU RFHA VTXIZU MANDT VTBFHA Transaction MANDT
VTXIZU RFHA VTXIZU BUKRS VTBFHA Transaction BUKRS
VTXIZU RFHA VTXIZU RFHA VTBFHA Transaction RFHA
VTXIZU ROUNDING_RULE VTXIZU MANDT TRSC_ROUND_RULE Treasury: Rounding Rule MANDT
VTXIZU ROUNDING_RULE VTXIZU ROUNDING_RULE TRSC_ROUND_RULE Treasury: Rounding Rule ROUNDING_RULE
VTXIZU SANST VTXIZU MANDT TW14 Table for storing offer reasons MANDT
VTXIZU SANST VTXIZU SANST TW14 Table for storing offer reasons SANST
VTXIZU SFGZUSTT VTXIZU SFGZUSTT AT02 Transaction Activity Category SFGZUSTT
VTXIZU SFGZUSTT * AT02 Transaction Activity Category SANLFOR
VTXIZU SFGZUSTT * AT02 Transaction Activity Category SFGTYP
VTXIZU SFHAART VTXIZU MANDT AT10 Transaction Types MANDT
VTXIZU SFHAART VTXIZU SGSART AT10 Transaction Types SGSART
VTXIZU SFHAART VTXIZU SFHAART AT10 Transaction Types SFHAART
VTXIZU SFUNKTL VTXIZU SFUNKTL AT60 Definition of Treasury Functions for Activity Processing SFUNKTION
VTXIZU SFUNKTV VTXIZU SFUNKTV AT60 Definition of Treasury Functions for Activity Processing SFUNKTION
VTXIZU SGSART VTXIZU MANDT TZPA Financial Assets Management Product Types MANDT
VTXIZU SGSART VTXIZU SGSART TZPA Financial Assets Management Product Types GSART
VTXIZU SSTOGRD VTXIZU MANDT TZST Reasons for reversal MANDT
VTXIZU SSTOGRD VTXIZU SSTOGRD TZST Reasons for reversal SSTOGRD
VTXIZU WFWAERS VTXIZU WLWAERS TCURL Leading Currency LWAERS
VTXIZU WFWAERS VTXIZU WFWAERS TCURL Leading Currency FWAERS
VTXIZU WFWAERS VTXIZU MANDT TCURL Leading Currency MANDT
VTXIZU WLWAERS VTXIZU MANDT TCURC Currency Codes MANDT
VTXIZU WLWAERS VTXIZU WLWAERS TCURC Currency Codes WAERS