SAP ABAP Table TRFDUMW (TR-EDT: Regulatory Reporting)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	INTTAB	Structure
Structure	TRFDUMW	Table Relationship Diagram
Short Description	TR-EDT: Regulatory Reporting

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	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
2	JBAVG	☐	JBAVG	KENZX	CHAR	1	0	BAV approval
3	XAKTZBAV	☐	XAKTZBAV	TEXT32	CHAR	32	0	BAV file number
4	DBAVGEN	☐	DBAVGEN	DATUM	DATS	8	0	Date of BAV authorization
5	SGBAV	☐	SGBAV	SGBAV	NUMC	3	0	BAV asset group (C11/74) indicator	TW06
6	SBAV501	☐	SBAV501	SBAV501	CHAR	4	0	*** Internal usage ***	TW12B
7	JARW	☐	JARW	JANEI	CHAR	1	0	*** Not used ***
8	DARWGEN	☐	DARWGEN	DATUM	DATS	8	0	Date for fixing the accepted value
9	XAKTZARW	☐	XAKTZARW	TEXT20	CHAR	20	0	BAV file character_accepted value
10	XAUFORT	☐	XAUFORT	TEXT22	CHAR	22	0	Storage location
11	DERWMEL	☐	DERWMEL	DATUM	DATS	8	0	Date when the acquistion was reported to FISO
12	SJBUE	☐	VVSJBUE	VVSJBUE	CHAR	6	0	Asset group R11/76, Asset 6 (yearly stock overview)	TZ17
13	SNEU_ANL	☐	VVSNEU_ANL	VVSNEU_ANL	CHAR	9	0	Asset group R11/76, appendix 3 and 4	TZ18
14	XR5_91_1	☐	VVXR5_91_1	VVXR5_91_1	CHAR	2	0	Indicator R5/91, appendix 1
15	XR5_91_2	☐	VVXR5_91_2	KENZX	CHAR	1	0	Indicator R5/91, appendix 1
16	XR5_91_3	☐	VVXR5_91_3	KENZX	CHAR	1	0	Indicator R5/91, appendix 3
17	XTREU	☐	VVXTREU	KENZX	CHAR	1	0	*** Internal usage ***
18	XDECK	☐	VVXDECK	KENZX	CHAR	1	0	Indicator for eligibility for premium reserve fund
19	XARW	☐	VVXARW	KENZX	CHAR	1	0	BAV approval of accepted value
20	SMW102	☐	VVSMW102	VVSMW102	CHAR	5	0	BAV asset group stmt 102	TZ32
21	X_R97_03	☐	VVX_R97_03	VVX_R97_03	CHAR	2	0	Indicator for circular R5/97 appendix 3 and 4	TZ36
22	X_R97_05	☐	VVX_R97_05	VVX_R97_05	CHAR	2	0	Indicator for R5/97 appendix 5	TZ37
23	X_R97_06	☐	VVX_R97_06	VVX_R97_06	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral
24	X_R97_08	☐	VVX_R97_08	VVX_R97_08	CHAR	1	0	Indicator for R5/97 appendix 8	TZ38
25	X_R97_101	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
26	X_R97_102	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
27	X_R97_103	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
28	X_R97_104	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
29	XTREU1	☐	VVXTREU1	VVXTREU1	CHAR	1	0	Trustee inflow/outflow list indicator
30	DGUEL_AB	☐	DGUEL_AB	DATUM	DATS	8	0	Entry effective from
31	SUDEC	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
32	SSKZB	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
33	SOEFFKL	☐	SOEFFKL	JANEI	CHAR	1	0	Indicator BAV opening clause
34	RINUM	☐	RINUM	RINUM	CHAR	22	0	BAV identification number
35	SSKZF	☐	SSKZF	SSKZF	NUMC	1	0	Tax office stock indicator	TZ13
36	RINUMH	☐	RINUMH	CHAR30	CHAR	30	0	BAV hist. identifications number
37	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
38	SANLART	☐	VVSANLART	VVSANLART	CHAR	6	0	BAV asset type PRF3 and PRF8	TZ19
39	BARWBAV	☐	UB_BARWBAV	NUM13	NUMC	13	0	BAV accepted value
40	N_BARWBAV	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
41	SAWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
42	BVWERT	☐	UB_BVWERT	NUM13	NUMC	13	0	Market value BAV
43	N_BVWERT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
44	SVWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
45	BARW_VU	☐	UB_BARW_VU	NUM13	NUMC	13	0	Accepted value VU
46	N_BARW_VU	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
47	SAWHR_VU	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
48	SAART	☐	VVSAART	VVSAART	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	TZ28
49	SDV	☐	VVSDV	VVSDVNR	CHAR	2	0	Premium reserve fund list number	TZ30
50	SUABT	☐	VVSUABT	VVSUABT	CHAR	2	0	Subsection number of premium reserve fund list	TZ31
51	SMWWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
52	SNW600	☐	VVSNW600	VVSNW600	CHAR	4	0	Asset group BAV stmt 101, 201 and 600	TZ29P

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRFDUMW	SAART	TZ28	SAART
2	TRFDUMW	SANLART	TZ19	SANLART	KEY	1	CN
3	TRFDUMW	SBAV501	TW12B	SBAV501	KEY	1	CN
4	TRFDUMW	SDV	TZ30	SDV	KEY	1	CN
5	TRFDUMW	SGBAV	TW06	SGBAV	KEY	1	CN
6	TRFDUMW	SJBUE	TZ17	SJBUE	KEY	1	CN
7	TRFDUMW	SMW102	TZ32	SMW102	KEY	1	CN
8	TRFDUMW	SNEU_ANL	TZ18	SNEU_ANL	KEY	1	CN
9	TRFDUMW	SNW600	TZ29P	SNW600
10	TRFDUMW	SSKZB	TZ11	SSKZB	KEY	1	CN
11	TRFDUMW	SSKZF	TZ13	SSKZF	KEY	1	CN
12	TRFDUMW	SUABT	TZ31	SUABT	KEY	1	CN
13	TRFDUMW	SUDEC	TW05	SUDEC	KEY	1	CN
14	TRFDUMW	X_R97_03	TZ36	X_R97_03
15	TRFDUMW	X_R97_05	TZ37	X_R97_05
16	TRFDUMW	X_R97_08	TZ38	X_R97_08
17	TRFDUMW	X_R97_101	TZ39B	X_R97_10
18	TRFDUMW	X_R97_102	TZ39B	X_R97_10
19	TRFDUMW	X_R97_103	TZ39B	X_R97_10
20	TRFDUMW	X_R97_104	TZ39B	X_R97_10

History

Last changed by/on	SAP	20110901
SAP Release Created in