SAP ABAP Table MCSFIS (R/2 SFIS Data: Old)
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 | TRANSP | Transparent table |
Transparent table | MCSFIS | Table Relationship Diagram |
Short Description | R/2 SFIS Data: Old |
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 | .INCLUDE | 0 | 0 | R/2 Structure PPIS - Header | |||||
3 | SSOUR | SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
4 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
5 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
6 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
7 | WERKSM | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
8 | MATNRM | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
9 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
10 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
11 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
12 | WERKSK | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
13 | MATNRK | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
14 | ARBIDK | CR_OBJID | CR_OBJID | NUMC | 8 | 0 | Object ID of the resource | * | |
15 | .INCLUDE | 0 | 0 | R/2 Sender Structure: PPC Order Header | |||||
16 | AUART | AUFART | AUFART | CHAR | 4 | 0 | Order Type | * | |
17 | AUTYP | AUFTYP | AUFTYP | NUMC | 2 | 0 | Order category | ||
18 | ERDAT | AUFERFDAT | DATUM | DATS | 8 | 0 | Created on | ||
19 | AEDAT | AUFAEDAT | DATUM | DATS | 8 | 0 | Change date for Order Master | ||
20 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
21 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
22 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
23 | PLGRP | VAGRP | VAGRP | CHAR | 3 | 0 | Responsible planner group/department | * | |
24 | DISPO | CO_DISPO | DISPO | CHAR | 3 | 0 | MRP controller for the order | * | |
25 | FEVOR | VAGRP | VAGRP | CHAR | 3 | 0 | Responsible planner group/department | * | |
26 | GLTRP | CO_GLTRP | DATUM | DATS | 8 | 0 | Basic finish date | ||
27 | GSTRP | CO_GSTRP | DATUM | DATS | 8 | 0 | Basic start date | ||
28 | FTRMS | CO_FTRMS | DATUM | DATS | 8 | 0 | Scheduled release date | ||
29 | GLTRS | CO_GLTRS | DATUM | DATS | 8 | 0 | Scheduled finish | ||
30 | GSTRS | CO_GSTRS | DATUM | DATS | 8 | 0 | Scheduled start | ||
31 | GSTRI | CO_GSTRI | DATUM | DATS | 8 | 0 | Actual start date | ||
32 | GETRI | CO_GETRI | DATUM | DATS | 8 | 0 | Confirmed Order Finish Date | ||
33 | GLTRI | CO_GLTRI | DATUM | DATS | 8 | 0 | Actual finish date | ||
34 | FTRMI | CO_FTRMI | DATUM | DATS | 8 | 0 | Actual release date | ||
35 | FTRMP | CO_FTRMP | DATUM | DATS | 8 | 0 | Planned release date | ||
36 | GASMG | GASMG | MENG13 | QUAN | 13 | 3 | Total scrap quantity in the order | ||
37 | GAMNG | GAMNG | MENG13 | QUAN | 13 | 3 | Total order quantity | ||
38 | GMEIN | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
39 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | * | |
40 | KUNUM | KUNUM | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
41 | .INCLUDE | 0 | 0 | R/2 Sender Structure: PPC Order Item | |||||
42 | POSNR | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
43 | MATNR | CO_MATNR | MATNR | CHAR | 18 | 0 | Material Number for Order | * | |
44 | PWERK | CO_PWERK | WERKS | CHAR | 4 | 0 | Planning plant for the order | * | |
45 | ETRMP | CO_ETRMP | DATUM | DATS | 8 | 0 | Opening date of the planned order | ||
46 | STRMP | CO_STRMP | DATUM | DATS | 8 | 0 | Start date of the planned order | ||
47 | LTRMP | CO_LTRMP | DATUM | DATS | 8 | 0 | Delivery date from planned order | ||
48 | LTRMI | CO_LTRMI | DATUM | DATS | 8 | 0 | Actual delivery/finish date | ||
49 | PAMNG | AVMNG | MENG13 | QUAN | 13 | 3 | Fixed quantity of scrap from production | ||
50 | PGMNG | GSMNG | MENG13 | QUAN | 13 | 3 | Total planned order quantity | ||
51 | MEINS | LAGME | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
52 | PSAMG | CO_PSAMG | MENG13 | QUAN | 13 | 3 | Scrap quantity in item | ||
53 | PSMNG | CO_PSMNG | MENG13 | QUAN | 13 | 3 | Order item quantity | ||
54 | WEMNG | CO_WEMNG | MENG13 | QUAN | 13 | 3 | Quantity of goods received for the order item | ||
55 | IAMNG | CO_IAMNG | MENG13V | QUAN | 13 | 3 | Expected surplus/deficit for goods receipt | ||
56 | AMEIN | CO_AUFME | MEINS | UNIT | 3 | 0 | Unit of measure for in-house production | * | |
57 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
58 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
59 | DFZEH | DFZEH | EINHEIT | UNIT | 3 | 0 | Unit of measure for execution time | ||
60 | S_DFZ | S_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Target execution time | ||
61 | I_DFZ | I_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Actual execution time | ||
62 | KEINH | CY_KEINH | MEINS | UNIT | 3 | 0 | Unit of of measure for displaying capacity requirements | * | |
63 | KSUMS | MC_KSUMS | DAUER_6_1V | QUAN | 7 | 1 | Total target capacity requirements | ||
64 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | * | |
65 | KDAUF | CO_KDAUF | VBELN | CHAR | 10 | 0 | Sales order number | * | |
66 | KDPOS | CO_KDPOS | POSNR | NUMC | 6 | 0 | Sales order item | * | |
67 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
68 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
69 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
70 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
71 | ZEITP | DZEITP | ZEITP | CHAR | 2 | 0 | Event for which updating should take place | * | |
72 | .INCLUDE | 0 | 0 | R/2 Sender Structure: Order Operation | |||||
73 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
74 | ZAEHL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
75 | PLNFL | PLNFOLGE | PLNFOLGE | CHAR | 6 | 0 | Sequence | ||
76 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
77 | ARBID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
78 | KAPAR | KAPART | KAPART | CHAR | 3 | 0 | Capacity category | * | |
79 | KAPID | KAPID | KAPID | NUMC | 8 | 0 | Capacity ID | * | |
80 | ARBPL | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
81 | STEUS | STEUS | STEUS | CHAR | 4 | 0 | Control key | * | |
82 | OBJNRV | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
83 | MEINH | VORME | MEINS | UNIT | 3 | 0 | Unit of measure for activity | * | |
84 | UMRENV | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
85 | UMREZV | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
86 | BMSCH | BMSCH | BMSCH | QUAN | 13 | 3 | Base Quantity | ||
87 | VERTL | VERTEILUNG | VERTEILUNG | CHAR | 2 | 0 | Distribution function for capacity requirements | * | |
88 | KALID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
89 | MGVRG | MGVRG | MENG13 | QUAN | 13 | 3 | Operation Quantity | ||
90 | ASVRG | ASVRG | MENG13 | QUAN | 13 | 3 | Operation scrap | ||
91 | LMNGA | LMNGA | MENG13 | QUAN | 13 | 3 | Total Yield Confirmed | ||
92 | XMNGA | XMNGA | MENG13 | QUAN | 13 | 3 | Total scrap quantity confirmed | ||
93 | GMNGA | GMNGA | MENG13 | QUAN | 13 | 3 | Confirmed yield in order unit of measure | ||
94 | SSADD | SSADD | DATUM | DATS | 8 | 0 | Latest target input date | ||
95 | IADD | IADD | DATUM | DATS | 8 | 0 | Actual input date | ||
96 | FSAVD | FSAVD | DATUM | DATS | 8 | 0 | Earliest scheduled start: Execution (date) | ||
97 | SSAVD | SSAVD | DATUM | DATS | 8 | 0 | Latest scheduled start: Execution (date) | ||
98 | ISDD | ISDD | DATUM | DATS | 8 | 0 | Actual start: Execution (date) | ||
99 | ISAVD | ISAVD | DATUM | DATS | 8 | 0 | Actual operation start (date) | ||
100 | FSEDD | FSEDD | DATUM | DATS | 8 | 0 | Earliest scheduled finish: Execution (date) | ||
101 | SSEDD | SSEDD | DATUM | DATS | 8 | 0 | Latest scheduled finish: Execution (date) | ||
102 | IEDD | IEDD | DATUM | DATS | 8 | 0 | Actual finish: Execution (date) | ||
103 | IEAVD | IEAVD | DATUM | DATS | 8 | 0 | Actual finish of operation (date) | ||
104 | N_IEAVD | IEAVD | DATUM | DATS | 8 | 0 | Actual finish of operation (date) | ||
105 | WARTZ | MCWARTZ | DAUER_6_3 | QUAN | 9 | 3 | Queue time used for scheduling | ||
106 | WRTZE | WTRZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for queue time | ||
107 | RUEST | MCRUEST | DAUER_6_3 | QUAN | 9 | 3 | Setup time | ||
108 | RSTZE | RSTZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for setup time | ||
109 | BEARZ | MCBEARZ | DAUER_6_3 | QUAN | 9 | 3 | Processing time | ||
110 | BEAZE | BEAZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for processing time | ||
111 | ABRUE | MCABRUE | DAUER_6_3 | QUAN | 9 | 3 | Teardown | ||
112 | ARUZE | ARUZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for teardown | ||
113 | LIEGZ | MCLIEGEZ | DAUER_6_3 | QUAN | 9 | 3 | Wait time used for scheduling | ||
114 | V_LIEGZ | MCLIEGEZ | DAUER_6_3 | QUAN | 9 | 3 | Wait time used for scheduling | ||
115 | LIGZE | LIGZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for wait time | ||
116 | TRANZ | MCTRANZ | DAUER_6_3 | QUAN | 9 | 3 | Move time used for scheduling | ||
117 | KRUES | MCKRUES | DAUER_6_3 | QUAN | 9 | 3 | Scheduled cap. requirements for the op. segment "setup" | ||
118 | KBEAS | MCKBEAS | DAUER_6_3 | QUAN | 9 | 3 | Scheduled cap. requirements for the op. segment "processing" | ||
119 | KABRS | MCKABRS | DAUER_6_3 | QUAN | 9 | 3 | Scheduled cap. requirements for the op. segment teardown | ||
120 | KEINHV | CY_KEINH | MEINS | UNIT | 3 | 0 | Unit of of measure for displaying capacity requirements | * | |
121 | TRAZE | TRAZE | EINHEIT | UNIT | 3 | 0 | Unit of measure for move time | ||
122 | DFZEHV | DFZEH | EINHEIT | UNIT | 3 | 0 | Unit of measure for execution time | ||
123 | S_DFZV | S_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Target execution time | ||
124 | I_DFZV | I_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Actual execution time | ||
125 | KAPKZ | KAPKZ | X | CHAR | 1 | 0 | SFIS indicator for cumulative updating of capacity data | ||
126 | A | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
127 | VDATU | MC_VDATUM | DATUM | DATS | 8 | 0 | Date of update for statistics updating | ||
128 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
129 | ZEITPV | DZEITP | ZEITP | CHAR | 2 | 0 | Event for which updating should take place | * | |
130 | .INCLUDE | 0 | 0 | R/2 Sender Structure: Component | |||||
131 | LGORTM | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
132 | CHARGM | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
133 | BDMNG | MC_BDMNG | MENGV15 | QUAN | 15 | 3 | Requirement Quantity | ||
134 | ENMNG | MC_ENMNG | MENGV15 | QUAN | 15 | 3 | Quantity withdrawn | ||
135 | ENWRT | MC_ENWRT | WERTV10 | CURR | 19 | 2 | Issued Value | ||
136 | MEINSM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
137 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
138 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
139 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
140 | BWART | BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | * | |
141 | GSBERM | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
142 | .INCLUDE | 0 | 0 | R/2 Sender Structure: Costs | |||||
143 | TYPPS | TYPPS | TYPPS | CHAR | 1 | 0 | Item Category | ||
144 | PSKNZ | FVFLG | FVFLG | CHAR | 1 | 0 | Fixed/Variable Indicator | ||
145 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
146 | PREIS | PPGXXX | WERTV8 | CURR | 15 | 2 | Total Price in Local Currency | ||
147 | WERTN | MC_WERTN | WERTV10 | CURR | 19 | 2 | Value (total) in controlling area currency | ||
148 | WRTFX | MC_WRTFX | WERTV10 | CURR | 19 | 2 | Fixed Value in Controlling Area Currency | ||
149 | WRTVR | MC_WRTVR | WERTV10 | CURR | 19 | 2 | Variable Value in Controlling Area Currency | ||
150 | WAERSK | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
151 | PPREIS | MC_PGPREIS | WERTV8 | CURR | 15 | 2 | Planned price (total) in local currency | ||
152 | PWERTN | MC_PWERTN | WERTV10 | CURR | 19 | 2 | Planned value (total) in controlling area currency | ||
153 | PWRTFX | MC_PWRTFX | WERTV10 | CURR | 19 | 2 | Planned value (fixed) in controlling area currency | ||
154 | PWRTVR | MC_PWRTVR | WERTV10 | CURR | 19 | 2 | Planned value (variable) in controlling area currency |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCSFIS | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |