SAP AVIR Payment Advice Subitem Table
Overview
AVIR is a standard SAP S/4HANA table that stores Payment Advice Subitem data. There are total 13 fields in the AVIR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AVIR belongs to Financial Accounting (FI) module and is located in the package Financial Accounting "Basis" (FBAS).
In addition, following links provide an overview of foreign key relationships, if any, that link AVIR to other SAP tables and standard CDS views available based on AVIR table in S/4HANA 2020.
Techincal Settings of AVIR
Below are technical details of the table AVIR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AVIR Fields
The following table gives you an overview of the fields available in AVIR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| KOART | Payment Advice Account Type | KOART_AV | CHAR | 1 | |
| KONTO | Account Number | KTONR_AV | CHAR | 10 | |
| AVSID | Payment Advice Number | AVSID | CHAR | 16 | |
| AVSPO | Payment Advice Item | AVSPO | NUMC | 5 | |
| AVSUP | Payment Advice Subitem | AVSUP | NUMC | 5 | |
| RESTN | Net Deduction Amount | RESTN_AV | CURR | 23 | |
| RESTB | Gross Deduction Amount | RESTB_AV | CURR | 23 | |
| RSTGR | Reason Code for Payments | RSTGR | T053R | CHAR | 3 |
| XREF1 | Business Partner Reference Key | XREF1 | CHAR | 12 | |
| XREF2 | Business Partner Reference Key | XREF2 | CHAR | 12 | |
| RESTG | External Reason Code for Payment Differences | RSTGR_EXT | 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 AVIR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AVIR | BUKRS | 1: CN | T001 |
| AVIR | RSTGR | C: CN | T053R |