SAP ABAP Table A412 (Vendor/Plant/Material/Base Product)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIA (Package) Exg exchanges

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	A412	Table Relationship Diagram
Short Description	Vendor/Plant/Material/Base Product

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	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
5	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	OIBASPROD	☑	OIA_SBMAT	MATNR	CHAR	18	0	Base product 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	A412	KAPPL	T681A	KAPPL	KEY
2	A412	KSCHL	T685	KSCHL	KEY
3	A412	LIFNR	LFA1	LIFNR	KEY
4	A412	MANDT	T000	MANDT	KEY
5	A412	MATNR	MARA	MATNR	KEY
6	A412	OIBASPROD	MARA	MATNR	KEY
7	A412	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in