SAP KNVH Customer Hierarchies Table data and field list

KNVH is a standard SAP Table which is used to store Customer Hierarchies data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The KNVH table consists of various fields, each holding specific information or linking keys about Customer Hierarchies data available in SAP. These include HITYP (Customer hierarchy type), KUNNR (Customer), VKORG (Sales Organization), VTWEG (Distribution Channel)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

KNVH table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP KNVH table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the KNVH table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
HITYP	Customer hierarchy type	HITYP_KH	CHAR	1	THIT		HITYP
KUNNR	Customer	KUNNR_KH	CHAR	10	KNA1	ALPHA	KUNNR	VHI
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	TSPA		SPART	SPA	C_SPART
DATAB	Start of validity period for assignment	DATAB_KH	DATS	8			DATUM
DATBI	End of validity period for the assignment	DATBI_KH	DATS	8			DATUM
HKUNNR	Customer number of the higher-level customer hierarchy	HKUNNR_KH	CHAR	10	KNA1	ALPHA	KUNNR
HVKORG	Higher-level sales organization	HVKORG	CHAR	4	TVKO		VKORG	VKO
HVTWEG	Higher-level distribution channel	HVTWEG	CHAR	2	TVTW		VTWEG	VTW
HSPART	Higher-level division	HSPART	CHAR	2	TSPA		SPART	SPA
GRPNO	Number of the routine used for copying	GRPNO	NUMC	3	Assigned to domain		GRPNO
BOKRE	Indicator: Customer Is Rebate-Relevant	BOKRE	CHAR	1			XFELD
PRFRE	Relevant for price determination ID	PRFRE	CHAR	1			XFELD
HZUOR	Assignment to Hierarchy	HZUOR	NUMC	2			HZUOR

Key field

Non-key field

< KNVD_KEY_S - Key: Document Request Sales for Customer with Client KNVH_APPL_LOG - Structure for Error Log in Customer Hierarchy >

How do I retrieve data from SAP table KNVH using ABAP code

The following ABAP code Example will allow you to do a basic selection on KNVH to SELECT all data from the table
DATA: WA_KNVH TYPE KNVH.

SELECT SINGLE *
FROM KNVH
INTO CORRESPONDING FIELDS OF WA_KNVH
WHERE...

How to access SAP table KNVH

Within an ECC or HANA version of SAP you can also view further information about KNVH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).