SAP ABAP Table AVIK (Payment Advice Header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AVIK	Table Relationship Diagram
Short Description	Payment Advice Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	KOART	☑	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
4	KONTO	☑	KTONR_AV	KTONR	CHAR	10	0	Account Number
5	AVSID	☑	AVSID	AVSID	CHAR	16	0	Payment Advice Number
6	XAUSG	☐	XAUSG_AV	XFELD	CHAR	1	0	Indicator: Outgoing payment using payment advice ?
7	VBLNR	☐	VBLNR	BELNR	CHAR	10	0	Document Number of the Payment Document
8	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	ZALDT	☐	DZALDT	DATUM	DATS	8	0	Probable Payment Date (Cash Discount 1 Due)
11	RWBTR	☐	RWBTR_AV	WRTV7	CURR	13	2	Payment Amount from the Payment Advice Header
12	RWSKT	☐	RWSKT	WRTV7	CURR	13	2	Total Cash Discount for the Pmnt Transactn in Pmnt Currency
13	WEFAE	☐	WEFAE	DATUM	DATS	8	0	Bill of Exchange Due Date
14	RZAWE	☐	RZAWE	ZLSCH	CHAR	1	0	Payment Method for This Payment	*
15	ZBNKL	☐	DZBNKL	BANKL	CHAR	15	0	Bank number of the payee's bank
16	ZBNKN	☐	DZBNKN	BANKN	CHAR	18	0	Bank account number of the payee
17	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
18	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
19	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
20	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	AVTXT	☐	AVTXT_AVIK	TEXT25	CHAR	25	0	Payment Advice Header Text
22	AVSRT	☐	AVSRT	AVSRT	CHAR	2	0	Payment Advice Type
23	TCODE	☐	TCODE_AVIK	TCODE	CHAR	20	0	Transaction Code	TSTC
24	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
25	ASTAT	☐	ASTAT_AVIK	CHAR1	CHAR	1	0	Payment Advice Status
26	XACON	☐	XACON_AVIK	XFELD	CHAR	1	0	Indicator: Payment advice posted on account?
27	XKEEP	☐	XKEEP_AVIK	XFELD	CHAR	1	0	Indicator: Hold payment advice in the system?
28	XUNIQ	☐	XUNIQ_AVIK	XFELD	CHAR	1	0	Indicator: Specific account/company code in payment advice?
29	VRSDG	☐	VRSDG	VRSDG	CHAR	3	0	Reason Code Conversion Version	T053V
30	SREGL	☐	SREGL	SREGL	CHAR	3	0	Selection Rule for Payment Advices	T053A
31	XBENR	☐	AWKEY	AWKEY	CHAR	20	0	Object key
32	XBTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
33	VGREF	☐	REFBK	CHAR35	CHAR	35	0	Bank Reference Number
34	PAKOA	☐	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
35	PAKTO	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
36	BVDAT	☐	BVDAT_EB	DATE_EB	DATS	8	0	Posting date at the bank
37	BUTIM	☐	BUTIM_EB	TIME6	CHAR	6	0	Value date time
38	SPESK	☐	SPESK_EB	WERT7	CURR	13	2	Fees in account currency
39	VORGC	☐	VORGC_EB	CHAR3	CHAR	3	0	Business transaction code
40	TEXTS	☐	TEXTS_EB	CHAR4	CHAR	4	0	Text key
41	ZBNKS	☐	PABKS_EB	LAND1	CHAR	3	0	Country key of partner bank	*
42	ZBSWI	☐	PASWI_EB	SWIFT	CHAR	11	0	SWIFT code of partner bank
43	KURSF	☐	KURSF_EB	KURSF	DEC	9	5	Exchange rate (different from local currency)
44	JPDAT	☐	JPDAT_EB	DATE_EB	DATS	8	0	Date of failed bills of exchange in Japan
45	CHECT	☐	CHECT	CHCKN	CHAR	13	0	Check number
46	XCONF	☐	XCONF_AVIK	CHAR1	CHAR	1	0	Indicator: Payment confirmed
47	AVRT2	☐	AVSRT	AVSRT	CHAR	2	0	Payment Advice Type
48	ZBPRN	☐	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
49	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AVIK	BUKRS	T001	BUKRS	KEY	1	CN
2	AVIK	SREGL	T053A	SREGL	REF	C	CN
3	AVIK	TCODE	TSTC	TCODE	REF	1	CN
4	AVIK	VRSDG	T053V	VRSDG	REF	C	CN
5	AVIK	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in