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