SAP ABAP Table /ISDFPS/TLUPS_MAPL (DFPS: Assignment of Plan to Material - UPS Distribution)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/TLUPS_MAPL	Table Relationship Diagram
Short Description	DFPS: Assignment of Plan to Material - UPS Distribution

Delivery and Maintenance

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

History

Last changed by/on	SAP	20050705
SAP Release Created in	470