SAP AVIK Payment Advice Header Table
Overview
AVIK is a standard SAP S/4HANA table that stores Payment Advice Header data. There are total 49 fields in the AVIK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AVIK belongs to Financial Accounting (FI) module and is located in the package Financial Accounting "Basis" (FBAS).
In addition, following links provide an overview of foreign key relationships, if any, that link AVIK to other SAP tables and standard CDS views available based on AVIK table in S/4HANA 2020.
Techincal Settings of AVIK
Below are technical details of the table AVIK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AVIK Fields
The following table gives you an overview of the fields available in AVIK
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AVIK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AVIK | BUKRS | 1: CN | T001 |
| AVIK | SREGL | C: CN | T053A |
| AVIK | TCODE | 1: CN | TSTC |
| AVIK | VRSDG | C: CN | T053V |
| AVIK | WAERS | C: CN | TCURC |