SAP VIITTAXDSBASE Tax Document Item to Be Broken Down (VIITTAXDSBASE) Table
Overview
VIITTAXDSBASE is a standard SAP S/4HANA table that stores Tax Document Item to Be Broken Down (VIITTAXDSBASE) data. There are total 37 fields in the VIITTAXDSBASE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIITTAXDSBASE belongs to Input Tax Treatment (RE-FX-IT) module and is located in the package RE: Input Tax Distribution (RE_IT_DS).
In addition, following links provide an overview of foreign key relationships, if any, that link VIITTAXDSBASE to other SAP tables and standard CDS views available based on VIITTAXDSBASE table in S/4HANA 2020.
Techincal Settings of VIITTAXDSBASE
Below are technical details of the table VIITTAXDSBASE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIITTAXDSBASE Fields
The following table gives you an overview of the fields available in VIITTAXDSBASE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| DOCGUID | GUID: Unique Internal Key for Tax Document | REITDOCGUID | RAW | 16 | |
| ITEMNO | Internal Item Number for Tax Document Item | REITITEMNO | NUMC | 10 | |
| REFDOCTYPE | Reference to Document Class | RERAREFDOCTYPE | * | CHAR | 5 |
| REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | |
| REFITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | |
| ACCSYSTEM | Definition of Accounting System | RERAACCSYSTEM | TIVRAACCSYSTEM | CHAR | 4 |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR | 10 |
| REVDOCID | Reference Key of Reversal Document | RERAREVDOCID | CHAR | 20 | |
| STATUS | Tax Breakdown Status | REITDSSTATUS | CHAR | 1 | |
| FISCALYEAR | Fiscal Year | GJAHR | NUMC | 4 | |
| PSTNGPERIOD | Posting Period | RERAPSTNGPERIOD | NUMC | 2 | |
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| OBJNR | ID of Object for which Option Rate Was Determined | REITOBJNR | * | CHAR | 22 |
| REFDATE | Reference date for settlement | DABRBEZ | DATS | 8 | |
| DCINDICATOR | Debit/Credit Indicator | RERADCINDICATOR | CHAR | 1 | |
| COSTACCOUNT | Cost Account in G/L Accounting | REITCOSTACCOUNT | CHAR | 15 | |
| TAXTYPE | Tax Type | RERATAXTYPE | * | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TAXACCOUNT | Tax Account of General Ledger Accounting | REITTAXACCOUNT | CHAR | 15 | |
| OBJNROPTRATE | ID of Object from Which the Option Rate Was Read | REITOBJNROPTRATE | * | CHAR | 22 |
| NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15 | |
| DEDTAXAMT | Deductible Tax Amount | RERADEDTAXAMT | CURR | 15 | |
| NONDEDTAXAMT | Non-Deductible Tax Amount | RERANONDEDTAXAMT | CURR | 15 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| TCOBJNR | Object Number Correction Object | REITTCOBJNR | * | CHAR | 22 |
| DATEOFSERVICE | Date of Service | REITTCDATEOFSERVICE | DATS | 8 | |
| HASDIFFOPTRATE | Has Differing Option Rate | REITHASDIFFOPTRATE | CHAR | 1 | |
| DIFFOPTRATE | Differing Option Rate for Distribution | REITDIFFOPTRATE | DEC | 9 | |
| NOTAXCORR | Do Not Consider Item in Input Tax Correction | REITNOTAXCORR | CHAR | 1 | |
| AMTRANSTYPE | Transaction Type of Asset Postings | REITAMTRANSTYPE | * | CHAR | 3 |
| POREFDOCID | Reference Document Number of Purchase Order | REEXPOREFDOCID | CHAR | 20 | |
| POREFITEMNO | Number of Purchase Order Item | REEXPOREFITEMNO | NUMC | 10 | |
| TCBASEGUID | GUID for Basis for Input Tax Correction | REITTCBASEGUID | RAW | 16 | |
| TAXCOUNTRY | Alternative Tax Reporting Country | RERATAXCOUNTRY | * | CHAR | 3 |
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 VIITTAXDSBASE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIITTAXDSBASE | ACCSYSTEM | 1: CN | TIVRAACCSYSTEM |
| VIITTAXDSBASE | TAXGROUP | 1: CN | TIVRATAXGROUP |