Monday, March 4, 2024

SAP Table AVIR – Payment Advice Subitem

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