Name: SAP Table KNB5 |Field Definitions and Relationships
Creator: QueryViz.io

fields (15)

field	type	length	key	description
`BUKRS`	char	4	pk	company code
`KUNNR`	char	10	pk	customer number
`MABER`	char	2	pk	dunning area (subdivision of company code for dunning; blank = company code level)
`MANDT`	clnt	3	pk	client
`GRUPP`	char	10		dunning recipient customer number (if dunning notices go to a different customer)
`LOEVM`	char	1		deletion flag for dunning data
`MADAT`	dats	8		date of last dunning notice
`MAHDT`	dats	8		last dunned date
`MAHNA`	char	4		dunning procedure (e.g., 0001=standard 4-level dunning)
`MAHND`	dats	8		date of last dunning notice
`MAHNL`	numc	2		dunning level of last dunning notice (1=first reminder, 4=final demand, etc.)
`MAHNS`	numc	1		dunning level
`MAHNZ`	numc	2		number of dunning notices run
`MANSP`	char	1		dunning block
`XDUNL`	char	1		lock key for dunning (x=customer locked from dunning runs)

relationships (2)

configuration

reference to config tables

references

master lookup

reference to master data

references

field	type	length	key	description
`BUKRS`	char	4	pk	company code
`KUNNR`	char	10	pk	customer number
`MABER`	char	2	pk	dunning area (subdivision of company code for dunning; blank = company code level)
`MANDT`	clnt	3	pk	client
`GRUPP`	char	10		dunning recipient customer number (if dunning notices go to a different customer)
`LOEVM`	char	1		deletion flag for dunning data
`MADAT`	dats	8		date of last dunning notice
`MAHDT`	dats	8		last dunned date
`MAHNA`	char	4		dunning procedure (e.g., 0001=standard 4-level dunning)
`MAHND`	dats	8		date of last dunning notice
`MAHNL`	numc	2		dunning level of last dunning notice (1=first reminder, 4=final demand, etc.)
`MAHNS`	numc	1		dunning level
`MAHNZ`	numc	2		number of dunning notices run
`MANSP`	char	1		dunning block
`XDUNL`	char	1		lock key for dunning (x=customer locked from dunning runs)

configuration

reference to config tables

references

master lookup

reference to master data

references