SAP ABAP Table KOTE001 (Customer/Material)

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	KOTE001	Table Relationship Diagram
Short Description	Customer/Material

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	KUNNR	☑	KUNNR_V	KUNNR	CHAR	10	0	Customer number	KNA1
8	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	DATBI	☑	KODATBI	DATUM	DATS	8	0	Validity end date of the condition record
10	KNUMA	☑	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
11	DATAB	☐	KODATAB	DATUM	DATS	8	0	Validity start date of the condition record
12	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	KOTE001	KAPPL	T681A	KAPPL	KEY
2	KOTE001	KNUMA	KONA	KNUMA	KEY
3	KOTE001	KSCHL	T685	KSCHL	KEY
4	KOTE001	KUNNR	KNA1	KUNNR	KEY
5	KOTE001	MANDT	T000	MANDT	KEY
6	KOTE001	MATNR	MARA	MATNR	KEY
7	KOTE001	SPART	TSPA	SPART	KEY
8	KOTE001	VKORG	TVKO	VKORG	KEY
9	KOTE001	VTWEG	TVTW	VTWEG	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in