SAP TABLES | Financial Accounting(FI) SAP FI

AVIP SAP Payment Advice Line Item Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP AVIP Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP AVIP Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4 T001Company Code
KOARTKOART_AVCHAR1 Payment Advice Account Type
KONTOKTONR_AVCHAR10 Account NumberALPHA
AVSIDAVSIDCHAR16 Payment Advice Number
AVSPOAVSPONUMC5 Payment Advice Line Item
ABWKOABWKO_AVCHAR10 Alternative Account (Payment Advice Management)ALPHA
ABWBUABWBU_AVCHAR4 T001Alternative Company Code (Payment Advice Management)
SFELDSFELD_AVCHAR30
*
Name of Selection Field
SWERTSWERT_AVCHAR30 Selection Value (Payment Advice Management)
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
XBLNRXBLNR1CHAR16 Reference Document Number
VBELNVBELN_VFCHAR10
*
Billing DocumentALPHA
FILKDFILKDCHAR10 Account Number of the BranchALPHA
CPUDTCPUDTDATS8 Day On Which Accounting Document Was Entered
GSBERGSBERCHAR4 TGSBBusiness Area
ZUONRDZUONRCHAR18 Assignment Number
RESTGRSTGR_EXTCHAR3 External Reason Code for Payment Differences
SGTXTSGTXTCHAR50 Item Text
MWSTSMWSTSCURR13(2) Tax Amount in Local Currency
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
WRBTRWRBTR_AVCURR13(2) Gross amount
NEBTRNEBTR_AVCURR13(2) Net Payment Amount with +/- Sign
WSKTOWSKTO_AVCURR13(2) Cash discount amount with +/- sign
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
ABWKAABWKA_AVCHAR1 Account Type
ZBDXPDZBDXPDEC5(3) Selected cash discount percentage rate
ZBDXTDZBDXTDEC3 Selected cash discount days
DIFHWDIFHWCURR13(2) Amount Difference in Local Currency
DIFFWDIFFWCURR13(2) Amount Difference in Foreign Currency
DIFH2DIFH2CURR13(2) Amount Difference in Second Local Currency
DIFH3DIFH3CURR13(2) Amount Difference in Third Local Currency
XAKTPXAKTPCHAR1 Indicator: Items activated ?
XAKTSXAKTSCHAR1 Indicator: Cash discount activated ?
XPPMTXPPMTCHAR1 Indicator: partial payments
XVORTXVORTCHAR1 Indicator: Carryforward residual bal. for pmnt difference ?
RSTGNRSTGRCHAR3 T053RReason Code for Payments
WAERSWAERSCUKY5 TCURCCurrency Key


SCURRSCURR_AVCURR13(2) Entry Field for Search Criteria (Amount Fields)
SDATESDATE_AVDATS8 Entry Field for Search Criteria (Date Fields)
STYPESTYPE_AVCHAR1 Type of Selection Field (Character, Date, Amount)
SPRIOSPRIO_AVCHAR1 Selection Priority
XREF1XREF1CHAR12 Business partner reference key
XREF2XREF2CHAR12 Business partner reference key
AFELDAFELD_AVCHAR30
*
Name of External Selection Field Specified
LIEFNVBELN_VLCHAR10
*
DeliveryALPHA
REDATREDATDATS8 Invoice Date
BSTNKBSTNKCHAR20 Customer purchase order number
XACONXACONCHAR1 Indicator: Posting on account
ASTATASTAT_AVIKCHAR1 Payment Advice Status
XAMCAXAMCACHAR1 Indicator: Do not calculate gross amount if initial?
ABBTRABBTR_AVCURR13(2) Deduction amount
CONTRCONTR_AVCHAR6 Payment Advice Processing Control Field
KIDNOKIDNOCHAR30 Payment Reference



Key field
Non-key field