SAP ABAP Table VTBFHA (Transaction)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTBFHA	Table Relationship Diagram
Short Description	Transaction

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	☑	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction
4	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
5	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
6	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
7	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
8	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
9	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
10	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
11	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
12	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
13	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
14	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
15	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
16	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
17	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
18	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
19	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
20	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
21	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
22	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
23	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
24	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
25	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
26	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
27	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
28	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
29	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
30	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
31	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
32	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
33	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
34	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
35	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
36	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
37	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
38	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
39	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
40	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
41	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
42	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
43	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
44	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
45	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
46	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
47	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
48	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
49	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
50	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
51	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
52	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
53	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
54	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
55	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
56	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
57	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in