AVIP is a standard SAP table in SAP ERP (or) S/4HANA which stores Payment Advice Line Item data. There are total 55 fields in AVIP table.This blog post provides key technical details of SAP table AVIP, including its availability across SAP S/4HANA versions and the list of CDS views for AVIP 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 AVIP Table Fields
The following is the list of fields that are available in SAP AVIP 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) | |
| ABWKO | Alternative Account (Payment Advice Management) | ABWKO_AV | KTONR | CHAR (10) | |
| ABWBU | Alternative Company Code (Payment Advice Management) | ABWBU_AV | BUKRS | T001 | CHAR (4) |
| SFELD | Name of Selection Field | SFELD_AV | FDNAME | CHAR (30) | |
| SWERT | Selection Value (Payment Advice Management) | SWERT_AV | CHAR30 | CHAR (30) | |
| BELNR | Accounting Document Number | BELNR_D | BELNR | CHAR (10) | |
| XBLNR | Reference Document Number | XBLNR1 | XBLNR1 | CHAR (16) | |
| VBELN | Billing Document | VBELN_VF | VBELN | CHAR (10) | |
| FILKD | Account Number of the Branch | FILKD | MAXKK | CHAR (10) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATUM | DATS (8) | |
| GSBER | Business Area | GSBER | GSBER | TGSB | CHAR (4) |
| ZUONR | Assignment number | DZUONR | ZUONR | CHAR (18) | |
| RESTG | External Reason Code for Payment Differences | RSTGR_EXT | CHAR3 | CHAR (3) | |
| SGTXT | Item Text | SGTXT | TEXT50 | CHAR (50) | |
| MWSTS | Tax Amount in Local Currency | MWSTS | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ | T007A | CHAR (2) |
| WRBTR | Gross Amount | WRBTR_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| NEBTR | Net Payment Amount with +/- Sign | NEBTR_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| WSKTO | Cash Discount Amount with +/- Sign | WSKTO_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| GJAHR | Fiscal Year | GJAHR | GJAHR | NUMC (4) | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI | NUMC (3) | |
| ABWKA | Account Type | ABWKA_AV | KOART_AV | CHAR (1) | |
| ZBDXP | Selected cash discount percentage rate | DZBDXP | PRZ23 | DEC (5) | |
| ZBDXT | Selected cash discount days | DZBDXT | ZBDXT | DEC (3) | |
| DIFHW | Amount Difference in Local Currency | DIFHW | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| DIFFW | Amount Difference in Foreign Currency | DIFFW | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| DIFH2 | Amount Difference in Second Local Currency | DIFH2 | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| DIFH3 | Amount Difference in Third Local Currency | DIFH3 | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| XAKTP | Indicator: Items Activated? | XAKTP | XFELD | CHAR (1) | |
| XAKTS | Indicator: Cash Discount Activated? | XAKTS | XFELD | CHAR (1) | |
| XPPMT | Indicator: Partial Payments | XPPMT | XFELD | CHAR (1) | |
| XVORT | Indicator: Carryforward Residual Bal. for Payt Difference? | XVORT | XFELD | CHAR (1) | |
| RSTGN | Reason Code for Payments | RSTGR | RSTGR | T053R | CHAR (3) |
| WAERS | Currency Key | WAERS | WAERS | TCURC | CUKY (5) |
| SCURR | Entry Field for Search Criteria (Amount Fields) | SCURR_AV | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| SDATE | Entry Field for Search Criteria (Date Fields) | SDATE_AV | DATUM | DATS (8) | |
| STYPE | Type of Selection Field (Character, Date, Amount) | STYPE_AV | STYPE_AV | CHAR (1) | |
| SPRIO | Selection Priority | SPRIO_AV | XFELD | CHAR (1) | |
| XREF1 | Business Partner Reference Key | XREF1 | CHAR12 | CHAR (12) | |
| XREF2 | Business Partner Reference Key | XREF2 | CHAR12 | CHAR (12) | |
| AFELD | Name of External Selection Field Specified | AFELD_AV | FDNAME | CHAR (30) | |
| LIEFN | Delivery | VBELN_VL | VBELN | CHAR (10) | |
| REDAT | Invoice Date | REDAT | DATUM | DATS (8) | |
| BSTNK | Customer Reference | BSTNK | BSTNK | CHAR (20) | |
| XACON | Indicator: Posting on Account | XACON | XFELD | CHAR (1) | |
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR1 | CHAR (1) | |
| XAMCA | Indicator: Do Not Calculate Gross Amount if Initial? | XAMCA | XFELD | CHAR (1) | |
| ABBTR | Deduction Amount | ABBTR_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| CONTR | Payment Advice Processing Control Field | CONTR_AV | CHAR6 | CHAR (6) | |
| KIDNO | Payment Reference | KIDNO | CHAR30 | CHAR (30) |
Availability
The SAP table AVIP 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 AVIP table
The following is the list of AVIP CDS views, which can also be used instead of AVIP table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| A_PAYMENTADVICEITEM | BASIC | Payment Advice Line Item |
| I_PAYMENTADVICEITEM | BASIC | Payment Advice Item |
| I_PAYMENTADVICESUBITEM | BASIC | Payment Advice SubItem |
| P_ARBSITMPAYADVICE | BASIC | Payment Advice for Machine Learning |
| I_PAYTADVICEITEMFROMASSIGNMENT | COMPOSITE | Payment advice items created from assignment |
| P_PAYMENTADVICEITEM | COMPOSITE | Payment Advice Item |
| P_PAYMENTADVICESUBITEM | COMPOSITE | Payment Advice Subitem |
| C_CREDITOPENITEM | CONSUMPTION | Credit Open Items |
| C_DEBITOPENITEM | CONSUMPTION | Debit Open Items |
| C_PAYMENTADVICEITEM | CONSUMPTION | Payment Advice Item |
| C_PAYMENTADVICESUBITEM | CONSUMPTION | Payment Advice Subitem |
