AVIP - Payment Advice Line Item

Payment Advice Line Item information is stored in SAP table AVIP.
It is part of development package FBAS in software component FI. This development package consists of objects that can be grouped under "Financial Accounting "Basis"".

Fields for table AVIP

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
KOART	Payment Advice Account Type	X	KOART_AV	CHAR	2
KONTO	Account Number	X	KTONR_AV	CHAR	20
AVSID	Payment Advice Number	X	AVSID	CHAR	32
AVSPO	Payment Advice Item	X	AVSPO	NUMC	10
ABWKO	Alternative Account (Payment Advice Management)		ABWKO_AV	CHAR	20
ABWBU	Alternative Company Code (Payment Advice Management)		ABWBU_AV	CHAR	8	T001
SFELD	Name of Selection Field		SFELD_AV	CHAR	60
SWERT	Selection Value (Payment Advice Management)		SWERT_AV	CHAR	60
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
XBLNR	Reference Document Number		XBLNR1	CHAR	32
VBELN	Billing Document		VBELN_VF	CHAR	20
FILKD	Account Number of the Branch		FILKD	CHAR	20
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
GSBER	Business Area		GSBER	CHAR	8	TGSB
RESTG	External Reason Code for Payment Differences		RSTGR_EXT	CHAR	6
SGTXT	Item Text		SGTXT	CHAR	100
MWSTS	Tax Amount in Local Currency		MWSTS	CURR	12
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	T007A
WRBTR	Gross Amount		WRBTR_AV	CURR	12
NEBTR	Net Payment Amount with +/- Sign		NEBTR_AV	CURR	12
WSKTO	Cash Discount Amount with +/- Sign		WSKTO_AV	CURR	12
GJAHR	Fiscal Year		GJAHR	NUMC	8
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
ABWKA	Account Type		ABWKA_AV	CHAR	2
DIFHW	Amount Difference in Local Currency		DIFHW	CURR	12
DIFFW	Amount Difference in Foreign Currency		DIFFW	CURR	12
DIFH2	Amount Difference in Second Local Currency		DIFH2	CURR	12
DIFH3	Amount Difference in Third Local Currency		DIFH3	CURR	12
XAKTP	Indicator: Items Activated?		XAKTP	CHAR	2
XAKTS	Indicator: Cash Discount Activated?		XAKTS	CHAR	2
XPPMT	Indicator: Partial Payments		XPPMT	CHAR	2
XVORT	Indicator: Carryforward Residual Bal. for Payt Difference?		XVORT	CHAR	2
RSTGN	Reason Code for Payments		RSTGR	CHAR	6	T053R
WAERS	Currency Key		WAERS	CUKY	10	TCURC
SCURR	Entry Field for Search Criteria (Amount Fields)		SCURR_AV	CURR	12
SDATE	Entry Field for Search Criteria (Date Fields)		SDATE_AV	DATS	16
STYPE	Type of Selection Field (Character, Date, Amount)		STYPE_AV	CHAR	2
SPRIO	Selection Priority		SPRIO_AV	CHAR	2
XREF1	Business Partner Reference Key		XREF1	CHAR	24
XREF2	Business Partner Reference Key		XREF2	CHAR	24
AFELD	Name of External Selection Field Specified		AFELD_AV	CHAR	60
LIEFN	Delivery		VBELN_VL	CHAR	20
REDAT	Invoice Date		REDAT	DATS	16
BSTNK	Customer Reference		BSTNK	CHAR	40
XACON	Indicator: Posting on Account		XACON	CHAR	2
ASTAT	Payment Advice Status		ASTAT_AVIK	CHAR	2
XAMCA	Indicator: Do Not Calculate Gross Amount if Initial?		XAMCA	CHAR	2
ABBTR	Deduction Amount		ABBTR_AV	CURR	12
CONTR	Payment Advice Processing Control Field		CONTR_AV	CHAR	12
KIDNO	Payment Reference		KIDNO	CHAR	60