SAP ABAP Table IOOPMST (Database structure for order trigger points)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COIS (Package) Order Information System

Basic Data

Table Category	INTTAB	Structure
Structure	IOOPMST	Table Relationship Diagram
Short Description	Database structure for order trigger points

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	Milestone
2	MLST_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MLST_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
4	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	.INCLUDE	☐				0	0	Milestone (include structure)
6	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
7	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
8	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
9	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
10	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
11	USERH	☐	MLST_USERH	UNAME	CHAR	12	0	Milestone created by
12	DATEH	☐	MLST_DATEH	DATUM	DATS	8	0	Milestone created on
13	USERV	☐	MLST_USERV	UNAME	CHAR	12	0	Milestone changed by
14	DATEV	☐	MLST_DATEV	DATUM	DATS	8	0	Milestone changed on
15	PLNNR	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
16	PLNTY	☐	CN_PLNTY	PLNTY	CHAR	1	0	Standard network type	TCA01
17	PLNAL	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
18	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
19	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
20	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
21	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
22	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
23	TEDAT	☐	MLST_TEDAT	DATUM	DATS	8	0	Scheduled milestone date (Basic)
24	TETIM	☐	MLST_TETIM	ATIME	TIMS	6	0	Scheduled milestone time (Basic)
25	TPDAT	☐	MLST_TPDAT	DATUM	DATS	8	0	Scheduled milestone date (Forecast)
26	TPTIM	☐	MLST_TPTIM	ATIME	TIMS	6	0	Scheduled milestone time (Forecast)
27	EDATU	☐	MLST_EDATU	DATUM	DATS	8	0	Fixed milestone date (basic)
28	EZEIT	☐	MLST_EZEIT	ATIME	TIMS	6	0	Fixed milestone time (Basic)
29	PDATU	☐	MLST_PDATU	DATUM	DATS	8	0	Fixed milestone date (F)
30	PZEIT	☐	MLST_PZEIT	ATIME	TIMS	6	0	Fixed milestone time (F)
31	LATED	☐	MLST_LATE	FLAG	CHAR	1	0	Indicator: Latest dates
32	DLTAS	☐	MLST_DLTAS	FLAG	CHAR	1	0	Ind: Reference for offset (start/finish activity date)
33	DELTA	☐	MLST_DELTA	VNZTV	QUAN	5	0	Offset for milestone date
34	DELTE	☐	MLST_DELTE	MEINS	UNIT	3	0	Time unit for offset of milestone date	T006
35	PRCNT	☐	MLST_PRCNT	MLST_PRCNT	DEC	3	0	Percentual offset of milestone to activity date
36	SDDAT	☐	MLST_SDDAT	MLST_SDDAT	CHAR	2	0	Key determining the date for milestone in sales order
37	KZ_TREND	☐	MLST_TREND	FLAG	CHAR	1	0	Milestone relevant for trend analysis
38	KZ_LSTWR	☐	MLST_LSTWR	FLAG	CHAR	1	0	Milestone relevant for progress analysis
39	KZ_WFLOW	☐	MLST_WFLOW	FLAG	CHAR	1	0	Indicator: Milestone is used for milestone functions
40	KZ_FAKTP	☐	MLST_FAKTP	FLAG	CHAR	1	0	Milestone is relevant for date in sales document
41	KZ_FRMST	☐	MLST_FRMST	FLAG	CHAR	1	0	Release stop indicator
42	LST_FERTG	☐	MLST_FERTG	PROZENT100	NUMC	3	0	Percentage of completion (%)
43	LST_ACTDT	☐	MLST_ACTDT	DATUM	DATS	8	0	Actual date (Milestone met)
44	LST_ACTTM	☐	MLST_ACTTM	ATIME	TIMS	6	0	Actual date/time (Milestone met)
45	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
46	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
47	AUART_ICNW	☐	MLST_AUART	AUFART	CHAR	4	0	Network type	T003O
48	STDNR_ICNW	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
49	ALTNR_ICNW	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
50	STDNR_ICPN	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
51	ALTNR_ICPN	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
52	VORNR_ICPN	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
53	STDNR_ICSN	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
54	ALTNR_ICSN	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
55	OPRST_ICSN	☐	OPR_START	VORNR	CHAR	4	0	Activity preceding the standard network to be included
56	OPREN_ICSN	☐	OPR_END	VORNR	CHAR	4	0	Activity following the standard network to be included
57	TASK_ID	☐	MLST_TASK	HROBJEC_14	CHAR	14	0	Workflow task
58	RELSU	☐	MLST_RELSU	FLAG	CHAR	1	0	Selection function
59	RELMS	☐	MLST_RELMS	FLAG	CHAR	1	0	Selection function
60	INCPN	☐	MLST_INCPN	FLAG	CHAR	1	0	Selection function
61	INCNW	☐	MLST_INCNW	FLAG	CHAR	1	0	Selection function
62	INCSN	☐	MLST_INCSN	FLAG	CHAR	1	0	Selection function
63	WKFLW	☐	MLST_WKFLW	FLAG	CHAR	1	0	Selection function
64	RELSU_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
65	RELMS_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
66	INCPN_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
67	INCNW_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
68	INCSN_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
69	WKFLW_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
70	RELSU_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
71	RELMS_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
72	INCPN_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
73	INCNW_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
74	INCSN_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
75	WKFLW_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
76	RELSU_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
77	RELMS_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
78	INCPN_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
79	INCNW_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
80	INCSN_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
81	WKFLW_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
82	RELSU_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
83	RELMS_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
84	INCPN_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
85	INCNW_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
86	INCSN_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
87	WKFLW_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
88	RELSU_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
89	RELMS_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
90	INCPN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
91	INCNW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
92	INCSN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
93	WKFLW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
94	RELSU_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
95	RELMS_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
96	INCPN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
97	INCNW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
98	INCSN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
99	WKFLW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
100	RELSU_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
101	RELMS_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
102	INCPN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
103	INCNW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
104	INCSN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
105	WKFLW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
106	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
107	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
108	SPSNR	☐	PS_SPSNR	PS_SPSNR	NUMC	8	0	Std WBS: Internal project item number (w/exit on ID)	PRPSS
109	FPROZ	☐	FPROZ	PRZ32	DEC	5	2	Percentage of value to be billed
110	COMP_RES	☐	OCM_COMP_RES	OCM_COMP_RES	CHAR	1	0	OCM: Result of comparison of two order objects
111	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
112	.INCLUDE	☐				0	0	Milestone Description
113	MLTX_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
114	MLTX_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
115	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
116	AEND_ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
117	.INCLUDE	☐				0	0	Milestone Description
118	KTEXT	☐	MLST_KTEXT	TEXT40	CHAR	40	0	Description
119	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
120	SSTA	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
121	ASTA	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
122	ACTLV	☐	MLST_ACTLV	CHAR25	CHAR	25	0	Processing stage of the function
123	RELSU_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
124	RELMS_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
125	INCNW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
126	INCPN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
127	INCSN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
128	WKFLW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
129	RELSU_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
130	RELMS_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
131	INCNW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
132	INCPN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
133	INCSN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
134	WKFLW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
135	FKT_RELSU	☐	MLST_FUNC1	TEXT35	CHAR	35	0	Description of the milestone function
136	FKT_RELMS	☐	MLST_FUNC2	TEXT35	CHAR	35	0	Description of the milestone function
137	FKT_INCSN	☐	MLST_FUNC3	TEXT35	CHAR	35	0	Description of the milestone function
138	FKT_INCNW	☐	MLST_FUNC4	TEXT35	CHAR	35	0	Description of the milestone function
139	FKT_INCPN	☐	MLST_FUNC5	TEXT35	CHAR	35	0	Description of the milestone function
140	FKT_WFLOW	☐	MLST_FUNC6	TEXT35	CHAR	35	0	Description of the milestone function
141	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
142	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
143	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
144	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
145	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOOPMST	AENNR	AENR	AENNR
2	IOOPMST	AUART_ICNW	T003O	AUART
3	IOOPMST	DELTE	T006	MSEHI
4	IOOPMST	INCNW_SM	TJ48	SELID
5	IOOPMST	INCPN_SM	TJ48	SELID
6	IOOPMST	INCSN_SM	TJ48	SELID
7	IOOPMST	LANGU	T002	SPRAS
8	IOOPMST	LTXSP	T002	SPRAS
9	IOOPMST	MLSTN	T433	MLSTN
10	IOOPMST	MLST_MANDT	T000	MANDT
11	IOOPMST	MLTX_MANDT	T000	MANDT
12	IOOPMST	PLNTY	TCA01	PLNTY
13	IOOPMST	PSPNR	PRPS	PSPNR
14	IOOPMST	RELMS_SM	TJ48	SELID
15	IOOPMST	RELSU_SM	TJ48	SELID
16	IOOPMST	SPSNR	PRPSS	PSPNR	REF	C	CN
17	IOOPMST	STSMA	TJ20	STSMA
18	IOOPMST	WKFLW_SM	TJ48	SELID

History

Last changed by/on	SAP	20130529
SAP Release Created in