SAP ABAP View KNB4_AEDAT (BW FI: KNB4 Extraction using AEDAT)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ BWFI (Package) BW: Delta Process for Data Extraction in FI

Basic Data

View Type	D	Database View
Database View	KNB4_AEDAT
Short Description	BW FI: KNB4 Extraction using AEDAT
Root table	KNB4	Customer Payment History

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNB4	KNB4
2	BWFI_AEDA3

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BWFI_AEDA3	MANDT	JL	EQ				0	0
2	KNB4	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDA3	KONTO	JL	EQ				0	0
4	KNB4	KUNNR	JR	EQ			AND	0	0
5	BWFI_AEDA3	BUKRS	JL	EQ				0	0
6	KNB4	BUKRS	JR	EQ			AND	0	0
7	BWFI_AEDA3	TABNAME		EQ	'KNB4'		AND	0	0
8	BWFI_AEDA3	KKBER		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNB4	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNB4	KUNNR		☐	KUNNR	☐	Customer Number
3	BUKRS	KNB4	BUKRS		☐	BUKRS	☐	Company Code
4	TABNAME	BWFI_AEDA3	TABNAME		☐	TABNAME	☐	Table Name
5	KKBER	BWFI_AEDA3	KKBER		☐	KKBER	☐	Credit control area
6	AUFZD	KNB4	AUFZD		☐	AUFZD	☐	Date as from when the payment history was recorded
7	JAH01	KNB4	JAH01		☐	KALJAHR	☐	Calendar Year
8	MON01	KNB4	MON01		☐	KMONA_FI	☐	Calendar Month
9	AGS01	KNB4	AGS01		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
10	VZS01	KNB4	VZS01		☐	VZSXX	☐	Average arrears with cash discount payments
11	AGN01	KNB4	AGN01		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
12	VZN01	KNB4	VZN01		☐	VZNXX	☐	Average arrears with payments without cash discount taken
13	ANZ01	KNB4	ANZ01		☐	ANZXX	☐	Number of Incoming Payments during the Period
14	JAH02	KNB4	JAH02		☐	KALJAHR	☐	Calendar Year
15	MON02	KNB4	MON02		☐	KMONA_FI	☐	Calendar Month
16	AGS02	KNB4	AGS02		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
17	VZS02	KNB4	VZS02		☐	VZSXX	☐	Average arrears with cash discount payments
18	AGN02	KNB4	AGN02		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
19	VZN02	KNB4	VZN02		☐	VZNXX	☐	Average arrears with payments without cash discount taken
20	ANZ02	KNB4	ANZ02		☐	ANZXX	☐	Number of Incoming Payments during the Period
21	JAH03	KNB4	JAH03		☐	KALJAHR	☐	Calendar Year
22	MON03	KNB4	MON03		☐	KMONA_FI	☐	Calendar Month
23	AGS03	KNB4	AGS03		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
24	VZS03	KNB4	VZS03		☐	VZSXX	☐	Average arrears with cash discount payments
25	AGN03	KNB4	AGN03		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
26	VZN03	KNB4	VZN03		☐	VZNXX	☐	Average arrears with payments without cash discount taken
27	ANZ03	KNB4	ANZ03		☐	ANZXX	☐	Number of Incoming Payments during the Period
28	JAH04	KNB4	JAH04		☐	KALJAHR	☐	Calendar Year
29	MON04	KNB4	MON04		☐	KMONA_FI	☐	Calendar Month
30	AGS04	KNB4	AGS04		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
31	VZS04	KNB4	VZS04		☐	VZSXX	☐	Average arrears with cash discount payments
32	AGN04	KNB4	AGN04		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
33	VZN04	KNB4	VZN04		☐	VZNXX	☐	Average arrears with payments without cash discount taken
34	ANZ04	KNB4	ANZ04		☐	ANZXX	☐	Number of Incoming Payments during the Period
35	JAH05	KNB4	JAH05		☐	KALJAHR	☐	Calendar Year
36	MON05	KNB4	MON05		☐	KMONA_FI	☐	Calendar Month
37	AGS05	KNB4	AGS05		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
38	VZS05	KNB4	VZS05		☐	VZSXX	☐	Average arrears with cash discount payments
39	AGN05	KNB4	AGN05		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
40	VZN05	KNB4	VZN05		☐	VZNXX	☐	Average arrears with payments without cash discount taken
41	ANZ05	KNB4	ANZ05		☐	ANZXX	☐	Number of Incoming Payments during the Period
42	JAH06	KNB4	JAH06		☐	KALJAHR	☐	Calendar Year
43	MON06	KNB4	MON06		☐	KMONA_FI	☐	Calendar Month
44	AGS06	KNB4	AGS06		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
45	VZS06	KNB4	VZS06		☐	VZSXX	☐	Average arrears with cash discount payments
46	AGN06	KNB4	AGN06		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
47	VZN06	KNB4	VZN06		☐	VZNXX	☐	Average arrears with payments without cash discount taken
48	ANZ06	KNB4	ANZ06		☐	ANZXX	☐	Number of Incoming Payments during the Period
49	JAH07	KNB4	JAH07		☐	KALJAHR	☐	Calendar Year
50	MON07	KNB4	MON07		☐	KMONA_FI	☐	Calendar Month
51	AGS07	KNB4	AGS07		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
52	VZS07	KNB4	VZS07		☐	VZSXX	☐	Average arrears with cash discount payments
53	AGN07	KNB4	AGN07		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
54	VZN07	KNB4	VZN07		☐	VZNXX	☐	Average arrears with payments without cash discount taken
55	ANZ07	KNB4	ANZ07		☐	ANZXX	☐	Number of Incoming Payments during the Period
56	JAH08	KNB4	JAH08		☐	KALJAHR	☐	Calendar Year
57	MON08	KNB4	MON08		☐	KMONA_FI	☐	Calendar Month
58	AGS08	KNB4	AGS08		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
59	VZS08	KNB4	VZS08		☐	VZSXX	☐	Average arrears with cash discount payments
60	AGN08	KNB4	AGN08		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
61	VZN08	KNB4	VZN08		☐	VZNXX	☐	Average arrears with payments without cash discount taken
62	ANZ08	KNB4	ANZ08		☐	ANZXX	☐	Number of Incoming Payments during the Period
63	JAH09	KNB4	JAH09		☐	KALJAHR	☐	Calendar Year
64	MON09	KNB4	MON09		☐	KMONA_FI	☐	Calendar Month
65	AGS09	KNB4	AGS09		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
66	VZS09	KNB4	VZS09		☐	VZSXX	☐	Average arrears with cash discount payments
67	AGN09	KNB4	AGN09		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
68	VZN09	KNB4	VZN09		☐	VZNXX	☐	Average arrears with payments without cash discount taken
69	ANZ09	KNB4	ANZ09		☐	ANZXX	☐	Number of Incoming Payments during the Period
70	JAH10	KNB4	JAH10		☐	KALJAHR	☐	Calendar Year
71	MON10	KNB4	MON10		☐	KMONA_FI	☐	Calendar Month
72	AGS10	KNB4	AGS10		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
73	VZS10	KNB4	VZS10		☐	VZSXX	☐	Average arrears with cash discount payments
74	AGN10	KNB4	AGN10		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
75	VZN10	KNB4	VZN10		☐	VZNXX	☐	Average arrears with payments without cash discount taken
76	ANZ10	KNB4	ANZ10		☐	ANZXX	☐	Number of Incoming Payments during the Period
77	JAH11	KNB4	JAH11		☐	KALJAHR	☐	Calendar Year
78	MON11	KNB4	MON11		☐	KMONA_FI	☐	Calendar Month
79	AGS11	KNB4	AGS11		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
80	VZS11	KNB4	VZS11		☐	VZSXX	☐	Average arrears with cash discount payments
81	AGN11	KNB4	AGN11		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
82	VZN11	KNB4	VZN11		☐	VZNXX	☐	Average arrears with payments without cash discount taken
83	ANZ11	KNB4	ANZ11		☐	ANZXX	☐	Number of Incoming Payments during the Period
84	JAH12	KNB4	JAH12		☐	KALJAHR	☐	Calendar Year
85	MON12	KNB4	MON12		☐	KMONA_FI	☐	Calendar Month
86	AGS12	KNB4	AGS12		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
87	VZS12	KNB4	VZS12		☐	VZSXX	☐	Average arrears with cash discount payments
88	AGN12	KNB4	AGN12		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
89	VZN12	KNB4	VZN12		☐	VZNXX	☐	Average arrears with payments without cash discount taken
90	ANZ12	KNB4	ANZ12		☐	ANZXX	☐	Number of Incoming Payments during the Period
91	JAH13	KNB4	JAH13		☐	KALJAHR	☐	Calendar Year
92	MON13	KNB4	MON13		☐	KMONA_FI	☐	Calendar Month
93	AGS13	KNB4	AGS13		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
94	VZS13	KNB4	VZS13		☐	VZSXX	☐	Average arrears with cash discount payments
95	AGN13	KNB4	AGN13		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
96	VZN13	KNB4	VZN13		☐	VZNXX	☐	Average arrears with payments without cash discount taken
97	ANZ13	KNB4	ANZ13		☐	ANZXX	☐	Number of Incoming Payments during the Period
98	JAH14	KNB4	JAH14		☐	KALJAHR	☐	Calendar Year
99	MON14	KNB4	MON14		☐	KMONA_FI	☐	Calendar Month
100	AGS14	KNB4	AGS14		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
101	VZS14	KNB4	VZS14		☐	VZSXX	☐	Average arrears with cash discount payments
102	AGN14	KNB4	AGN14		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
103	VZN14	KNB4	VZN14		☐	VZNXX	☐	Average arrears with payments without cash discount taken
104	ANZ14	KNB4	ANZ14		☐	ANZXX	☐	Number of Incoming Payments during the Period
105	JAH15	KNB4	JAH15		☐	KALJAHR	☐	Calendar Year
106	MON15	KNB4	MON15		☐	KMONA_FI	☐	Calendar Month
107	AGS15	KNB4	AGS15		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
108	VZS15	KNB4	VZS15		☐	VZSXX	☐	Average arrears with cash discount payments
109	AGN15	KNB4	AGN15		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
110	VZN15	KNB4	VZN15		☐	VZNXX	☐	Average arrears with payments without cash discount taken
111	ANZ15	KNB4	ANZ15		☐	ANZXX	☐	Number of Incoming Payments during the Period
112	JAH16	KNB4	JAH16		☐	KALJAHR	☐	Calendar Year
113	MON16	KNB4	MON16		☐	KMONA_FI	☐	Calendar Month
114	AGS16	KNB4	AGS16		☐	AGSXX	☐	Gross Total of Cleared Items without Cash Discount Loss
115	VZS16	KNB4	VZS16		☐	VZSXX	☐	Average arrears with cash discount payments
116	AGN16	KNB4	AGN16		☐	AGNXX	☐	Gross Total of Cleared Items with Cash Discount Not Taken
117	VZN16	KNB4	VZN16		☐	VZNXX	☐	Average arrears with payments without cash discount taken
118	ANZ16	KNB4	ANZ16		☐	ANZXX	☐	Number of Incoming Payments during the Period
119	AEDAT	BWFI_AEDA3	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
120	AETIM	BWFI_AEDA3	AETIM		☐	CPUTM	☐	Time of data entry

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in