SAP Table A147

Customer Hierarchy (Sales Deal)

The table A147 (Customer Hierarchy (Sales Deal)) is a standard table in SAP ERP. It belongs to the package VF.

Technical Information

Table	A147
Short Text	Customer Hierarchy (Sales Deal)
Package	VF
Table Type	Transparent Table

Fields for Table A147

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
KAPPL	✔	Application	KAPPL	CHAR	2	T681A
KSCHL	✔	Condition type	KSCHA	CHAR	4	T685
VKORG	✔	Sales Organization	VKORG	CHAR	4	TVKO
VTWEG	✔	Distribution Channel	VTWEG	CHAR	2	TVTW
SPART	✔	Division	SPART	CHAR	2	TSPA
VKBUR	✔	Sales Office	VKBUR	CHAR	4	TVBUR
VKGRP	✔	Sales Group	VKGRP	CHAR	3	TVKGR
KDGRP	✔	Customer group	KDGRP	CHAR	2	T151
KUNRG	✔	Payer	KUNRG	CHAR	10	KNA1
KUNAG	✔	Sold-to party	KUNAG	CHAR	10	KNA1
KUNWE	✔	Ship-to party	KUNWE	CHAR	10	KNA1
KNUMA_AG	✔	Sales deal	KNUMA_AG	CHAR	10	KONA
DATBI	✔	Validity end date of the condition record	KODATBI	DATS	8
DATAB		Validity start date of the condition record	KODATAB	DATS	8
KEXCL_D		Indicator condition exclusive	KEXCL	CHAR	1
KNUMH		Condition record number	KNUMH	CHAR	10