SAP table AVIK (Payment Advice Header)

SAP table AVIK has 5 primary key fields being MANDT,BUKRS,KOART,KONTO,AVSID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOART Payment Advice Account Type CHAR 1 0 KOART_AV
D Customer
K Vendor
S G/L Account
KONTO Account Number CHAR 10 0 KTONR_AV
AVSID Payment Advice Number CHAR 16 0 AVSID
XAUSG Indicator: Outgoing Payment Using Payment Advice? CHAR 1 0 XAUSG_AV
VBLNR Document Number of the Payment Document CHAR 10 0 VBLNR
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12 0 EIKTO
WAERS Currency Key CUKY 5 0 TCURC WAERS
ZALDT Probable Payment Date (Cash Discount 1 Due) DATS 8 0 DZALDT
RWBTR Payment Amount from the Payment Advice Header CURR 23 2 RWBTR_AV
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency CURR 23 2 RWSKT
WEFAE Bill of Exchange Due Date DATS 8 0 WEFAE
RZAWE Payment Method for This Payment CHAR 1 0 RZAWE
ZBNKL Bank number of the payee's bank CHAR 15 0 DZBNKL
ZBNKN Bank account number of the payee CHAR 18 0 DZBNKN
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AVTXT Payment Advice Header Text CHAR 25 0 AVTXT_AVIK
AVSRT Payment Advice Type CHAR 2 0 AVSRT
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 advice from assignment via Internet
10 Zero Balance Notification (EDI)
11 Payment advice from assignment of credits/payments
12 Payment advice retrieved from a file
13 To be adjusted
TCODE Transaction Code CHAR 20 0 TSTC TCODE_AVIK
CPUTM Time of Entry TIMS 6 0 CPUTM
ASTAT Payment Advice Status CHAR 1 0 ASTAT_AVIK
XACON Indicator: Payment Advice Posted on Account? CHAR 1 0 XACON_AVIK
XKEEP Indicator: Hold Payment Advice in the System? CHAR 1 0 XKEEP_AVIK
XUNIQ Indicator: Specific Account/Company Code in Payment Advice? CHAR 1 0 XUNIQ_AVIK
VRSDG Reason Code Conversion Version CHAR 3 0 T053V VRSDG
SREGL Selection Rule for Payment Advices CHAR 3 0 T053A SREGL
XBENR Reference Key CHAR 20 0 AWKEY
XBTYP Reference procedure CHAR 5 0 AWTYP
VGREF Bank Reference Number CHAR 35 0 REFBK
PAKOA Payment Advice Account Type CHAR 1 0 KOART_AV
D Customer
K Vendor
S G/L Account
PAKTO Account Number CHAR 10 0 KTONR_AV
BVDAT Posting Date at the Bank DATS 8 0 BVDAT_EB
BUTIM Value Date Time CHAR 6 0 BUTIM_EB
SPESK Fees in Account Currency CURR 23 2 SPESK_EB
VORGC Business Transaction Code CHAR 3 0 VORGC_EB
TEXTS Text Key CHAR 4 0 TEXTS_EB
ZBNKS Country/Region Key of Partner Bank CHAR 3 0 PABKS_EB
ZBSWI SWIFT Code of Partner Bank CHAR 11 0 PASWI_EB
KURSF Exchange Rate (Different from Local Currency) DEC 9 5 KURSF_EB
JPDAT Date of Failed Bills of Exchange in Japan DATS 8 0 JPDAT_EB
CHECT Check number CHAR 13 0 CHECT
XCONF Indicator: Payment Confirmed CHAR 1 0 XCONF_AVIK
AVRT2 Payment Advice Type CHAR 2 0 AVSRT
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 advice from assignment via Internet
10 Zero Balance Notification (EDI)
11 Payment advice from assignment of credits/payments
12 Payment advice retrieved from a file
13 To be adjusted
ZBPRN Business Partner CHAR 55 0 PARTN_EB
VALUT Value date DATS 8 0 VALUT

AVIK foreign key relationships

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