The AVIR table in SAP ERP or S/4HANA stores Payment Advice Subitem data. There are total 13 fields in AVIR table. The Payment Advice Subitem table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AVIR table. It is in Financial Accounting “Basis” (FBAS) ABAP package and is part of the Financial Accounting (FI) module.
SAP AVIR Table Fields
Following is the list of fields that are available in SAP AVIR table. The primary key fields of the table are MANDT (Client), BUKRS (Company Code), KOART (Payment Advice Account Type), KONTO (Account Number), AVSID (Payment Advice Number), AVSPO (Payment Advice Item), AVSUP (Payment Advice Subitem).
Field | Description | Data Element | Check Table | Data Type |
---|---|---|---|---|
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) |