SAP Table AVIP - Payment Advice Line Item

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
KOART X KOART_AV CHAR 7 1 0 Payment Advice Account Type
KONTO X KTONR_AV CHAR 8 10 0 Account Number
AVSID X AVSID CHAR 18 16 0 Payment Advice Number
AVSPO X AVSPO NUMC 34 5 0 Payment Advice Line Item
ABWKO ABWKO_AV CHAR 39 10 0 Alternative Account (Payment Advice Management)
ABWBU ABWBU_AV CHAR 49 4 0 T001 Alternative Company Code (Payment Advice Management)
SFELD SFELD_AV CHAR 53 30 0 Name of Selection Field
SWERT SWERT_AV CHAR 83 30 0 Selection Value (Payment Advice Management)
BELNR BELNR_D CHAR 113 10 0 Accounting Document Number
XBLNR XBLNR1 CHAR 123 16 0 Reference Document Number
VBELN VBELN_VF CHAR 139 10 0 Billing Document
FILKD FILKD CHAR 149 10 0 Account Number of the Branch
CPUDT CPUDT DATS 159 8 0 Day On Which Accounting Document Was Entered
GSBER GSBER CHAR 167 4 0 TGSB Business Area
ZUONR DZUONR CHAR 171 18 0 Assignment Number
RESTG RSTGR_EXT CHAR 189 3 0 External Reason Code for Payment Differences
SGTXT SGTXT CHAR 192 50 0 Item Text
MWSTS MWSTS CURR 242 13 2 Tax Amount in Local Currency
MWSKZ MWSKZ CHAR 249 2 0 Sales Tax Code
WRBTR WRBTR_AV CURR 251 13 2 Gross amount
NEBTR NEBTR_AV CURR 258 13 2 Net Payment Amount with +/- Sign
WSKTO WSKTO_AV CURR 265 13 2 Cash discount amount with +/- sign
GJAHR GJAHR NUMC 272 4 0 Fiscal Year
BUZEI BUZEI NUMC 276 3 0 Number of Line Item Within Accounting Document
ABWKA ABWKA_AV CHAR 279 1 0 Account Type
ZBDXP DZBDXP DEC 280 5 3 Selected cash discount percentage rate
ZBDXT DZBDXT DEC 283 3 0 Selected cash discount days
DIFHW DIFHW CURR 285 13 2 Amount Difference in Local Currency
DIFFW DIFFW CURR 292 13 2 Amount Difference in Foreign Currency
DIFH2 DIFH2 CURR 299 13 2 Amount Difference in Second Local Currency
DIFH3 DIFH3 CURR 306 13 2 Amount Difference in Third Local Currency
XAKTP XAKTP CHAR 313 1 0 Indicator: Items activated ?
XAKTS XAKTS CHAR 314 1 0 Indicator: Cash discount activated ?
XPPMT XPPMT CHAR 315 1 0 Indicator: partial payments
XVORT XVORT CHAR 316 1 0 Indicator: Carryforward residual bal. for pmnt difference ?
RSTGN RSTGR CHAR 317 3 0 T053R Reason Code for Payments
WAERS WAERS CUKY 320 5 0 TCURC Currency Key
SCURR SCURR_AV CURR 325 13 2 Entry Field for Search Criteria (Amount Fields)
SDATE SDATE_AV DATS 332 8 0 Entry Field for Search Criteria (Date Fields)
STYPE STYPE_AV CHAR 340 1 0 Type of Selection Field (Character, Date, Amount)
SPRIO SPRIO_AV CHAR 341 1 0 Selection Priority
XREF1 XREF1 CHAR 342 12 0 Business Partner Reference Key
XREF2 XREF2 CHAR 354 12 0 Business Partner Reference Key
AFELD AFELD_AV CHAR 366 30 0 Name of External Selection Field Specified
LIEFN VBELN_VL CHAR 396 10 0 Delivery
REDAT REDAT DATS 406 8 0 Invoice Date
BSTNK BSTNK CHAR 414 20 0 Customer purchase order number
XACON XACON CHAR 434 1 0 Indicator: Posting on account
ASTAT ASTAT_AVIK CHAR 435 1 0 Payment Advice Status
XAMCA XAMCA CHAR 436 1 0 Indicator: Do not calculate gross amount if initial?
ABBTR ABBTR_AV CURR 437 13 2 Deduction amount
CONTR CONTR_AV CHAR 444 6 0 Payment Advice Processing Control Field
KIDNO KIDNO CHAR 450 30 0 Payment Reference

114713New interpretation algorithms as of Rel. 3.0F
2596SAPDFKA6: New fields in fast entry screens