SAP ABAP Table KOTD020 (EAN/GV Type/Sales org./Distr. Chl/Division/County/Customer)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-MD-CM (Application Component) Conditions
     ⤷ VA-EAN (Package) EAN.UCC functionality

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KOTD020	Table Relationship Diagram
Short Description	EAN/GV Type/Sales org./Distr. Chl/Division/County/Customer

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	☑	KSCHD	KSCHL	CHAR	4	0	Material determination type	T685
4	GTIN	☑	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
5	GTIN_V_TYPE	☑	GTIN_VARIANT_TYPE	GTIN_VARIANT_TYPE	CHAR	1	0	GTIN Variant Type	EANC_GTIN_VT
6	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
9	LAND1	☑	LLAND	LAND1	CHAR	3	0	Destination Country	T005
10	KUNNR	☑	KUNNR_V	KUNNR	CHAR	10	0	Customer number	KNA1
11	DATBI	☑	KODATBI	DATUM	DATS	8	0	Validity end date of the condition record
12	DATAB	☐	KODATAB	DATUM	DATS	8	0	Validity start date of the condition record
13	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	KOTD020	GTIN_V_TYPE	EANC_GTIN_VT	VARIANT_TYPE	KEY	1	CN
2	KOTD020	KAPPL	T681A	KAPPL	KEY
3	KOTD020	KSCHL	T685	KSCHL	KEY
4	KOTD020	KUNNR	KNA1	KUNNR	KEY
5	KOTD020	LAND1	T005	LAND1	KEY
6	KOTD020	MANDT	T000	MANDT	KEY
7	KOTD020	SPART	TSPA	SPART	KEY
8	KOTD020	VKORG	TVKO	VKORG	KEY
9	KOTD020	VTWEG	TVTW	VTWEG	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in	601