SAP AVIP Payment Advice Line Item Table
Overview
AVIP is a standard SAP S/4HANA table that stores Payment Advice Line Item data. There are total 55 fields in the AVIP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AVIP 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 AVIP to other SAP tables and standard CDS views available based on AVIP table in S/4HANA 2020.
Techincal Settings of AVIP
Below are technical details of the table AVIP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AVIP Fields
The following table gives you an overview of the fields available in AVIP
| 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 | |
| ABWKO | Alternative Account (Payment Advice Management) | ABWKO_AV | CHAR | 10 | |
| ABWBU | Alternative Company Code (Payment Advice Management) | ABWBU_AV | T001 | CHAR | 4 |
| SFELD | Name of Selection Field | SFELD_AV | CHAR | 30 | |
| SWERT | Selection Value (Payment Advice Management) | SWERT_AV | CHAR | 30 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | |
| VBELN | Billing Document | VBELN_VF | CHAR | 10 | |
| FILKD | Account Number of the Branch | FILKD | CHAR | 10 | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| RESTG | External Reason Code for Payment Differences | RSTGR_EXT | CHAR | 3 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 23 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| WRBTR | Gross Amount | WRBTR_AV | CURR | 23 | |
| NEBTR | Net Payment Amount with +/- Sign | NEBTR_AV | CURR | 23 | |
| WSKTO | Cash Discount Amount with +/- Sign | WSKTO_AV | CURR | 23 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| ABWKA | Account Type | ABWKA_AV | CHAR | 1 | |
| ZBDXP | Selected cash discount percentage rate | DZBDXP | DEC | 5 | |
| ZBDXT | Selected cash discount days | DZBDXT | DEC | 3 | |
| DIFHW | Amount Difference in Local Currency | DIFHW | CURR | 23 | |
| DIFFW | Amount Difference in Foreign Currency | DIFFW | CURR | 23 | |
| DIFH2 | Amount Difference in Second Local Currency | DIFH2 | CURR | 23 | |
| DIFH3 | Amount Difference in Third Local Currency | DIFH3 | CURR | 23 | |
| XAKTP | Indicator: Items Activated? | XAKTP | CHAR | 1 | |
| XAKTS | Indicator: Cash Discount Activated? | XAKTS | CHAR | 1 | |
| XPPMT | Indicator: Partial Payments | XPPMT | CHAR | 1 | |
| XVORT | Indicator: Carryforward Residual Bal. for Payt Difference? | XVORT | CHAR | 1 | |
| RSTGN | Reason Code for Payments | RSTGR | T053R | CHAR | 3 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| SCURR | Entry Field for Search Criteria (Amount Fields) | SCURR_AV | CURR | 23 | |
| SDATE | Entry Field for Search Criteria (Date Fields) | SDATE_AV | DATS | 8 | |
| STYPE | Type of Selection Field (Character, Date, Amount) | STYPE_AV | CHAR | 1 | |
| SPRIO | Selection Priority | SPRIO_AV | CHAR | 1 | |
| XREF1 | Business Partner Reference Key | XREF1 | CHAR | 12 | |
| XREF2 | Business Partner Reference Key | XREF2 | CHAR | 12 | |
| AFELD | Name of External Selection Field Specified | AFELD_AV | CHAR | 30 | |
| LIEFN | Delivery | VBELN_VL | CHAR | 10 | |
| REDAT | Invoice Date | REDAT | DATS | 8 | |
| BSTNK | Customer Reference | BSTNK | CHAR | 20 | |
| XACON | Indicator: Posting on Account | XACON | CHAR | 1 | |
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR | 1 | |
| XAMCA | Indicator: Do Not Calculate Gross Amount if Initial? | XAMCA | CHAR | 1 | |
| ABBTR | Deduction Amount | ABBTR_AV | CURR | 23 | |
| CONTR | Payment Advice Processing Control Field | CONTR_AV | CHAR | 6 | |
| KIDNO | Payment Reference | KIDNO | CHAR | 30 |
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 AVIP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AVIP | ABWBU | C: CN | T001 |
| AVIP | BUKRS | 1: CN | T001 |
| AVIP | GSBER | C: CN | TGSB |
| AVIP | MWSKZ | C: CN | T007A |
| AVIP | RSTGN | C: CN | T053R |
| AVIP | WAERS | C: CN | TCURC |