The AVIK table in SAP ERP or S/4HANA stores Payment Advice Header data. There are total 49 fields in AVIK table. The Payment Advice Header table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AVIK table. It is in Financial Accounting “Basis” (FBAS) ABAP package and is part of the Financial Accounting (FI) module.
SAP AVIK Table Fields
Following is the list of fields that are available in SAP AVIK table. The primary key fields of the table are MANDT (Client), BUKRS (Company Code), KOART (Payment Advice Account Type), KONTO (Account Number), AVSID (Payment Advice Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| KOART | Payment Advice Account Type | KOART_AV | CHAR (1) | |
| KONTO | Account Number | KTONR_AV | CHAR (10) | |
| AVSID | Payment Advice Number | AVSID | CHAR (16) | |
| XAUSG | Indicator: Outgoing Payment Using Payment Advice? | XAUSG_AV | CHAR (1) | |
| VBLNR | Document Number of the Payment Document | VBLNR | CHAR (10) | |
| EIKTO | Shipper’s (Our) Account Number at the Customer or Vendor | EIKTO | CHAR (12) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS (8) | |
| RWBTR | Payment Amount from the Payment Advice Header | RWBTR_AV | CURR (23) | |
| RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | CURR (23) | |
| WEFAE | Bill of Exchange Due Date | WEFAE | DATS (8) | |
| RZAWE | Payment Method for This Payment | RZAWE | CHAR (1) | |
| ZBNKL | Bank number of the payee’s bank | DZBNKL | CHAR (15) | |
| ZBNKN | Bank account number of the payee | DZBNKN | CHAR (18) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| AVTXT | Payment Advice Header Text | AVTXT_AVIK | CHAR (25) | |
| AVSRT | Payment Advice Type | AVSRT | CHAR (2) | |
| TCODE | Transaction Code | TCODE_AVIK | TSTC | CHAR (20) |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR (1) | |
| XACON | Indicator: Payment Advice Posted on Account? | XACON_AVIK | CHAR (1) | |
| XKEEP | Indicator: Hold Payment Advice in the System? | XKEEP_AVIK | CHAR (1) | |
| XUNIQ | Indicator: Specific Account/Company Code in Payment Advice? | XUNIQ_AVIK | CHAR (1) | |
| VRSDG | Reason Code Conversion Version | VRSDG | T053V | CHAR (3) |
| SREGL | Selection Rule for Payment Advices | SREGL | T053A | CHAR (3) |
| XBENR | Object key | AWKEY | CHAR (20) | |
| XBTYP | Reference procedure | AWTYP | CHAR (5) | |
| VGREF | Bank Reference Number | REFBK | CHAR (35) | |
| PAKOA | Payment Advice Account Type | KOART_AV | CHAR (1) | |
| PAKTO | Account Number | KTONR_AV | CHAR (10) | |
| BVDAT | Posting Date at the Bank | BVDAT_EB | DATS (8) | |
| BUTIM | Value Date Time | BUTIM_EB | CHAR (6) | |
| SPESK | Fees in Account Currency | SPESK_EB | CURR (23) | |
| VORGC | Business Transaction Code | VORGC_EB | CHAR (3) | |
| TEXTS | Text Key | TEXTS_EB | CHAR (4) | |
| ZBNKS | Country Key of Partner Bank | PABKS_EB | CHAR (3) | |
| ZBSWI | SWIFT Code of Partner Bank | PASWI_EB | CHAR (11) | |
| KURSF | Exchange Rate (Different from Local Currency) | KURSF_EB | DEC (9) | |
| JPDAT | Date of Failed Bills of Exchange in Japan | JPDAT_EB | DATS (8) | |
| CHECT | Check number | CHECT | CHAR (13) | |
| XCONF | Indicator: Payment Confirmed | XCONF_AVIK | CHAR (1) | |
| AVRT2 | Payment Advice Type | AVSRT | CHAR (2) | |
| ZBPRN | Business Partner | PARTN_EB | CHAR (55) | |
| VALUT | Value date | VALUT | DATS (8) |
