AVIK is a standard SAP table in SAP ERP (or) S/4HANA which stores Payment Advice Header data. There are total 49 fields in AVIK table.This blog post provides key technical details of SAP table AVIK, including its availability across SAP S/4HANA versions and the list of CDS views for AVIK table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Financial Accounting “Basis” (FBAS) |
| Technical Component | Financial Accounting (FI) |
SAP AVIK Table Fields
The following is the list of fields that are available in SAP AVIK table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| BUKRS | Company Code | BUKRS | BUKRS | T001 | CHAR (4) |
| KOART | Payment Advice Account Type | KOART_AV | KOART_AV | CHAR (1) | |
| KONTO | Account Number | KTONR_AV | KTONR | CHAR (10) | |
| AVSID | Payment Advice Number | AVSID | AVSID | CHAR (16) | |
| XAUSG | Indicator: Outgoing Payment Using Payment Advice? | XAUSG_AV | XFELD | CHAR (1) | |
| VBLNR | Document Number of the Payment Document | VBLNR | BELNR | CHAR (10) | |
| EIKTO | Shipper’s (Our) Account Number at the Customer or Vendor | EIKTO | CHAR12 | CHAR (12) | |
| WAERS | Currency Key | WAERS | WAERS | TCURC | CUKY (5) |
| ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATUM | DATS (8) | |
| RWBTR | Payment Amount from the Payment Advice Header | RWBTR_AV | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | AFLE13D2O18S_TO_23D2O31S | CURR (23) | |
| WEFAE | Bill of Exchange Due Date | WEFAE | DATUM | DATS (8) | |
| RZAWE | Payment Method for This Payment | RZAWE | ZLSCH | CHAR (1) | |
| ZBNKL | Bank number of the payee’s bank | DZBNKL | BANKL | CHAR (15) | |
| ZBNKN | Bank account number of the payee | DZBNKN | BANKN | CHAR (18) | |
| ERNAM | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| ERDAT | Date on which the record was created | ERDAT | DATUM | DATS (8) | |
| AEDAT | Date of Last Change | AEDAT | DATUM | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| AVTXT | Payment Advice Header Text | AVTXT_AVIK | TEXT25 | CHAR (25) | |
| AVSRT | Payment Advice Type | AVSRT | AVSRT | CHAR (2) | |
| TCODE | Transaction Code | TCODE_AVIK | TCODE | TSTC | CHAR (20) |
| CPUTM | Time of Entry | CPUTM | UZEIT | TIMS (6) | |
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR1 | CHAR (1) | |
| XACON | Indicator: Payment Advice Posted on Account? | XACON_AVIK | XFELD | CHAR (1) | |
| XKEEP | Indicator: Hold Payment Advice in the System? | XKEEP_AVIK | XFELD | CHAR (1) | |
| XUNIQ | Indicator: Specific Account/Company Code in Payment Advice? | XUNIQ_AVIK | XFELD | CHAR (1) | |
| VRSDG | Reason Code Conversion Version | VRSDG | VRSDG | T053V | CHAR (3) |
| SREGL | Selection Rule for Payment Advices | SREGL | SREGL | T053A | CHAR (3) |
| XBENR | Object key | AWKEY | AWKEY | CHAR (20) | |
| XBTYP | Reference procedure | AWTYP | AWTYP | CHAR (5) | |
| VGREF | Bank Reference Number | REFBK | CHAR35 | CHAR (35) | |
| PAKOA | Payment Advice Account Type | KOART_AV | KOART_AV | CHAR (1) | |
| PAKTO | Account Number | KTONR_AV | KTONR | CHAR (10) | |
| BVDAT | Posting Date at the Bank | BVDAT_EB | DATE_EB | DATS (8) | |
| BUTIM | Value Date Time | BUTIM_EB | TIME6 | CHAR (6) | |
| SPESK | Fees in Account Currency | SPESK_EB | AFLE13D2O16N_TO_23D2O30N | CURR (23) | |
| VORGC | Business Transaction Code | VORGC_EB | CHAR3 | CHAR (3) | |
| TEXTS | Text Key | TEXTS_EB | CHAR4 | CHAR (4) | |
| ZBNKS | Country Key of Partner Bank | PABKS_EB | LAND1 | CHAR (3) | |
| ZBSWI | SWIFT Code of Partner Bank | PASWI_EB | SWIFT | CHAR (11) | |
| KURSF | Exchange Rate (Different from Local Currency) | KURSF_EB | KURSF | DEC (9) | |
| JPDAT | Date of Failed Bills of Exchange in Japan | JPDAT_EB | DATE_EB | DATS (8) | |
| CHECT | Check number | CHECT | CHCKN | CHAR (13) | |
| XCONF | Indicator: Payment Confirmed | XCONF_AVIK | CHAR1 | CHAR (1) | |
| AVRT2 | Payment Advice Type | AVSRT | AVSRT | CHAR (2) | |
| ZBPRN | Business Partner | PARTN_EB | CHAR55 | CHAR (55) | |
| VALUT | Value date | VALUT | DATUM | DATS (8) |
Availability
The SAP table AVIK is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AVIK table
The following is the list of AVIK CDS views, which can also be used instead of AVIK table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| A_PAYMENTADVICE | BASIC | Payment Advice |
| I_PAYMENTADVICE | BASIC | Payment Advice Header |
| I_PAYMENTADVICEFROMASSIGNMENT | BASIC | Payment advices created from assignment |
| I_PAYMENTADVICEHEADER | BASIC | Payment Advice Header |
| P_ARBSITMPAYADVICE | BASIC | Payment Advice for Machine Learning |
| P_PAYMENTADVICEHEADER | BASIC | Payment Advice Header |
| I_PAYMENTADVICEUSERVH | COMPOSITE | Value help for payment advice user |
| P_PAYMENTADVICE | COMPOSITE | Payment Advice Header |
| P_PAYMENTADVICEFORSITUATION | COMPOSITE | Payment Advice for Situation Framwork |
| C_CUSTOMERWITHASSIGNEDOPENITEM | CONSUMPTION | Customer With Assigned Open Items |
| C_PAYMENTADVICE | CONSUMPTION | Payment Advice Header |
| C_PAYTMEDIAITEM | CONSUMPTION | Payment Media Item |
| P_CUSTOMERWITHPAYMENTADVICE2 | CONSUMPTION | Customers With Payment Advices 2 |
