SAP ABAP Table VIVSTB (Document reference for input tax treatment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIVSTB	Table Relationship Diagram
Short Description	Document reference for input tax treatment

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	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	VBELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	BGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	VBUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
11	AKONTO	☐	VVVSTKTO	SAKNR	CHAR	10	0	Tax account	*
12	STFLG	☐	IV_STFLG	FLAG	CHAR	1	0	Reverse document indicator
13	STOKZ	☐	IV_STOKZ	FLAG	CHAR	1	0	Indicator: Document has been reversed
14	POPTS	☐	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
15	SOLLID	☐	VVSSOLLID	VVSSOLLID	NUMC	8	0	No. of debit position in fiscal year
16	SVORG	☐	VVSVORG	VVSVORG	CHAR	4	0	Automatic Posting Run Activity
17	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
18	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
19	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
20	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
21	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
22	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
23	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
24	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
25	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
26	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
27	STBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
28	STJAH	☐	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year
29	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
30	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
31	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
32	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
33	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
34	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
35	VNAVHW	☐	NAVHW	WERT7	CURR	13	2	Non-Deductible Input Tax (in Local Currency)
36	VNAVFW	☐	NAVFW	WERT7	CURR	13	2	Non-Deductible Input Tax (in Document Currency)
37	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
38	NASAKNR	☐	NASAKNR	SAKNR	CHAR	10	0	Acct for non-deductible input tax	*
39	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIVSTB	MWSKZ	T007A	MWSKZ
2	VIVSTB	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in