1. Home
  2. Resources
  3. SAP Tables
  4. AVIK - Payment Advice Header

SAP Table AVIK

Payment Advice Header

AVIK (Payment Advice Header) 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 AVIK to other SAP tables.

AVIK 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
XAUSG Indicator: Outgoing payment using payment advice ? XAUSG_AV CHAR 1 0
X Yes
NULL No
VBLNR Document Number of the Payment Document VBLNR CHAR 10 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
WAERS Currency Key WAERS TCURC CUKY 5 0
ZALDT Probable Payment Date (Cash Discount 1 Due) DZALDT DATS 8 0
RWBTR Payment Amount from the Payment Advice Header RWBTR_AV CURR 13 2
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKT CURR 13 2
WEFAE Bill of Exchange Due Date WEFAE DATS 8 0
RZAWE Payment Method for This Payment RZAWE CHAR 1 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZBNKN Bank account number of the payee DZBNKN CHAR 18 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AVTXT Payment Advice Header Text AVTXT_AVIK CHAR 25 0
AVSRT Payment Advice Type AVSRT CHAR 2 0
01 Payment advice from lockbox
02 Payment advice from account statement
03 Payment advice from open item processing
04 Payment advice entered manually
05 Payment advice from credit memo display
06 Payment advice from customer (EDI)
07 Payment advice from reference number (DME)
08 Payment advice from correspondence
09 Payment notice from assignment via Internet
10 Zero Balance Notification (EDI)
11 Payment Advice Note from Assignment of Credits/Payments
TCODE Transaction Code TCODE_AVIK TSTC CHAR 20 0
CPUTM Time of Entry CPUTM TIMS 6 0
ASTAT Payment Advice Status ASTAT_AVIK CHAR 1 0
XACON Indicator: Payment advice posted on account? XACON_AVIK CHAR 1 0
X Yes
NULL No
XKEEP Indicator: Hold payment advice in the system? XKEEP_AVIK CHAR 1 0
X Yes
NULL No
XUNIQ Indicator: Specific account/company code in payment advice? XUNIQ_AVIK CHAR 1 0
X Yes
NULL No
VRSDG Reason Code Conversion Version VRSDG T053V CHAR 3 0
SREGL Selection Rule for Payment Advices SREGL T053A CHAR 3 0
XBENR Reference Key AWKEY CHAR 20 0
XBTYP Reference Transaction AWTYP CHAR 5 0
VGREF Bank Reference Number REFBK CHAR 35 0
PAKOA Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
PAKTO Account Number KTONR_AV CHAR 10 0
BVDAT Posting date at the bank BVDAT_EB DATS 8 0
BUTIM Value date time BUTIM_EB CHAR 6 0
SPESK Fees in account currency SPESK_EB CURR 13 2
VORGC Business transaction code VORGC_EB CHAR 3 0
TEXTS Text key TEXTS_EB CHAR 4 0
ZBNKS Country key of partner bank PABKS_EB CHAR 3 0
ZBSWI SWIFT code of partner bank PASWI_EB CHAR 11 0
KURSF Exchange rate (different from local currency) KURSF_EB DEC 9 5
JPDAT Date of failed bills of exchange in Japan JPDAT_EB DATS 8 0
CHECT Check number CHECT CHAR 13 0
XCONF Indicator: Payment confirmed XCONF_AVIK CHAR 1 0
AVRT2 Payment Advice Type AVSRT CHAR 2 0
01 Payment advice from lockbox
02 Payment advice from account statement
03 Payment advice from open item processing
04 Payment advice entered manually
05 Payment advice from credit memo display
06 Payment advice from customer (EDI)
07 Payment advice from reference number (DME)
08 Payment advice from correspondence
09 Payment notice from assignment via Internet
10 Zero Balance Notification (EDI)
11 Payment Advice Note from Assignment of Credits/Payments
ZBPRN Business Partner PARTN_EB CHAR 55 0
VALUT Value date VALUT DATS 8 0

AVIK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AVIK BUKRS AVIK MANDT T001 Company Codes MANDT
AVIK BUKRS AVIK BUKRS T001 Company Codes BUKRS
AVIK SREGL AVIK MANDT T053A Selection Rules for Payment Advices MANDT
AVIK SREGL AVIK SREGL T053A Selection Rules for Payment Advices SREGL
AVIK TCODE AVIK TCODE TSTC SAP Transaction Codes TCODE
AVIK VRSDG AVIK MANDT T053V Reason Code Conversion Version MANDT
AVIK VRSDG AVIK VRSDG T053V Reason Code Conversion Version VRSDG
AVIK WAERS AVIK MANDT TCURC Currency Codes MANDT
AVIK WAERS AVIK WAERS TCURC Currency Codes WAERS