SAP Table KNB4

Customer Payment History

KNB4 (Customer Payment History) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KNB4 to other SAP tables.

KNB4 table fields

Field		Data element	Checktable	Datatype	Length	Decimals
MANDT	Client	MANDT	T000	CLNT	3	0
KUNNR	Customer Number	KUNNR	KNA1	CHAR	10	0
BUKRS	Company Code	BUKRS	T001	CHAR	4	0
AUFZD	Date as from when the payment history was recorded	AUFZD		DATS	8	0
JAH01	Calendar Year	KALJAHR		NUMC	4	0
MON01	Calendar Month	KMONA_FI		NUMC	2	0
AGS01	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS01	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN01	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN01	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ01	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH02	Calendar Year	KALJAHR		NUMC	4	0
MON02	Calendar Month	KMONA_FI		NUMC	2	0
AGS02	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS02	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN02	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN02	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ02	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH03	Calendar Year	KALJAHR		NUMC	4	0
MON03	Calendar Month	KMONA_FI		NUMC	2	0
AGS03	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS03	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN03	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN03	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ03	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH04	Calendar Year	KALJAHR		NUMC	4	0
MON04	Calendar Month	KMONA_FI		NUMC	2	0
AGS04	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS04	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN04	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN04	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ04	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH05	Calendar Year	KALJAHR		NUMC	4	0
MON05	Calendar Month	KMONA_FI		NUMC	2	0
AGS05	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS05	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN05	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN05	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ05	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH06	Calendar Year	KALJAHR		NUMC	4	0
MON06	Calendar Month	KMONA_FI		NUMC	2	0
AGS06	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS06	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN06	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN06	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ06	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH07	Calendar Year	KALJAHR		NUMC	4	0
MON07	Calendar Month	KMONA_FI		NUMC	2	0
AGS07	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS07	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN07	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN07	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ07	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH08	Calendar Year	KALJAHR		NUMC	4	0
MON08	Calendar Month	KMONA_FI		NUMC	2	0
AGS08	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS08	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN08	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN08	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ08	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH09	Calendar Year	KALJAHR		NUMC	4	0
MON09	Calendar Month	KMONA_FI		NUMC	2	0
AGS09	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS09	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN09	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN09	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ09	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH10	Calendar Year	KALJAHR		NUMC	4	0
MON10	Calendar Month	KMONA_FI		NUMC	2	0
AGS10	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS10	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN10	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN10	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ10	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH11	Calendar Year	KALJAHR		NUMC	4	0
MON11	Calendar Month	KMONA_FI		NUMC	2	0
AGS11	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS11	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN11	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN11	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ11	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH12	Calendar Year	KALJAHR		NUMC	4	0
MON12	Calendar Month	KMONA_FI		NUMC	2	0
AGS12	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS12	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN12	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN12	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ12	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH13	Calendar Year	KALJAHR		NUMC	4	0
MON13	Calendar Month	KMONA_FI		NUMC	2	0
AGS13	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS13	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN13	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN13	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ13	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH14	Calendar Year	KALJAHR		NUMC	4	0
MON14	Calendar Month	KMONA_FI		NUMC	2	0
AGS14	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS14	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN14	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN14	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ14	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH15	Calendar Year	KALJAHR		NUMC	4	0
MON15	Calendar Month	KMONA_FI		NUMC	2	0
AGS15	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS15	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN15	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN15	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ15	Number of Incoming Payments during the Period	ANZXX		DEC	3	0
JAH16	Calendar Year	KALJAHR		NUMC	4	0
MON16	Calendar Month	KMONA_FI		NUMC	2	0
AGS16	Gross Total of Cleared Items without Cash Discount Loss	AGSXX		CURR	15	2
VZS16	Average arrears with cash discount payments	VZSXX		DEC	3	0
AGN16	Gross Total of Cleared Items with Cash Discount Not Taken	AGNXX		CURR	15	2
VZN16	Average arrears with payments without cash discount taken	VZNXX		DEC	3	0
ANZ16	Number of Incoming Payments during the Period	ANZXX		DEC	3	0

KNB4 foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
KNB4	BUKRS	KNB4	MANDT	T001	Company Codes	MANDT
KNB4	BUKRS	KNB4	BUKRS	T001	Company Codes	BUKRS
KNB4	KUNNR	KNB4	MANDT	KNA1	General Data in Customer Master	MANDT
KNB4	KUNNR	KNB4	KUNNR	KNA1	General Data in Customer Master	KUNNR
KNB4	MANDT	KNB4	MANDT	T000	Clients	MANDT