SAP ABAP Table AVIP_LST (Payment Advice Note Item for ALV List)

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	INTTAB	Structure
Structure	AVIP_LST	Table Relationship Diagram
Short Description	Payment Advice Note Item for ALV List

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	600