Menu

SAP Table AVIP

Payment Advice Line Item

The table AVIP (Payment Advice Line Item) is a standard table in SAP ERP. It belongs to the package FBAS.

Technical Information

Table AVIP
Short Text Payment Advice Line Item
Package FBAS
Table Type Transparent Table

Fields for Table AVIP

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
BUKRS Company Code BUKRS CHAR 4 T001
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 Line Item AVSPO NUMC 5
ABWKO Alternative Account (Payment Advice Management) ABWKO_AV CHAR 10
ABWBU Alternative Company Code (Payment Advice Management) ABWBU_AV CHAR 4 T001
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 CHAR 4 TGSB
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 13
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 T007A
WRBTR Gross amount WRBTR_AV CURR 13
NEBTR Net Payment Amount with +/- Sign NEBTR_AV CURR 13
WSKTO Cash discount amount with +/- sign WSKTO_AV CURR 13
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 13
DIFFW Amount Difference in Foreign Currency DIFFW CURR 13
DIFH2 Amount Difference in Second Local Currency DIFH2 CURR 13
DIFH3 Amount Difference in Third Local Currency DIFH3 CURR 13
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 pmnt difference ? XVORT CHAR 1
RSTGN Reason Code for Payments RSTGR CHAR 3 T053R
WAERS Currency Key WAERS CUKY 5 TCURC
SCURR Entry Field for Search Criteria (Amount Fields) SCURR_AV CURR 13
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 purchase order number 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 13
CONTR Payment Advice Processing Control Field CONTR_AV CHAR 6
KIDNO Payment Reference KIDNO CHAR 30