SAP ABAP Table VFSFHA (Fin. Transaction from View of Listed Options and Futures)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTT (Package) R/3 application development for Treasury forward trading

Basic Data

Table Category	INTTAB	Structure
Structure	VFSFHA	Table Relationship Diagram
Short Description	Fin. Transaction from View of Listed Options and Futures

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Transaction
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
5	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
6	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
7	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
9	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
10	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
11	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
12	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
13	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
14	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
15	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
16	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
17	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
18	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
19	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
20	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
21	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
22	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
23	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
24	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
25	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
26	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
27	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
28	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
29	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
30	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
31	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
32	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
33	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
34	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
35	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
36	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
38	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
39	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
40	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
41	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
42	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
43	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
44	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
45	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
46	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
47	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
48	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
49	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
50	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
51	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
52	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
53	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
54	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
55	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
56	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
57	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
58	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
59	.INCLUDE	☐				0	0	Financial Transaction: Futures Screen Fields
60	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
61	XGSART	☐	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
62	XFHAART	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
63	XABWTYP	☐	TB_XABRBEZ	TEXT60	CHAR	60	0	Name: Processing Category
64	SKUENDT	☐	TM_SKUENDT	XFELD	CHAR	1	0	Period of notice in days
65	SKUENDM	☐	TM_SKUENDM	XFELD	CHAR	1	0	Period of notice in months
66	XRFHA	☐	TB_XRFHA	T_XRFHA	CHAR	13	0	Financial transaction number
67	XAKTIV	☐	TM_XAKTIV	TEXT60	CHAR	60	0	Active status: description
68	XFRGZUST	☐	TB_XFRGZUST	TEXT60	CHAR	60	0	Transaction release: Release status
69	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
70	XGARANT	☐	TB_XGARANT	TEXT80	CHAR	80	0	Name and address of guarantor
71	SNOTE	☐	TB_SNOTE	XFELD	CHAR	1	0	Memo exists
72	SINCLB	☐	TB_SINCLBB	XFELD	CHAR	1	0	Calculation Period: Start Inclusive - End Exclusive
73	SINCLE	☐	TB_SINCLEB	XFELD	CHAR	1	0	Calculation Period: Start Exclusive - End Inclusive
74	SNPVCALY	☐	TB_SNPVCALY	XFELD	CHAR	1	0	NPV calculation via yield
75	SNPVCALD	☐	TB_SNPVCALD	XFELD	CHAR	1	0	NPV calculation via discounting
76	SRNDNGB	☐	TB_SRNDNGB	XFELD	CHAR	1	0	Round Up or Down to the Nearest Whole Number
77	SRNDNGD	☐	TB_SRNDNGD	XFELD	CHAR	1	0	Round down
78	SRNDNGU	☐	TB_SRNDNGU	XFELD	CHAR	1	0	Round up
79	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
80	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
81	DVORGANG	☐	DVORGANG	DATUM	DATS	8	0	Activity date
82	XLDEPO	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
83	KONTRH_NEW	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
84	XPOSACC	☐	XPOSACC	XLDEPO	CHAR	30	0	Futures Account Text Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VFSFHA	ABWTYP	AT05	ABWTYP	KEY	1	CN
2	VFSFHA	BUKRS	T001	BUKRS	KEY	1	CN
3	VFSFHA	FACILITYBUKRS	T001	BUKRS	KEY	1	CN
4	VFSFHA	FACILITYNR	VTBFHA	RFHA
5	VFSFHA	MANDT	T000	MANDT	KEY	1	CN
6	VFSFHA	OBJNR	ONR00	OBJNR		1	N
7	VFSFHA	POSACC	TRFT_POS_ACCOUNT	POS_ACCOUNT
8	VFSFHA	RCOMVALCL	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
9	VFSFHA	RCOMVALCL2	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
10	VFSFHA	RLDEPO	TWD01	RLDEPO		C	CN
11	VFSFHA	RMAID	VTBMA	RMAID		C	CN
12	VFSFHA	RPORTB	TWPOB	RPORTB
13	VFSFHA	RPORTB2	TWPOB	RPORTB
14	VFSFHA	RREFKONT	T037S	RREFKONT	KEY	1	CN
15	VFSFHA	RREFKONT2	T037S	RREFKONT	REF	C	CN
16	VFSFHA	SANLF	TZAF	SANLF	KEY	1	CN
17	VFSFHA	SFGTYP	AT01	SFGTYP	KEY	1	CN
18	VFSFHA	SFHAART	AT10	SFHAART	KEY	1	CN
19	VFSFHA	SGSART	TZPA	GSART	KEY	1	CN
20	VFSFHA	SKALID	TFACD	IDENT	KEY	1	CN
21	VFSFHA	SKALID2	TFACD	IDENT	KEY	1	CN
22	VFSFHA	TBEGRU	TRBRG	TBEGRU		C	N
23	VFSFHA	WGSCHFT	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	462_10