SAP ABAP Table A005 (Customer/Material)

Hierarchy

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

Basic Data

Table Category	POOL	Pooled table
Pooled table	A005	Table Relationship Diagram
Short Description	Customer/Material

Delivery and Maintenance

Pool/cluster	KAPOL
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	KUNNR	☑	KUNNR_V	KUNNR	CHAR	10	0	Customer number	KNA1
7	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	DATBI	☑	KODATBI	DATUM	DATS	8	0	Validity end date of the condition record
9	DATAB	☐	KODATAB	DATUM	DATS	8	0	Validity start date of the condition record
10	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	A005	KAPPL	T681A	KAPPL	KEY
2	A005	KSCHL	T685	KSCHL	KEY
3	A005	KUNNR	KNA1	KUNNR	KEY
4	A005	MANDT	T000	MANDT	KEY
5	A005	MATNR	MARA	MATNR	KEY
6	A005	VKORG	TVKO	VKORG	KEY
7	A005	VTWEG	TVTW	VTWEG	KEY

History

Last changed by/on	SAP	19990318
SAP Release Created in