SAP ABAP Table MAPL (Assignment of Task Lists to Materials)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CP (Package) R/3 Application development: PP Task Lists

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MAPL	Table Relationship Diagram
Short Description	Assignment of Task Lists to Materials

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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	PLNTY	☑	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
5	PLNNR	☑	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
6	PLNAL	☑	PLNAL	ALTNR	CHAR	2	0	Group Counter
7	ZKRIZ	☑	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
8	ZAEHL	☑	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
9	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
10	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
11	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
12	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
13	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
14	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
15	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
16	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
19	KUNR	☐	CPKUNR	KUNNR	CHAR	10	0	Account number of customer	KNA1
20	SUCHFELD	☐	QSUCHFELD	CHAR20	CHAR	20	0	Search Field for Customer-Specific Task List Selection
21	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
22	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
23	PSPNR	☐	CS_PSPNR	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	*
24	.INCLUDE	☐				0	0
25	MS_OBJECT	☐	Q_MS_OBJECT	Q_MS_OBJECT	CHAR	30	0	Object for Multiple Specifications	TQMS2
26	MS_OBJTYPE	☐	Q_MS_OBJTYPE	Q_MS_OBJTYPE	CHAR	2	0	Type of Object for Multiple Specifications	TQMS1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MAPL	AENNR	AENR	AENNR	REF	1	N
2	MAPL	KUNR	KNA1	KUNNR	REF	1	N
3	MAPL	LIFNR	LFA1	LIFNR	REF	1	N
4	MAPL	MANDT	T000	MANDT	KEY	1	CN
5	MAPL	MATNR	MARA	MATNR	KEY	1	CN
6	MAPL	MS_OBJECT	TQMS2	OBJECT	KEY	1	CN
7	MAPL	MS_OBJTYPE	TQMS1	OBJECTTYPE	KEY	1	CN
8	MAPL	PLNTY	TCA01	PLNTY	KEY	1	CN
9	MAPL	POSNR	VBUP	POSNR	REF	1	CN
10	MAPL	VBELN	VBUK	VBELN	REF	1	CN
11	MAPL	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050705
SAP Release Created in