SAP ABAP Table V_TIVEXFIACC (Generated Table for View)

Basic Data

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

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	KTOPL	☑	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SAKNR	☑	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
5	TXT20	☐	TXT20_SKAT	TEXT20	CHAR	20	0	G/L account short text
6	TXT50	☐	TXT50_SKAT	TEXT50	CHAR	50	0	G/L Account Long Text
7	MCOD1SKAT	☐	MCDS1	CHAR25	CHAR	25	0	Search Term for Matchcode Search
8	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
9	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
10	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
11	ERDATSKB1	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
12	ERNAMSKB1	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
13	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
14	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
15	FIPLS	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
16	FSTAG	☐	FSTAG	FSTAG	CHAR	4	0	Field status group	T004F
17	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
18	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
19	KDFSL	☐	KDFSL	KDFSL	CHAR	4	0	Key for Exchange Rate Differences in Foreign Currency Accts	T030S
20	MITKZ	☐	MITKZ	MITKZ	CHAR	1	0	Account is reconciliation account
21	MWSKZ	☐	SMWSK	SMWSK	CHAR	2	0	Tax Category in Account Master Record
22	STEXT	☐	STEXT_SKB1	TEXT50	CHAR	50	0	G/L account additional text
23	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
24	WAERS	☐	WAERS_SKB1	WAERS	CUKY	5	0	Account currency	TCURC
25	WMETH	☐	WMETH	WMETH	CHAR	2	0	Indicator: account managed in external system
26	XGKON	☐	XGKON	XFELD	CHAR	1	0	Cash receipt account / cash disbursement account
27	XINTB	☐	XINTB	XFELD	CHAR	1	0	Indicator: Is account only posted to automatically?
28	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
29	XLOEB	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
30	XNKON	☐	XNKON	XFELD	CHAR	1	0	Indicator: Supplement for automatic postings ?
31	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
32	XSPEBSKB1	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
33	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
34	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
35	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
36	ALTKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code
37	XMITK	☐	XMITK	XFELD	CHAR	1	0	Indicator: Reconcil.acct ready for input at time of posting?
38	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
39	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item
40	XMWNO	☐	XMWNO	XFELD	CHAR	1	0	Indicator: Tax code is not a required field
41	XSALH	☐	XSALH	XFELD	CHAR	1	0	Indicator: Only Manage Balances in Local Currency
42	BEWGP	☐	BEWGP	CHAR10	CHAR	10	0	Valuation Group
43	INFKY	☐	J_1AIFSKS	J_1AIFSKS	CHAR	8	0	Inflation Key	J_1AINFSKS
44	TOGRU	☐	TOGRU_S	TOGRU	CHAR	4	0	Tolerance Group for G/L Accounts	T043S
45	XBILK	☐	XBILK	XFELD	CHAR	1	0	Indicator: Account is a balance sheet account?
46	SAKAN	☐	SAKAN	CHAR10	CHAR	10	0	G/L account number, significant length
47	BILKT	☐	BILKT	SAKNR	CHAR	10	0	Group Account Number	SKA1
48	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
49	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
50	GVTYP	☐	GVTYP	CHAR2	CHAR	2	0	P&L statement account type
51	KTOKS	☐	KTOKS	KTOKS	CHAR	4	0	G/L Account Group	T077S
52	MUSTR	☐	MUSTR	MUSTR	CHAR	10	0	Number of the sample account	SKM1
53	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
54	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
55	XSPEA	☐	XSPEA	XFELD	CHAR	1	0	Indicator: account is blocked for creation ?
56	XSPEB	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
57	XSPEP	☐	XSPEP	XFELD	CHAR	1	0	Indicator: account blocked for planning ?
58	MCOD1	☐	MCODF	CHAR25	CHAR	25	0	Search Term for Using Matchcode
59	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TIVEXFIACC	BILKT	SKA1	SAKNR	REF	C	CN
2	V_TIVEXFIACC	BUKRS	T001	BUKRS	KEY	1	CN
3	V_TIVEXFIACC	BUSAB	T001S	BUSAB	REF	C	CN
4	V_TIVEXFIACC	FDGRV	T035	GRUPP	REF	C	CN
5	V_TIVEXFIACC	FDLEV	T036	EBENE	REF	C	CN
6	V_TIVEXFIACC	FSTAG	T004F	FSTAG	REF	1	CN
7	V_TIVEXFIACC	FUNC_AREA	TFKB	FKBER	REF
8	V_TIVEXFIACC	HBKID	T012	HBKID	REF	C	CN
9	V_TIVEXFIACC	HKTID	T012K	HKTID	REF	C	CN
10	V_TIVEXFIACC	INFKY	J_1AINFSKS	J_1AIFSKS		1	CN
11	V_TIVEXFIACC	KDFSL	T030S	KDFSL	REF	C	CN
12	V_TIVEXFIACC	KTOKS	T077S	KTOKS	REF	1	CN
13	V_TIVEXFIACC	KTOPL	T004	KTOPL	KEY	1	CN
14	V_TIVEXFIACC	MANDT	T000	MANDT	KEY	1	CN
15	V_TIVEXFIACC	MUSTR	SKM1	MUSTR	REF	C	CN
16	V_TIVEXFIACC	RECID	T8JJ	RECID	REF	C	CN
17	V_TIVEXFIACC	SAKNR	SKA1	SAKNR	KEY	1	CN
18	V_TIVEXFIACC	TOGRU	T043S	TOGRU		1	CN
19	V_TIVEXFIACC	VBUND	T880	RCOMP	REF	1	CN
20	V_TIVEXFIACC	VZSKZ	T056	VZSKZ	REF	C	CN
21	V_TIVEXFIACC	WAERS	TCURC	WAERS	REF	1	CN
22	V_TIVEXFIACC	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in