SAP ABAP Table KOTE004 (Customer Hierarchy)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VKON (Package) Application development R/3 conditions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KOTE004	Table Relationship Diagram
Short Description	Customer Hierarchy

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KAPPL	☑	KAPPL	KAPPL	CHAR	2	0	Application	T681A
3	KSCHL	☑	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
4	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
5	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
6	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
7	HIENR	☑	KUNNR_KH	KUNNR	CHAR	10	0	Customer	KNA1
8	DATBI	☑	KODATBI	DATUM	DATS	8	0	Validity end date of the condition record
9	KNUMA	☑	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
10	DATAB	☐	KODATAB	DATUM	DATS	8	0	Validity start date of the condition record
11	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KOTE004	HIENR	KNA1	KUNNR	KEY
2	KOTE004	KAPPL	T681A	KAPPL	KEY
3	KOTE004	KNUMA	KONA	KNUMA	KEY
4	KOTE004	KSCHL	T685	KSCHL	KEY
5	KOTE004	MANDT	T000	MANDT	KEY
6	KOTE004	SPART	TSPA	SPART	KEY
7	KOTE004	VKORG	TVKO	VKORG	KEY
8	KOTE004	VTWEG	TVTW	VTWEG	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in