SAP ABAP Table AVIP (Payment Advice Line Item)

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	AVIP	Table Relationship Diagram
Short Description	Payment Advice Line Item

Delivery and Maintenance

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

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	AVSPO	☑	AVSPO	AVSPO	NUMC	5	0	Payment Advice Line Item
7	ABWKO	☐	ABWKO_AV	KTONR	CHAR	10	0	Alternative Account (Payment Advice Management)
8	ABWBU	☐	ABWBU_AV	BUKRS	CHAR	4	0	Alternative Company Code (Payment Advice Management)	T001
9	SFELD	☐	SFELD_AV	FDNAME	CHAR	30	0	Name of Selection Field	*
10	SWERT	☐	SWERT_AV	CHAR30	CHAR	30	0	Selection Value (Payment Advice Management)
11	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
13	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
14	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
15	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
18	RESTG	☐	RSTGR_EXT	CHAR3	CHAR	3	0	External Reason Code for Payment Differences
19	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
20	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
21	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
22	WRBTR	☐	WRBTR_AV	WRTV7	CURR	13	2	Gross amount
23	NEBTR	☐	NEBTR_AV	WRTV7	CURR	13	2	Net Payment Amount with +/- Sign
24	WSKTO	☐	WSKTO_AV	WRTV7	CURR	13	2	Cash discount amount with +/- sign
25	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
26	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
27	ABWKA	☐	ABWKA_AV	KOART_AV	CHAR	1	0	Account Type
28	ZBDXP	☐	DZBDXP	PRZ23	DEC	5	3	Selected cash discount percentage rate
29	ZBDXT	☐	DZBDXT	ZBDXT	DEC	3	0	Selected cash discount days
30	DIFHW	☐	DIFHW	WERT7	CURR	13	2	Amount Difference in Local Currency
31	DIFFW	☐	DIFFW	WRTV7	CURR	13	2	Amount Difference in Foreign Currency
32	DIFH2	☐	DIFH2	WERT7	CURR	13	2	Amount Difference in Second Local Currency
33	DIFH3	☐	DIFH3	WERT7	CURR	13	2	Amount Difference in Third Local Currency
34	XAKTP	☐	XAKTP	XFELD	CHAR	1	0	Indicator: Items activated ?
35	XAKTS	☐	XAKTS	XFELD	CHAR	1	0	Indicator: Cash discount activated ?
36	XPPMT	☐	XPPMT	XFELD	CHAR	1	0	Indicator: partial payments
37	XVORT	☐	XVORT	XFELD	CHAR	1	0	Indicator: Carryforward residual bal. for pmnt difference ?
38	RSTGN	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	T053R
39	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
40	SCURR	☐	SCURR_AV	WERT7	CURR	13	2	Entry Field for Search Criteria (Amount Fields)
41	SDATE	☐	SDATE_AV	DATUM	DATS	8	0	Entry Field for Search Criteria (Date Fields)
42	STYPE	☐	STYPE_AV	STYPE_AV	CHAR	1	0	Type of Selection Field (Character, Date, Amount)
43	SPRIO	☐	SPRIO_AV	XFELD	CHAR	1	0	Selection Priority
44	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
45	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
46	AFELD	☐	AFELD_AV	FDNAME	CHAR	30	0	Name of External Selection Field Specified	*
47	LIEFN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
48	REDAT	☐	REDAT	DATUM	DATS	8	0	Invoice Date
49	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
50	XACON	☐	XACON	XFELD	CHAR	1	0	Indicator: Posting on account
51	ASTAT	☐	ASTAT_AVIK	CHAR1	CHAR	1	0	Payment Advice Status
52	XAMCA	☐	XAMCA	XFELD	CHAR	1	0	Indicator: Do not calculate gross amount if initial?
53	ABBTR	☐	ABBTR_AV	WRTV7	CURR	13	2	Deduction amount
54	CONTR	☐	CONTR_AV	CHAR6	CHAR	6	0	Payment Advice Processing Control Field
55	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AVIP	ABWBU	T001	BUKRS	REF	C	CN
2	AVIP	BUKRS	T001	BUKRS	KEY	1	CN
3	AVIP	GSBER	TGSB	GSBER	REF	C	CN
4	AVIP	MWSKZ	T007A	MWSKZ	REF	C	CN
5	AVIP	RSTGN	T053R	RSTGR	REF	C	CN
6	AVIP	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in