1. Home
  2. Resources
  3. SAP Tables
  4. AVIP - Payment Advice Line Item

SAP Table AVIP

Payment Advice Line Item

AVIP (Payment Advice Line Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AVIP to other SAP tables.

AVIP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
KOART Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
KONTO Account Number KTONR_AV CHAR 10 0
AVSID Payment Advice Number AVSID CHAR 16 0
AVSPO Payment Advice Line Item AVSPO NUMC 5 0
ABWKO Alternative Account (Payment Advice Management) ABWKO_AV CHAR 10 0
ABWBU Alternative Company Code (Payment Advice Management) ABWBU_AV T001 CHAR 4 0
SFELD Name of Selection Field SFELD_AV CHAR 30 0
SWERT Selection Value (Payment Advice Management) SWERT_AV CHAR 30 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
VBELN Billing Document VBELN_VF CHAR 10 0
FILKD Account Number of the Branch FILKD CHAR 10 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
GSBER Business Area GSBER TGSB CHAR 4 0
ZUONR Assignment Number DZUONR CHAR 18 0
RESTG External Reason Code for Payment Differences RSTGR_EXT CHAR 3 0
SGTXT Item Text SGTXT CHAR 50 0
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
WRBTR Gross amount WRBTR_AV CURR 13 2
NEBTR Net Payment Amount with +/- Sign NEBTR_AV CURR 13 2
WSKTO Cash discount amount with +/- sign WSKTO_AV CURR 13 2
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
ABWKA Account Type ABWKA_AV CHAR 1 0
D Customer
K Vendor
S G/L account
ZBDXP Selected cash discount percentage rate DZBDXP DEC 5 3
ZBDXT Selected cash discount days DZBDXT DEC 3 0
DIFHW Amount Difference in Local Currency DIFHW CURR 13 2
DIFFW Amount Difference in Foreign Currency DIFFW CURR 13 2
DIFH2 Amount Difference in Second Local Currency DIFH2 CURR 13 2
DIFH3 Amount Difference in Third Local Currency DIFH3 CURR 13 2
XAKTP Indicator: Items activated ? XAKTP CHAR 1 0
X Yes
NULL No
XAKTS Indicator: Cash discount activated ? XAKTS CHAR 1 0
X Yes
NULL No
XPPMT Indicator: partial payments XPPMT CHAR 1 0
X Yes
NULL No
XVORT Indicator: Carryforward residual bal. for pmnt difference ? XVORT CHAR 1 0
X Yes
NULL No
RSTGN Reason Code for Payments RSTGR T053R CHAR 3 0
WAERS Currency Key WAERS TCURC CUKY 5 0
SCURR Entry Field for Search Criteria (Amount Fields) SCURR_AV CURR 13 2
SDATE Entry Field for Search Criteria (Date Fields) SDATE_AV DATS 8 0
STYPE Type of Selection Field (Character, Date, Amount) STYPE_AV CHAR 1 0
SPRIO Selection Priority SPRIO_AV CHAR 1 0
X Yes
NULL No
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
AFELD Name of External Selection Field Specified AFELD_AV CHAR 30 0
LIEFN Delivery VBELN_VL CHAR 10 0
REDAT Invoice Date REDAT DATS 8 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
XACON Indicator: Posting on account XACON CHAR 1 0
X Yes
NULL No
ASTAT Payment Advice Status ASTAT_AVIK CHAR 1 0
XAMCA Indicator: Do not calculate gross amount if initial? XAMCA CHAR 1 0
X Yes
NULL No
ABBTR Deduction amount ABBTR_AV CURR 13 2
CONTR Payment Advice Processing Control Field CONTR_AV CHAR 6 0
KIDNO Payment Reference KIDNO CHAR 30 0

AVIP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AVIP ABWBU AVIP MANDT T001 Company Codes MANDT
AVIP ABWBU AVIP ABWBU T001 Company Codes BUKRS
AVIP BUKRS AVIP MANDT T001 Company Codes MANDT
AVIP BUKRS AVIP BUKRS T001 Company Codes BUKRS
AVIP GSBER AVIP MANDT TGSB Business Areas MANDT
AVIP GSBER AVIP GSBER TGSB Business Areas GSBER
AVIP MWSKZ AVIP MANDT T007A Tax Keys MANDT
AVIP MWSKZ T005 KALSM T007A Tax Keys KALSM
AVIP MWSKZ AVIP MWSKZ T007A Tax Keys MWSKZ
AVIP RSTGN AVIP MANDT T053R Classification of Payment Differences MANDT
AVIP RSTGN AVIP ABWBU T053R Classification of Payment Differences BUKRS
AVIP RSTGN AVIP RSTGN T053R Classification of Payment Differences RSTGR
AVIP WAERS AVIP MANDT TCURC Currency Codes MANDT
AVIP WAERS AVIP WAERS TCURC Currency Codes WAERS