SAP ABAP Table V_TF691 (Generated Table for View V_TF691)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TF691	Table Relationship Diagram
Short Description	Generated Table for View V_TF691

Delivery and Maintenance

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

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	DIMEN	☑	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
3	COILV	☐	FC_COILV	FC_COILV	CHAR	1	0	Calculation base for the consolidation of investments
4	INVVAL	☐	FC_INVVAL	FC_VALDB1	CHAR	1	0	Location of investment holdings values
5	EQUVAL	☐	FC_EQUVAL	FC_VALDB1	CHAR	1	0	Location of equity data
6	EQIVAL	☐	FC_EQIVAL	FC_VALDB2	CHAR	1	0	Location of data for subsequent equity consolidation
7	ESHFLG	☐	FC_ESHFLG	X	CHAR	1	0	Net display of equity aging report
8	ESHSIT	☐	FC_ESHSIT	FC_SITYP	CHAR	3	0	Subitem category for investee equity	TF110
9	ESHMDS	☐	FC_ESHMDS	FC_SITEM	CHAR	10	0	Debits subitem for minority interest	TF115
10	ESHMCS	☐	FC_ESHMCS	FC_SITEM	CHAR	10	0	Credits subitem for minority interest	TF115
11	XRINDGWBS	☐	FC_XRINDGWBS	FC_EXRIND	CHAR	1	0	Goodwill in Local Crcy: Exchange Rate Ind., Balance Sheet	TF420
12	XRINDGWIS	☐	FC_XRINDGWIS	FC_EXRIND	CHAR	1	0	Goodwill in Local Crcy: Exchange Rate Ind., Income Statement	TF420
13	CTKEYGWIS	☐	FC_CTKEYGWIS	FC_COI_CTKEY	CHAR	1	0	Goodwill in Local Crcy: Currency Trl. Key, Income Statement
14	GWTBEGFLG	☐	FC_GWTBEGFLG	X	CHAR	1	0	Currency Translation for Goodwill at Beginning of Period
15	LDTYR	☐	FC_LDTYR	GJAHR	NUMC	4	0	Fiscal Year of Legacy Data Transfer
16	LDTPE	☐	FC_LDTPE	PERDE	NUMC	3	0	Period of Legacy Data Transfer
17	NINVFLG	☐	FC_NINVFLG	X	CHAR	1	0	Enable negative investments
18	NMINFLG	☐	FC_NMINFLG	X	CHAR	1	0	No calculation of minority interest
19	NIPDFLG	☐	FC_NIPDFLG	X	CHAR	1	0	Affect net income when posting partial divestitures
20	NIIDFLG	☐	FC_NIIDFLG	X	CHAR	1	0	Affect net income when reducing indirect investments
21	HRREV	☐	FC_HRREV	FC_HRREV	CHAR	1	0	Procedure for eliminating hidden reserves/contingencies(FVA)
22	HRSHA	☐	FC_HRSHA	FC_HRSHA	CHAR	1	0	Scope of elimination of hidden reserves/contingencies
23	HRSITYP	☐	FC_HRSITYP	FC_SITYP	CHAR	3	0	Subitem category for hidden reserves (fair value adjustment)	TF110
24	HRAQDSI	☐	FC_HRAQDSI	FC_SITEM	CHAR	10	0	Subitem for transferring hidden reserves (fair value adj.)	TF115
25	HRDPCSI	☐	FC_HRDPCSI	FC_SITEM	CHAR	10	0	Subitem for amortization of hidden reserves (fair value adj)	TF115
26	HRDPDSI	☐	FC_HRDPDSI	FC_SITEM	CHAR	10	0	Subitem for writeups of hidden reserves (fair value adj.)	TF115
27	NHSITYP	☐	FC_NHSITYP	FC_SITYP	CHAR	3	0	Subitem category for hidden contingencies (fair value adj.)	TF110
28	NHAQCSI	☐	FC_NHAQCSI	FC_SITEM	CHAR	10	0	Subitem for transferring hidden contingencies (fair val.adj)	TF115
29	NHDPDSI	☐	FC_NHDPDSI	FC_SITEM	CHAR	10	0	Subitem for changes to hidden contingencies - debit	TF115
30	NHDPCSI	☐	FC_NHDPCSI	FC_SITEM	CHAR	10	0	Subitem for changes to hidden contingencies - credit	TF115
31	GWAYR	☐	FC_GWAYR	NUMC2	NUMC	2	0	Life of goodwill amortization in years
32	GWAPE	☐	FC_GWAPE	NUMC3	NUMC	3	0	Life of goodwill amortization in months
33	GWABG	☐	FC_GWABG	FC_DGWBG	CHAR	1	0	Start date for the amortization of new goodwill
34	GWARFLG	☐	FC_GWARFLG	X	CHAR	1	0	Amortize new goodwill over remaining life
35	GWALFLG	☐	FC_GWALFLG	X	CHAR	1	0	Threshold value for the amortization of goodwill
36	GWALVAL	☐	FC_GWALVAL	WERTV9	CURR	17	2	Threshold value for the amortization of goodwill
37	GWALCUR	☐	FC_GWALCUR	WAERS	CUKY	5	0	Group currency for threshold for goodwill amortization	TCURC
38	GWAMETH	☐	FC_DEPMETH	FC_DEPMETH	NUMC	1	0	Amortization method
39	GWRYR	☐	FC_GWRYR	NUMC2	NUMC	2	0	Life of the periodic reduction of goodwill - years
40	GWRPE	☐	FC_GWRPE	NUMC3	NUMC	3	0	Life of periodic reduction of goodwill - months
41	GWRBG	☐	FC_GWRBG	FC_DGWBG	CHAR	1	0	Beginning date of the periodic reduction of new goodwill
42	GWRRFLG	☐	FC_GWRRFLG	X	CHAR	1	0	Reduce the new goodwill over its remaining life
43	GWRLFLG	☐	FC_GWRLFLG	X	CHAR	1	0	Threshold value for the periodic reduction of goodwill
44	GWRLVAL	☐	FC_GWRLVAL	WERTV9	CURR	17	2	Threshold value for the periodic reduction of goodwill
45	GWRLCUR	☐	FC_GWRLCUR	WAERS	CUKY	5	0	Group currency for threshold for periodic reduction of GW	TCURC
46	GWRMETH	☐	FC_DEPMETH	FC_DEPMETH	NUMC	1	0	Amortization method
47	NGAYR	☐	FC_NGAYR	NUMC2	NUMC	2	0	Life of amortization of negative goodwill in years
48	NGAPE	☐	FC_NGAPE	NUMC3	NUMC	3	0	Life of amortization of negative goodwill in months
49	NGABG	☐	FC_NGABG	FC_DGWBG	CHAR	1	0	Beginning date of amortization of new negative goodwill
50	NGARFLG	☐	FC_NGARFLG	X	CHAR	1	0	Amortization of new negative goodwill over remain. life
51	NGALFLG	☐	FC_NGALFLG	X	CHAR	1	0	Threshold for amortization of negative goodwill
52	NGALVAL	☐	FC_NGALVAL	WERTV9	CURR	17	2	Threshold for amortization of negative goodwill
53	NGALCUR	☐	FC_NGALCUR	WAERS	CUKY	5	0	Group currency f. threshold of neg. goodwill amortization	TCURC
54	NGAMETH	☐	FC_DEPMETH	FC_DEPMETH	NUMC	1	0	Amortization method
55	NGRYR	☐	FC_NGRYR	NUMC2	NUMC	2	0	Life of periodic reduction of negative goodwill - years
56	NGRPE	☐	FC_NGRPE	NUMC3	NUMC	3	0	Life of periodic reduction of negative goodwill - months
57	NGRBG	☐	FC_NGRBG	FC_DGWBG	CHAR	1	0	Beginning date of the reduction of new negative goodwill
58	NGRRFLG	☐	FC_NGRRFLG	X	CHAR	1	0	Reduce new negative goodwill over its remaining life
59	NGRLFLG	☐	FC_NGRLFLG	X	CHAR	1	0	Threshold for periodic reduction of negative goodwill
60	NGRLVAL	☐	FC_NGRLVAL	WERTV9	CURR	17	2	Threshold for periodic reduction of negative goodwill
61	NGRLCUR	☐	FC_NGRLCUR	WAERS	CUKY	5	0	Group currency of threshold for periodic reduction of neg.GW	TCURC
62	NGRMETH	☐	FC_DEPMETH	FC_DEPMETH	NUMC	1	0	Amortization method
63	ASSDT	☐	FC_ASSDT	FC_ASSDT	CHAR	1	0	Doc. type assignment
64	PUACHK	☐	FC_PUACHK	FC_PUACHK	NUMC	1	0	Validation of Push-down Goodwill

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TF691	DIMEN	TF150	DIMEN	KEY	1	C
2	V_TF691	ESHMCS	TF115	SITEM
3	V_TF691	ESHMDS	TF115	SITEM
4	V_TF691	ESHSIT	TF110	SITYP
5	V_TF691	GWALCUR	TCURC	WAERS
6	V_TF691	GWRLCUR	TCURC	WAERS
7	V_TF691	HRAQDSI	TF115	SITEM
8	V_TF691	HRDPCSI	TF115	SITEM
9	V_TF691	HRDPDSI	TF115	SITEM
10	V_TF691	HRSITYP	TF110	SITYP
11	V_TF691	MANDT	T000	MANDT	KEY	1	CN
12	V_TF691	NGALCUR	TCURC	WAERS
13	V_TF691	NGRLCUR	TCURC	WAERS
14	V_TF691	NHAQCSI	TF115	SITEM
15	V_TF691	NHDPCSI	TF115	SITEM
16	V_TF691	NHDPDSI	TF115	SITEM
17	V_TF691	NHSITYP	TF110	SITYP
18	V_TF691	XRINDGWBS	TF420	KURSA
19	V_TF691	XRINDGWIS	TF420	KURSA

History

Last changed by/on	SAP	20041209
SAP Release Created in