SAP ABAP Table A142 (Dependent on material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE1C (Package) Customizing for Profit Center Accounting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	A142	Table Relationship Diagram
Short Description	Dependent on 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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	DATBI	☑	KODATBI	DATUM	DATS	8	0	Validity end date of the condition record
7	DATAB	☐	KODATAB	DATUM	DATS	8	0	Validity start date of the condition record
8	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	A142	KAPPL	T681A	KAPPL
2	A142	KSCHL	T685	KSCHL
3	A142	MANDT	T000	MANDT
4	A142	MATNR	MARA	MATNR
5	A142	WERKS	T001W	WERKS

History

Last changed by/on	SAP	19980331
SAP Release Created in