SAP VIXCAOSAFTI SAF-T AO: RE-FX Invoices Items Table
Overview
VIXCAOSAFTI is a standard SAP S/4HANA table that stores SAF-T AO: RE-FX Invoices Items data. There are total 31 fields in the VIXCAOSAFTI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIXCAOSAFTI belongs to Real Estate Localization (RE-FX-LC) module and is located in the package Localization Flexible Real Estate Angola (GLO_REFX_AO).
In addition, following links provide an overview of foreign key relationships, if any, that link VIXCAOSAFTI to other SAP tables and standard CDS views available based on VIXCAOSAFTI table in S/4HANA 2020.
Techincal Settings of VIXCAOSAFTI
Below are technical details of the table VIXCAOSAFTI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIXCAOSAFTI Fields
The following table gives you an overview of the fields available in VIXCAOSAFTI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| EXTRACTION_ID | SAF-T Extraction ID | SAFTN_EXTRACTION_ID | CHAR | 32 | |
| INVGUID | GUID: Unique Internal Key for RE Invoice | RERAINVGUID | VIRAINV | RAW | 16 |
| ITEMNO | Item Number in RE Invoice | RERAINVITEMNO | NUMC | 10 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | |
| BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| CALCFROM | Start of Calculation Period | DBERVON | DATS | 8 | |
| CALCTO | End of Calculation Period | DBERBIS | DATS | 8 | |
| CURRENCY | Local Currency | RECACTLCCURRKEY | CUKY | 5 | |
| GROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| NETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | |
| TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | |
| TAXDATE | Date of Tax Calculation | RERATAXDATE | DATS | 8 | |
| XMACCTSHEETITEM | Name of Contract Account Sheet Item | RERAXLACCTSHEETITEM | CHAR | 60 | |
| DOCITEMID | Coded Key of FI Document Item for RE Internal Use | RERADOCITEMID | CHAR | 30 | |
| REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | |
| REFITEMNO | Reference to Other Item Number of Document | RERAREFITEMNO | NUMC | 10 | |
| LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | |
| OBJ_TYPE | Reference procedure | AWTYP | CHAR | 5 | |
| OBJ_KEY | Object key | AWKEY | CHAR | 20 | |
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | |
| DOCDATE | Document Date | RERADOCDATE | DATS | 8 | |
| XMACCTSHEETHDR | Name from Document Header | RERAXLACCTSHEETHDR | CHAR | 60 | |
| FCCURRKEY | Foreign Currency | RECACTFCCURRKEY | CUKY | 5 | |
| FCGROSSAMOUNT | Gross Amount in Foreign Currency | RECACTFCGROSSAMOUNT | CURR | 15 | |
| FCNETAMOUNT | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15 | |
| FCTAXAMOUNT | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15 | |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 |
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 VIXCAOSAFTI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIXCAOSAFTI | INVGUID | 1: N | VIRAINV |