1. Home
  2. Resources
  3. SAP Tables
  4. AVIP_LST - Payment Advice Note Item for ALV List

SAP Table AVIP_LST

Payment Advice Note Item for ALV List

AVIP_LST (Payment Advice Note Item for ALV List) 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_LST to other SAP tables.

AVIP_LST 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
FTEXT Selection Field Name FTEXT_AV CHAR 20 0
ATEXT Field Name of External Selection Field ATEXT_AV CHAR 20 0
FAEDT Net Due Date FAEDT_FPOS DATS 8 0

AVIP_LST foreign key relationships

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