SAP VIVSTB Document reference for input tax treatment Table
Overview
VIVSTB is a standard SAP S/4HANA table that stores Document reference for input tax treatment data. There are total 38 fields in the VIVSTB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIVSTB belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIVSTB to other SAP tables and standard CDS views available based on VIVSTB table in S/4HANA 2020.
Techincal Settings of VIVSTB
Below are technical details of the table VIVSTB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIVSTB Fields
The following table gives you an overview of the fields available in VIVSTB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| VBELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| BGJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| VBUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| WMWST | Tax Amount in Document Currency | WMWST_CS | CURR | 13 | |
| AKONTO | Tax account | VVVSTKTO | CHAR | 10 | |
| STFLG | Reverse document indicator | IV_STFLG | CHAR | 1 | |
| STOKZ | Document Has Been Reversed | IV_STOKZ | CHAR | 1 | |
| POPTS | Real Estate Option Rate | POPTSATZ | DEC | 9 | |
| SOLLID | No. of debit position in fiscal year | VVSSOLLID | NUMC | 8 | |
| SVORG | Automatic Posting Run Activity | VVSVORG | CHAR | 4 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| STBLG | Reverse Document Number | STBLG | CHAR | 10 | |
| STJAH | Fiscal Year of Reversal Document | STJAH | NUMC | 4 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| MWSTS | Tax Amount in Local Currency | MWSTS_CS | CURR | 13 | |
| MONAT | Fiscal period | MONAT | NUMC | 2 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| MWART | Tax Type | MWART | CHAR | 1 | |
| VNAVHW | Non-Deductible Input Tax (in Local Currency) | NAVHW_CS | CURR | 13 | |
| VNAVFW | Non-Deductible Input Tax (in Document Currency) | NAVFW_CS | CURR | 13 | |
| HKONT | General Ledger Account | HKONT | CHAR | 10 | |
| NASAKNR | Acct for non-deductible input tax | NASAKNR | CHAR | 10 | |
| RARTOPT | Option rate calculation type | RARTOPT | NUMC | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIVSTB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIVSTB | MWSKZ | : | T007A |
| VIVSTB | WAERS | : | TCURC |