AVIP

Payment Advice Line Item | #transactional | Component: Financial Accounting
Column Name Description
MANDT Client
BUKRS FK Company Code
KOART Payment Advice Account Type Show values
KONTO Account Number
AVSID Payment Advice Number
AVSPO Payment Advice Item
Column Name Description
πŸ’² Currency Key (AVIK.WAERS):
MWSTS Tax Amount in Local Currency
WRBTR Gross Amount
NEBTR Net Payment Amount with +/- Sign
WSKTO Cash Discount Amount with +/- Sign
DIFHW Amount Difference in Local Currency
DIFFW Amount Difference in Foreign Currency
SCURR Entry Field for Search Criteria (Amount Fields)
ABBTR Deduction Amount
DIFH2 Amount Difference in Second Local Currency
DIFH3 Amount Difference in Third Local Currency
Column Name Description
Column Name Description
CPUDT Day On Which Accounting Document Was Entered
SDATE Entry Field for Search Criteria (Date Fields)
REDAT Invoice Date
Column Name Description
KOART Payment Advice Account Type Show values
ABWKA Account Type Show values
XAKTP Indicator: Items Activated? Show values
XAKTS Indicator: Cash Discount Activated? Show values
XPPMT Indicator: Partial Payments Show values
XVORT Indicator: Carryforward Residual Bal. for Payt Difference? Show values
SPRIO Selection Priority Show values
XACON Indicator: Posting on Account Show values
XAMCA Indicator: Do Not Calculate Gross Amount if Initial? Show values
Column Name Description Domain name
ABWKO Alternative Account (Payment Advice Management) KTONR
SFELD Name of Selection Field FDNAME
SWERT Selection Value (Payment Advice Management) CHAR30
BELNR Document Number of an Accounting Document BELNR
XBLNR Reference Document Number XBLNR1
VBELN Billing Document VBELN
FILKD Account Number of the Branch MAXKK
ZUONR Assignment number ZUONR
RESTG External Reason Code for Payment Differences CHAR3
SGTXT Item Text TEXT50
GJAHR Fiscal Year GJAHR
BUZEI Number of Line Item Within Accounting Document BUZEI
ZBDXP Selected Cash Discount Percentage Rate PRZ23
ZBDXT Selected cash discount days ZBDXT
STYPE Type of Selection Field (Character, Date, Amount) STYPE_AV
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
AFELD Name of External Selection Field Specified FDNAME
LIEFN Delivery VBELN
BSTNK Customer Reference BSTNK
ASTAT Payment Advice Status CHAR1
CONTR Payment Advice Processing Control Field CHAR6
KIDNO Payment Reference CHAR30
LBINVREF Lockbox Invoice Reference LBINVREF
Master Data Relations Join Conditions
Alternative Company Code (Payment Advice Management)
  • AVIP.MANDT == T001.MANDT
  • AVIP.ABWBU == T001.BUKRS
Company Code
  • AVIP.MANDT == T001.MANDT
  • AVIP.BUKRS == T001.BUKRS
Business Area
  • AVIP.MANDT == TGSB.MANDT
  • AVIP.GSBER == TGSB.GSBER
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • AVIP.MANDT == T007A.MANDT
  • AVIP.[column in domain "KALSM_D"] == T007A.KALSM
  • AVIP.MWSKZ == T007A.MWSKZ
Reason Code for Payments
  • Alternative Company Code (Payment Advice Management)
  • Reason Code for Payments
  • Client
  • AVIP.ABWBU == T053R.BUKRS
  • AVIP.RSTGN == T053R.RSTGR
  • AVIP.MANDT == T053R.MANDT
Currency Key
  • AVIP.MANDT == TCURC.MANDT
  • AVIP.WAERS == TCURC.WAERS