SAP ABAP Table MCAFVGB (Order Operation)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-IS (Application Component) Information System
     ⤷ MCF (Package) R/3 application development: Shop Floor Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCAFVGB	Table Relationship Diagram
Short Description	Order Operation

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	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	.INCLUDE	☐				0	0	Order Operation
3	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
4	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
6	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
7	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
8	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
9	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	TC26
10	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	KAKO
11	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
14	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
15	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
16	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
17	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
18	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
19	VERTL	☐	VERTEILUNG	VERTEILUNG	CHAR	2	0	Distribution function for capacity requirements	T498
20	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
21	MGVRG	☐	MC_MGVRG	MENGV15	QUAN	15	3	Operation quantity
22	ASVRG	☐	MC_ASVRG	MENGV15	QUAN	15	3	Operation scrap
23	LMNGA	☐	MC_LMNGA	MENGV15	QUAN	15	3	Total quantity confirmed
24	XMNGA	☐	MC_XMNGA	MENGV15	QUAN	15	3	Total scrap quantity confirmed
25	GMNGA	☐	MC_GMNGA	MENGV15	QUAN	15	3	Total Delivered Lot Size
26	SSADD	☐	SSADD	DATUM	DATS	8	0	Latest target input date
27	IADD	☐	IADD	DATUM	DATS	8	0	Actual input date
28	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
29	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
30	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
31	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
32	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
33	ISAVD	☐	ISAVD	DATUM	DATS	8	0	Actual operation start (date)
34	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
35	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
36	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
37	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
38	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
39	IEAVD	☐	IEAVD	DATUM	DATS	8	0	Actual finish of operation (date)
40	N_IEAVD	☐	N_IEAVD	DATUM	DATS	8	0	Actual end of successor operation
41	WARTZ	☐	MC_WARTZ	DAUER_6_1V	QUAN	7	1	Queue time used for scheduling
42	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
43	RUEST	☐	MC_RUEST	DAUER_6_1V	QUAN	7	1	Scheduled setup time
44	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
45	BEARZ	☐	MC_BEARZ	DAUER_6_1V	QUAN	7	1	Scheduled processing time
46	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
47	ABRUE	☐	MC_ABRUE	DAUER_6_1V	QUAN	7	1	Scheduled teardown time
48	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
49	LIEGZ	☐	MC_LIEGZ	DAUER_6_1V	QUAN	7	1	Wait time used for scheduling
50	V_LIEGZ	☐	MC_LIEGZ	DAUER_6_1V	QUAN	7	1	Wait time used for scheduling
51	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
52	TRANZ	☐	MC_TRANZ	DAUER_6_1V	QUAN	7	1	Move time used for scheduling
53	KRUES	☐	MC_KRUES	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment "setup"
54	KBEAS	☐	MC_KBEAS	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment "processing"
55	KABRS	☐	MC_KABRS	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment teardown
56	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
57	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
58	DFZEH	☐	DFZEH	EINHEIT	UNIT	3	0	Unit of measure for execution time
59	S_DFZ	☐	S_DFZ	DAUER_6_1V	QUAN	7	1	Target execution time
60	I_DFZ	☐	I_DFZ	DAUER_6_1V	QUAN	7	1	Actual execution time
61	KAPKZ	☐	KAPKZ	X	CHAR	1	0	SFIS indicator for cumulative updating of capacity data
62	PLCHK1V	☐	MC_PLCHK1V	CHAR1	CHAR	1	0	Plausibility check: operation without actual input
63	PLCHK2V	☐	MC_PLCHK2V	CHAR1	CHAR	1	0	Plausibility Check: Actual Finish of Op. before Actual input
64	PLCHK3V	☐	MC_PLCHK3V	CHAR1	CHAR	1	0	Plausibility check: invalid milestone confirmation
65	VDATU	☐	MC_VDATUM	DATUM	DATS	8	0	Date of update for statistics updating
66	BUDAT	☐	MC_BUCHDAT	DATUM	DATS	8	0	Posting date of last confirmation
67	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
68	VGE01	☐	MCVGWRTEH1	MEINS	UNIT	3	0	Unit of measure for standard value 1	*
69	SMNG1	☐	MCSMNG1	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 1
70	ZMNG1	☐	MCZMNG1	MENGV15	QUAN	15	3	Target quantity of activity type 1
71	ZMNG1OZ	☐	MCZMNG1OZ	MENGV15	QUAN	15	3	Target quantity/activity type 1 w/o perfmnce efficiency rate
72	VGE02	☐	MCVGWRTEH2	MEINS	UNIT	3	0	Unit of measure for standard value 2	*
73	SMNG2	☐	MCSMNG2	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 2
74	ZMNG2	☐	MCZMNG2	MENGV15	QUAN	15	3	Target quantity of activity type 2
75	ZMNG2OZ	☐	MCZMNG2OZ	MENGV15	QUAN	15	3	Target quantity/activity type 2 w/o perfmnce efficiency rate
76	VGE03	☐	MCVGWRTEH3	MEINS	UNIT	3	0	Unit of measure for standard value 3	*
77	SMNG3	☐	MCSMNG3	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 3
78	ZMNG3	☐	MCZMNG3	MENGV15	QUAN	15	3	Target quantity of activity type 3
79	ZMNG3OZ	☐	MCZMNG3OZ	MENGV15	QUAN	15	3	Target quantity/activity type 3 w/o perfmnce efficiency rate
80	VGE04	☐	MCVGWRTEH4	MEINS	UNIT	3	0	Unit of measure for standard value 4	*
81	SMNG4	☐	MCSMNG4	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 4
82	ZMNG4	☐	MCZMNG4	MENGV15	QUAN	15	3	Target quantity of activity type 4
83	ZMNG4OZ	☐	MCZMNG4OZ	MENGV15	QUAN	15	3	Target quantity/activity type 4 w/o perfmnce efficiency rate
84	VGE05	☐	MCVGWRTEH5	MEINS	UNIT	3	0	Unit of measure for standard value 5	*
85	SMNG5	☐	MCSMNG5	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 5
86	ZMNG5	☐	MCZMNG5	MENGV15	QUAN	15	3	Target quantity of activity type 5
87	ZMNG5OZ	☐	MCZMNG5OZ	MENGV15	QUAN	15	3	Target quantity/activity type 5 w/o perfmnce efficiency rate
88	VGE06	☐	MCVGWRTEH6	MEINS	UNIT	3	0	Unit of measure for standard value 6	*
89	SMNG6	☐	MCSMNG6	MENGV15	QUAN	15	3	Quantity to be confirmed for activity type 6
90	ZMNG6	☐	MCZMNG6	MENGV15	QUAN	15	3	Target quantity of activity type 6
91	ZMNG6OZ	☐	MCZMNG6OZ	MENGV15	QUAN	15	3	Target quantity/activity type 6 w/o perfmnce efficiency rate
92	ILE01	☐	MCISMEH1	MEINS	UNIT	3	0	Unit of measure for 1st activity to be confirmed	*
93	ISM01	☐	MCRUMNG1	MENGV15	QUAN	15	3	Confirmed activity 1 - activity type
94	ILE02	☐	MCISMEH2	MEINS	UNIT	3	0	Unit of measure for 2nd activity to be confirmed	*
95	ISM02	☐	MCRUMNG2	MENGV15	QUAN	15	3	Confirmed activity 2 - activity type
96	ILE03	☐	MCISMEH3	MEINS	UNIT	3	0	Unit of measure for 3rd activity to be confirmed	*
97	ISM03	☐	MCRUMNG3	MENGV15	QUAN	15	3	Confirmed activity 3 - activity type
98	ILE04	☐	MCISMEH4	MEINS	UNIT	3	0	Unit of measure for 4th activity to be confirmed	*
99	ISM04	☐	MCRUMNG4	MENGV15	QUAN	15	3	Confirmed activity 4 - activity type
100	ILE05	☐	MCISMEH5	MEINS	UNIT	3	0	Unit of measure for 5th activity to be confirmed	*
101	ISM05	☐	MCRUMNG5	MENGV15	QUAN	15	3	Confirmed activity 5 - activity type
102	ILE06	☐	MCISMEH6	MEINS	UNIT	3	0	Unit of measure for 6th activity to be confirmed	*
103	ISM06	☐	MCRUMNG6	MENGV15	QUAN	15	3	Confirmed activity - activity type 6
104	LSTEFF1	☐	MC_LSTEFF1	MENGV15	QUAN	15	3	Efficiency of activity type 1
105	LSTEFF2	☐	MC_LSTEFF2	MENGV15	QUAN	15	3	Efficiency of activity type 2
106	LSTEFF3	☐	MC_LSTEFF3	MENGV15	QUAN	15	3	Efficiency of activity type 3
107	LSTEFF4	☐	MC_LSTEFF4	MENGV15	QUAN	15	3	Efficiency of activity type 4
108	LSTEFF5	☐	MC_LSTEFF5	MENGV15	QUAN	15	3	Efficiency of activity type 4
109	LSTEFF6	☐	MC_LSTEFF6	MENGV15	QUAN	15	3	Efficiency of activity type 6
110	ZGR01	☐	MC_ZGR01	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 1
111	ZGR02	☐	MC_ZGR02	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 2
112	ZGR03	☐	MC_ZGR03	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 3
113	ZGR04	☐	MC_ZGR04	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 4
114	ZGR05	☐	MC_ZGR05	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 5
115	ZGR06	☐	MC_ZGR06	PROZENT101	DEC	11	1	Target performance efficiency rate for activity type 6
116	VG_FREI	☐	MC_VG_FREI	X	CHAR	1	0	Operation has status RELEASED
117	VG_RUECK	☐	MC_VG_RUECK	X	CHAR	1	0	Operation has status CONFIRMED
118	VG_TRUEC	☐	MC_VG_TRUEC	X	CHAR	1	0	Operation has status PARTIALLY CONFIRMED
119	VG_RMAN	☐	MC_VG_RMAN	X	CHAR	1	0	Operation has status RMAN
120	VERAN	☐	AP_VERAN	AP_VERAN	CHAR	3	0	Person responsible for the work center	*
121	PLANR	☐	KAPPLANER	KAPPLANER	CHAR	3	0	Capacity planner group	*
122	DFZEXEH	☐	DFZEXEH	EINHEIT	UNIT	3	0	Unit for execution time (exact)
123	S_DFZ_EX	☐	S_DFZ_EX	DAUER_10_2V	QUAN	12	2	Target execution time (exact)
124	I_DFZ_EX	☐	I_DFZ_EX	DAUER_10_2V	QUAN	12	2	Actual execution time (exact)
125	SSADZ	☐	SSADZ	ATIME	TIMS	6	0	Latest target input (time of day)
126	IADZ	☐	IADZ	ATIME	TIMS	6	0	Actual input (time of day)
127	REFOP24	☐	REFOP24	REFOP24	CHAR	24	0	Reference operation set
128	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
129	VPLTY	☐	VPLTY	PLNTY	CHAR	1	0	Task list type for reference	*
130	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
131	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
132	VPLNR	☐	VPLNNR	PLNNR	CHAR	8	0	Group of the referenced task list
133	STDKN	☐	STDKN	KNTNR	NUMC	8	0	Node of operation within reference operation set
134	I_RUEST	☐	MCRUESTI	DAUER_6_1V	QUAN	7	1	Actual setup time
135	I_BEARZ	☐	MCBEARZI	DAUER_6_1V	QUAN	7	1	Actual processing time
136	I_ABRUE	☐	MCABRUEI	DAUER_6_1V	QUAN	7	1	Actual teardown
137	S_DLZ_EX	☐	S_DLZ_EX	DAUER_10_2V	QUAN	12	2	Target lead time (exact)
138	I_DLZ_EX	☐	I_DLZ_EX	DAUER_10_2V	QUAN	12	2	Actual lead time (exact)
139	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
140	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	*
141	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	*
142	GRUND	☐	CO_AGRND	CO_AGRND	CHAR	4	0	Reason for Variance	*
143	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
144	ARBII	☐	CR_OBJID_I	CR_OBJID	NUMC	8	0	Actual operating resources object identification	*
145	WERKSI	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
146	ARBPLI	☐	ARBPL	ARBPL	CHAR	8	0	Work center
147	VERANI	☐	AP_VERAN	AP_VERAN	CHAR	3	0	Person responsible for the work center	*
148	S_DLZ	☐	S_DLZ	DAUER_6_1V	QUAN	7	1	Target lead time
149	I_DLZ	☐	I_DLZ	DAUER_6_1V	QUAN	7	1	Actual lead time
150	Z_TAB	☐	X_TAB	DAUER_6_1V	QUAN	7	1	Deviation from scheduled input date
151	A_TAB	☐	A_TAB	DAUER_6_1V	QUAN	7	1	Deviation in scheduled output date
152	R_TAB	☐	R_TAB	DAUER_6_1V	QUAN	7	1	Relative schedule deviation
153	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
154	RMNGA	☐	RMNGA	MENGV13	QUAN	13	3	Total confirmed rework quantity
155	IPRZ1	☐	CO_IPRZS	MENGV13	QUAN	13	3	Confirmed quantity/work for business process
156	IPRE1	☐	RU_IPRZE	MEINS	UNIT	3	0	Unit of measurement for conf. quantity for business process	*
157	LAR01	☐	MCLSTAR01	LSTAR	CHAR	6	0	1. CO activity	*
158	LAR02	☐	MCLSTAR02	LSTAR	CHAR	6	0	2. CO activity	*
159	LAR03	☐	MCLSTAR03	LSTAR	CHAR	6	0	3. CO activity	*
160	LAR04	☐	MCLSTAR04	LSTAR	CHAR	6	0	4. CO activity	*
161	LAR05	☐	MCLSTAR05	LSTAR	CHAR	6	0	5. CO activity	*
162	LAR06	☐	MCLSTAR06	LSTAR	CHAR	6	0	6. CO activity	*
163	.INCLUDE	☐				0	0	Details: Order Event
164	A	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
165	.INCLUDE	☐				0	0	User Structure: Order Event
166	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
167	ZEITP	☐	DZEITP	ZEITP	CHAR	2	0	Event for which updating should take place	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCAFVGB	KALID	TFACD	IDENT
2	MCAFVGB	KAPAR	TC26	KAPAR
3	MCAFVGB	KAPID	KAKO	KAPID
4	MCAFVGB	KEINH	T006	MSEHI
5	MCAFVGB	MEINH	T006	MSEHI
6	MCAFVGB	OBJNR	ONR00	OBJNR
7	MCAFVGB	VERTL	T498	VERTL
8	MCAFVGB	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in