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

fields (15)

field	type	length	key	description
`DATAB`	dats	8	pk	validity start date
`HKUNNR`	char	10	pk	hierarchy customer number (the parent/node in the hierarchy)
`MANDT`	clnt	3	pk	client
`SPART`	char	2	pk	division
`VKORG`	char	4	pk	sales organization
`VTWEG`	char	2	pk	distribution channel
`BOKRE`	char	1		indicator: customer is rebate-relevant
`DATBI`	dats	8		validity end date
`GRESSION`	numc	2		hierarchy level
`GRPNO`	numc	3		number of the routine used for copying
`HITYP`	char	1		hierarchy type (a=price-relevant, b=stats only, etc.)
`HSPART`	char	2		higher-level division
`HVKORG`	char	4		higher-level sales organization
`HVTWEG`	char	2		higher-level distribution channel
`KUNNR`	char	10		customer number (the child/leaf customer assigned to this hierarchy node)

relationships (4)

master lookup

reference to master data

references

configuration

reference to config tables

references

field	type	length	key	description
`DATAB`	dats	8	pk	validity start date
`HKUNNR`	char	10	pk	hierarchy customer number (the parent/node in the hierarchy)
`MANDT`	clnt	3	pk	client
`SPART`	char	2	pk	division
`VKORG`	char	4	pk	sales organization
`VTWEG`	char	2	pk	distribution channel
`BOKRE`	char	1		indicator: customer is rebate-relevant
`DATBI`	dats	8		validity end date
`GRESSION`	numc	2		hierarchy level
`GRPNO`	numc	3		number of the routine used for copying
`HITYP`	char	1		hierarchy type (a=price-relevant, b=stats only, etc.)
`HSPART`	char	2		higher-level division
`HVKORG`	char	4		higher-level sales organization
`HVTWEG`	char	2		higher-level distribution channel
`KUNNR`	char	10		customer number (the child/leaf customer assigned to this hierarchy node)

master lookup

reference to master data

references

configuration

reference to config tables

references