AVIP SAP (Payment Advice Line Item) Table details
Dictionary Type: Table
Description: Payment Advice Line Item
Description: Payment Advice Line Item
Table field list including key, data, relationships and ABAP select examples
AVIP is a standard SAP Table which is used to store Payment Advice Line Item data and is available within R/3 SAP systems depending on the version and release level.
The AVIP table consists of various fields, each holding specific information or linking keys about Payment Advice Line Item data available in SAP. These include BUKRS (Company Code), KOART (Payment Advice Account Type), KONTO (Account Number), AVSID (Payment Advice Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AVIP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KOART | Payment Advice Account Type | KOART_AV | CHAR | 1 | KOART_AV | ||||
KONTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
AVSID | Payment Advice Number | AVSID | CHAR | 16 | AVSID | AVN | |||
AVSPO | Payment Advice Line Item | AVSPO | NUMC | 5 | AVSPO | ||||
ABWKO | Alternative Account (Payment Advice Management) | ABWKO_AV | CHAR | 10 | ALPHA | KTONR | |||
ABWBU | Alternative Company Code (Payment Advice Management) | ABWBU_AV | CHAR | 4 | T001 | BUKRS | |||
SFELD | Name of Selection Field | SFELD_AV | CHAR | 30 | Assigned to domain | FDNAME | |||
SWERT | Selection Value (Payment Advice Management) | SWERT_AV | CHAR | 30 | CHAR30 | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
RESTG | External Reason Code for Payment Differences | RSTGR_EXT | CHAR | 3 | CHAR3 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
WRBTR | Gross amount | WRBTR_AV | CURR | 13(2) | WRTV7 | ||||
NEBTR | Net Payment Amount with +/- Sign | NEBTR_AV | CURR | 13(2) | WRTV7 | ||||
WSKTO | Cash discount amount with +/- sign | WSKTO_AV | CURR | 13(2) | WRTV7 | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
ABWKA | Account Type | ABWKA_AV | CHAR | 1 | KOART_AV | ||||
ZBDXP | Selected cash discount percentage rate | DZBDXP | DEC | 5(3) | PRZ23 | ||||
ZBDXT | Selected cash discount days | DZBDXT | DEC | 3 | ZBDXT | ||||
DIFHW | Amount Difference in Local Currency | DIFHW | CURR | 13(2) | WERT7 | ||||
DIFFW | Amount Difference in Foreign Currency | DIFFW | CURR | 13(2) | WRTV7 | ||||
DIFH2 | Amount Difference in Second Local Currency | DIFH2 | CURR | 13(2) | WERT7 | ||||
DIFH3 | Amount Difference in Third Local Currency | DIFH3 | CURR | 13(2) | WERT7 | ||||
XAKTP | Indicator: Items activated ? | XAKTP | CHAR | 1 | XFELD | ||||
XAKTS | Indicator: Cash discount activated ? | XAKTS | CHAR | 1 | XFELD | ||||
XPPMT | Indicator: partial payments | XPPMT | CHAR | 1 | XFELD | ||||
XVORT | Indicator: Carryforward residual bal. for pmnt difference ? | XVORT | CHAR | 1 | XFELD | ||||
RSTGN | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
SCURR | Entry Field for Search Criteria (Amount Fields) | SCURR_AV | CURR | 13(2) | WERT7 | ||||
SDATE | Entry Field for Search Criteria (Date Fields) | SDATE_AV | DATS | 8 | DATUM | ||||
STYPE | Type of Selection Field (Character, Date, Amount) | STYPE_AV | CHAR | 1 | STYPE_AV | ||||
SPRIO | Selection Priority | SPRIO_AV | CHAR | 1 | XFELD | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
AFELD | Name of External Selection Field Specified | AFELD_AV | CHAR | 30 | Assigned to domain | FDNAME | |||
LIEFN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
REDAT | Invoice Date | REDAT | DATS | 8 | DATUM | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
XACON | Indicator: Posting on account | XACON | CHAR | 1 | XFELD | ||||
ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR | 1 | CHAR1 | ||||
XAMCA | Indicator: Do not calculate gross amount if initial? | XAMCA | CHAR | 1 | XFELD | ||||
ABBTR | Deduction amount | ABBTR_AV | CURR | 13(2) | WRTV7 | ||||
CONTR | Payment Advice Processing Control Field | CONTR_AV | CHAR | 6 | CHAR6 | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 |
Key field | Non-key field |
How do I retrieve data from SAP table AVIP using ABAP code
The following ABAP code Example will allow you to do a basic selection on AVIP to SELECT all data from the tableDATA: WA_AVIP TYPE AVIP.
SELECT SINGLE *
FROM AVIP
INTO CORRESPONDING FIELDS OF WA_AVIP
WHERE...
How to access SAP table AVIP
Within an ECC or HANA version of SAP you can also view further information about AVIP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects