AVIR is a standard SAP table in SAP ERP (or) S/4HANA which stores Payment Advice Subitem data. There are total 13 fields in AVIR table.This blog post provides key technical details of SAP table AVIR, including its availability across SAP S/4HANA versions and the list of CDS views for AVIR table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Financial Accounting “Basis” (FBAS) |
| Technical Component | Financial Accounting (FI) |
SAP AVIR Table Fields
The following is the list of fields that are available in SAP AVIR table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| BUKRS | Company Code | BUKRS | BUKRS | T001 | CHAR (4) |
| KOART | Payment Advice Account Type | KOART_AV | KOART_AV | CHAR (1) | |
| KONTO | Account Number | KTONR_AV | KTONR | CHAR (10) | |
| AVSID | Payment Advice Number | AVSID | AVSID | CHAR (16) | |
| AVSPO | Payment Advice Item | AVSPO | AVSPO | NUMC (5) | |
| AVSUP | Payment Advice Subitem | AVSUP | AVSPO | NUMC (5) | |
| RESTN | Net Deduction Amount | RESTN_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| RESTB | Gross Deduction Amount | RESTB_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| RSTGR | Reason Code for Payments | RSTGR | RSTGR | T053R | CHAR (3) |
| XREF1 | Business Partner Reference Key | XREF1 | CHAR12 | CHAR (12) | |
| XREF2 | Business Partner Reference Key | XREF2 | CHAR12 | CHAR (12) | |
| RESTG | External Reason Code for Payment Differences | RSTGR_EXT | CHAR3 | CHAR (3) |
Availability
The SAP table AVIR is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AVIR table
The following is the list of AVIR CDS views, which can also be used instead of AVIR table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_PAYMENTADVICESUBITEM | BASIC | Payment Advice SubItem |
| P_PAYMENTADVICESUBITEM | COMPOSITE | Payment Advice Subitem |
| C_PAYMENTADVICEITEM | CONSUMPTION | Payment Advice Item |
| C_PAYMENTADVICESUBITEM | CONSUMPTION | Payment Advice Subitem |
