KNB4 - Customer Payment History

Customer Payment History information is stored in SAP table KNB4.
It is part of development package VSCORE in software component LO-MD-BP-CM. This development package consists of objects that can be grouped under "Application development R/3 sales master data".

Fields for table KNB4

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
KUNNR	Customer Number	X	KUNNR	CHAR	20	KNA1
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
AUFZD	Date as from When the Payment History Was Recorded		AUFZD	DATS	16
JAH01	Calendar Year		KALJAHR	NUMC	8
MON01	Calendar Month		KMONA_FI	NUMC	4
AGS01	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS01	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN01	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN01	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ01	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH02	Calendar Year		KALJAHR	NUMC	8
MON02	Calendar Month		KMONA_FI	NUMC	4
AGS02	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS02	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN02	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN02	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ02	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH03	Calendar Year		KALJAHR	NUMC	8
MON03	Calendar Month		KMONA_FI	NUMC	4
AGS03	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS03	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN03	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN03	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ03	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH04	Calendar Year		KALJAHR	NUMC	8
MON04	Calendar Month		KMONA_FI	NUMC	4
AGS04	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS04	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN04	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN04	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ04	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH05	Calendar Year		KALJAHR	NUMC	8
MON05	Calendar Month		KMONA_FI	NUMC	4
AGS05	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS05	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN05	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN05	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ05	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH06	Calendar Year		KALJAHR	NUMC	8
MON06	Calendar Month		KMONA_FI	NUMC	4
AGS06	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS06	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN06	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN06	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ06	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH07	Calendar Year		KALJAHR	NUMC	8
MON07	Calendar Month		KMONA_FI	NUMC	4
AGS07	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS07	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN07	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN07	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ07	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH08	Calendar Year		KALJAHR	NUMC	8
MON08	Calendar Month		KMONA_FI	NUMC	4
AGS08	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS08	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN08	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN08	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ08	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH09	Calendar Year		KALJAHR	NUMC	8
MON09	Calendar Month		KMONA_FI	NUMC	4
AGS09	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS09	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN09	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN09	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ09	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH10	Calendar Year		KALJAHR	NUMC	8
MON10	Calendar Month		KMONA_FI	NUMC	4
AGS10	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS10	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN10	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN10	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ10	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH11	Calendar Year		KALJAHR	NUMC	8
MON11	Calendar Month		KMONA_FI	NUMC	4
AGS11	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS11	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN11	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN11	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ11	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH12	Calendar Year		KALJAHR	NUMC	8
MON12	Calendar Month		KMONA_FI	NUMC	4
AGS12	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS12	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN12	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN12	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ12	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH13	Calendar Year		KALJAHR	NUMC	8
MON13	Calendar Month		KMONA_FI	NUMC	4
AGS13	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS13	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN13	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN13	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ13	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH14	Calendar Year		KALJAHR	NUMC	8
MON14	Calendar Month		KMONA_FI	NUMC	4
AGS14	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS14	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN14	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN14	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ14	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH15	Calendar Year		KALJAHR	NUMC	8
MON15	Calendar Month		KMONA_FI	NUMC	4
AGS15	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS15	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN15	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN15	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ15	Number of Incoming Payments During the Period		ANZXX	DEC	2
JAH16	Calendar Year		KALJAHR	NUMC	8
MON16	Calendar Month		KMONA_FI	NUMC	4
AGS16	Gross Total of Cleared Items Without Cash Discount Loss		AGSXX_CS	CURR	8
VZS16	Average Arrears with Cash Discount Payments		VZSXX	DEC	2
AGN16	Gross Total of Cleared Items with Cash Discount Not Taken		AGNXX_CS	CURR	8
VZN16	Average Arrears for Payments Where No Cash Discount Taken		VZNXX	DEC	2
ANZ16	Number of Incoming Payments During the Period		ANZXX	DEC	2