AVIK SAP (Payment Advice Header) Table details
Dictionary Type: Table
Description: Payment Advice Header
Description: Payment Advice Header
Table field list including key, data, relationships and ABAP select examples
AVIK is a standard SAP Table which is used to store Payment Advice Header data and is available within R/3 SAP systems depending on the version and release level.
The AVIK table consists of various fields, each holding specific information or linking keys about Payment Advice Header data available in SAP. These include BUKRS (Company Code), KOART (Payment Advice Account Type), KONTO (Account Number), AVSID (Payment Advice Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AVIK table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| KOART | Payment Advice Account Type | KOART_AV | CHAR | 1 | KOART_AV | ||||
| KONTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
| AVSID | Payment Advice Number | AVSID | CHAR | 16 | AVSID | AVN | |||
| XAUSG | Indicator: Outgoing payment using payment advice ? | XAUSG_AV | CHAR | 1 | XFELD | ||||
| VBLNR | Document Number of the Payment Document | VBLNR | CHAR | 10 | ALPHA | BELNR | |||
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS | 8 | DATUM | ||||
| RWBTR | Payment Amount from the Payment Advice Header | RWBTR_AV | CURR | 13(2) | WRTV7 | ||||
| RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | CURR | 13(2) | WRTV7 | ||||
| WEFAE | Bill of Exchange Due Date | WEFAE | DATS | 8 | DATUM | ||||
| RZAWE | Payment Method for This Payment | RZAWE | CHAR | 1 | Assigned to domain | ZLSCH | |||
| ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
| ZBNKN | Bank account number of the payee | DZBNKN | CHAR | 18 | BANKN | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| AVTXT | Payment Advice Header Text | AVTXT_AVIK | CHAR | 25 | TEXT25 | ||||
| AVSRT | Payment Advice Type | AVSRT | CHAR | 2 | AVSRT | ||||
| TCODE | Transaction Code | TCODE_AVIK | CHAR | 20 | TSTC | TCODE | |||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR | 1 | CHAR1 | ||||
| XACON | Indicator: Payment advice posted on account? | XACON_AVIK | CHAR | 1 | XFELD | ||||
| XKEEP | Indicator: Hold payment advice in the system? | XKEEP_AVIK | CHAR | 1 | XFELD | ||||
| XUNIQ | Indicator: Specific account/company code in payment advice? | XUNIQ_AVIK | CHAR | 1 | XFELD | ||||
| VRSDG | Reason Code Conversion Version | VRSDG | CHAR | 3 | T053V | VRSDG | |||
| SREGL | Selection Rule for Payment Advices | SREGL | CHAR | 3 | T053A | SREGL | |||
| XBENR | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
| XBTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| VGREF | Bank Reference Number | REFBK | CHAR | 35 | CHAR35 | ||||
| PAKOA | Payment Advice Account Type | KOART_AV | CHAR | 1 | KOART_AV | ||||
| PAKTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
| BVDAT | Posting date at the bank | BVDAT_EB | DATS | 8 | DATEX | DATE_EB | |||
| BUTIM | Value date time | BUTIM_EB | CHAR | 6 | TIME6 | ||||
| SPESK | Fees in account currency | SPESK_EB | CURR | 13(2) | WERT7 | ||||
| VORGC | Business transaction code | VORGC_EB | CHAR | 3 | CHAR3 | ||||
| TEXTS | Text key | TEXTS_EB | CHAR | 4 | CHAR4 | ||||
| ZBNKS | Country key of partner bank | PABKS_EB | CHAR | 3 | Assigned to domain | LAND1 | |||
| ZBSWI | SWIFT code of partner bank | PASWI_EB | CHAR | 11 | SWIFT | ||||
| KURSF | Exchange rate (different from local currency) | KURSF_EB | DEC | 9(5) | KURSF | ||||
| JPDAT | Date of failed bills of exchange in Japan | JPDAT_EB | DATS | 8 | DATEX | DATE_EB | |||
| CHECT | Check number | CHECT | CHAR | 13 | CHCKN | CHK | |||
| XCONF | Indicator: Payment confirmed | XCONF_AVIK | CHAR | 1 | CHAR1 | ||||
| AVRT2 | Payment Advice Type | AVSRT | CHAR | 2 | AVSRT | ||||
| ZBPRN | Business Partner | PARTN_EB | CHAR | 55 | CHAR55 | ||||
| VALUT | Value date | VALUT | DATS | 8 | DATUM |
| Key field | Non-key field |
How do I retrieve data from SAP table AVIK using ABAP code
The following ABAP code Example will allow you to do a basic selection on AVIK to SELECT all data from the tableDATA: WA_AVIK TYPE AVIK.
SELECT SINGLE *
FROM AVIK
INTO CORRESPONDING FIELDS OF WA_AVIK
WHERE...
How to access SAP table AVIK
Within an ECC or HANA version of SAP you can also view further information about AVIK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects