SAP ABAP Table VTGFHA_WRKLIST (TR_Transaction Management: FHA Worklist Toolbox)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
     ⤷ FTTR (Package) Treasury: Financial Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	VTGFHA_WRKLIST	Table Relationship Diagram
Short Description	TR_Transaction Management: FHA Worklist Toolbox

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	TR Transaction Management: Transaction Display Structure
2	.INCLUDE	☐				0	0	Transaction
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
6	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
7	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
10	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
11	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
12	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
13	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
14	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
15	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
16	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
17	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
18	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
19	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
20	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
21	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
22	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
23	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
24	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
25	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
26	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
27	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
28	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
29	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
30	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
31	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
32	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
33	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
34	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
35	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
36	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
37	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
38	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
39	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
40	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
41	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
42	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
43	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
44	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
45	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
46	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
47	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
48	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
49	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
50	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
51	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
52	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
53	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
54	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
55	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
56	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
57	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
58	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
59	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
60	.INCLUDE	☐				0	0	Financial transaction: Screen fields
61	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
62	XGSART	☐	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
63	XFHAART	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
64	XABWTYP	☐	TB_XABRBEZ	TEXT60	CHAR	60	0	Name: Processing Category
65	SKUENDT	☐	TM_SKUENDT	XFELD	CHAR	1	0	Period of notice in days
66	SKUENDM	☐	TM_SKUENDM	XFELD	CHAR	1	0	Period of notice in months
67	XRFHA	☐	TB_XRFHA	T_XRFHA	CHAR	13	0	Financial transaction number
68	XAKTIV	☐	TM_XAKTIV	TEXT60	CHAR	60	0	Active status: description
69	XFRGZUST	☐	TB_XFRGZUST	TEXT60	CHAR	60	0	Transaction release: Release status
70	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
71	XGARANT	☐	TB_XGARANT	TEXT80	CHAR	80	0	Name and address of guarantor
72	SNOTE	☐	TB_SNOTE	XFELD	CHAR	1	0	Memo exists
73	SINCLB	☐	TB_SINCLBB	XFELD	CHAR	1	0	Calculation Period: Start Inclusive - End Exclusive
74	SINCLE	☐	TB_SINCLEB	XFELD	CHAR	1	0	Calculation Period: Start Exclusive - End Inclusive
75	SNPVCALY	☐	TB_SNPVCALY	XFELD	CHAR	1	0	NPV calculation via yield
76	SNPVCALD	☐	TB_SNPVCALD	XFELD	CHAR	1	0	NPV calculation via discounting
77	SRNDNGB	☐	TB_SRNDNGB	XFELD	CHAR	1	0	Round Up or Down to the Nearest Whole Number
78	SRNDNGD	☐	TB_SRNDNGD	XFELD	CHAR	1	0	Round down
79	SRNDNGU	☐	TB_SRNDNGU	XFELD	CHAR	1	0	Round up
80	BEGRUTXT	☐	BEGRUTXT	TEXT50	CHAR	50	0	Name of authorization group for financial transactions
81	XREFKONT	☐	TB_XREFKONT	TEXT40	CHAR	40	0	Name of account assignment reference
82	XREFKONT2	☐	TB_XREFKONT2	TEXT40	CHAR	40	0	Name of account assignment reference 2
83	XPORTB	☐	VVXPORTB	TEXT30	CHAR	30	0	Portfolio name
84	SVALIDATED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
85	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
86	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
87	EXT_RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
88	XLDEPO	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
89	DBLFZ_LABEL	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
90	SMSG	☐	TB_SMSG	XFELD	CHAR	1	0	Messages Exist
91	SFUNKTV	☐	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	*
92	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
93	SCONFIRM	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
94	SRECONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
95	LATEST_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
96	LATEST_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
97	ICON_FLAG	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
98	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
99	PEFFZINS	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
100	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
101	XEFFMETH	☐	TB_XEFFMETH	TEXT60	CHAR	60	0	Name of effective interest rate method
102	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
103	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
104	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
105	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
106	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
107	XANLF	☐	TB_XANLF	TEXT30	CHAR	30	0	Product Category Name
108	XFGTYP	☐	TB_XFGTYP	TEXT30	CHAR	30	0	Transaction category name
109	XPGTYP	☐	TB_XPGTYP	TEXT60	CHAR	60	0	Description of product category and transaction category
110	XFGZUSTT	☐	TB_XFGZUSTT	TEXT30	CHAR	30	0	Name of Activity Category
111	XFUNKTV	☐	TB_XFUNKTV	TEXT30	CHAR	30	0	Treasury function name from directly preceding activity
112	XFUNKTL	☐	TB_XFUNKTL	TEXT30	CHAR	30	0	Name of Treasury function
113	XCONFIRM	☐	TB_XCONFIRM	TEXT60	CHAR	60	0	Confirmation
114	XRECONFIRM	☐	TB_XRECONFIRM	TEXT60	CHAR	60	0	Counterconfirmation
115	XEQUIP	☐	TB_FTR_EQUIP	CHAR181	CHAR	181	0	Structure of transaction
116	START_OF_TERM	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
117	END_OF_TERM	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
118	MODULE_START	☐	RS38L_FNAM	FUNCNAME	CHAR	30	0	Name of Function Module	*
119	MODULE_GET_FUNCLIST	☐	RS38L_FNAM	FUNCNAME	CHAR	30	0	Name of Function Module	*
120	SETTLEMENT_DAY	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in