MCSFIS SAP (R/2 SFIS Data: Old) Table details
Dictionary Type: Table
Description: R/2 SFIS Data: Old
Description: R/2 SFIS Data: Old
Table field list including key, data, relationships and ABAP select examples
MCSFIS is a standard SAP Table which is used to store R/2 SFIS Data: Old data and is available within R/3 SAP systems depending on the version and release level.
The MCSFIS table consists of various fields, each holding specific information or linking keys about R/2 SFIS Data: Old data available in SAP. These include SSOUR (Statistic(s) origin), AUFNR (Order Number), AUFPL (Routing number of operations in the order), RSNUM (Number of Reservation/Dependent Requirement).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCSFIS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
WERKSM | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MATNRM | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
WERKSK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MATNRK | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ARBIDK | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
AUART | Order Type | AUFART | CHAR | 4 | Assigned to domain | AUFART | AAT | ||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | Assigned to domain | DISPO | DGR | ||
FEVOR | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
GASMG | Total scrap quantity in the order | GASMG | QUAN | 13(3) | MENG13 | ||||
GAMNG | Total order quantity | GAMNG | QUAN | 13(3) | MENG13 | ||||
GMEIN | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
KUNUM | Customer Number | KUNUM | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
MATNR | Material Number for Order | CO_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PWERK | Planning plant for the order | CO_PWERK | CHAR | 4 | Assigned to domain | WERKS | |||
ETRMP | Opening date of the planned order | CO_ETRMP | DATS | 8 | DATUM | ||||
STRMP | Start date of the planned order | CO_STRMP | DATS | 8 | DATUM | ||||
LTRMP | Delivery date from planned order | CO_LTRMP | DATS | 8 | DATUM | ||||
LTRMI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
PAMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13(3) | MENG13 | ||||
PGMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSAMG | Scrap quantity in item | CO_PSAMG | QUAN | 13(3) | MENG13 | ||||
PSMNG | Order item quantity | CO_PSMNG | QUAN | 13(3) | MENG13 | ||||
WEMNG | Quantity of goods received for the order item | CO_WEMNG | QUAN | 13(3) | MENG13 | ||||
IAMNG | Expected surplus/deficit for goods receipt | CO_IAMNG | QUAN | 13(3) | MENG13V | ||||
AMEIN | Unit of measure for in-house production | CO_AUFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
S_DFZ | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DFZ | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSUMS | Total target capacity requirements | MC_KSUMS | QUAN | 7(1) | DAUER_6_1V | ||||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
KDAUF | Sales order number | CO_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Sales order item | CO_KDPOS | NUMC | 6 | Assigned to domain | POSNR | AUP | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
ZEITP | Event for which updating should take place | DZEITP | CHAR | 2 | Assigned to domain | ZEITP | |||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | KAPID | |||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
STEUS | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
OBJNRV | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMRENV | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
UMREZV | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | ||||
VERTL | Distribution function for capacity requirements | VERTEILUNG | CHAR | 2 | Assigned to domain | VERTEILUNG | |||
KALID | Factory Calendar | WFCID | CHAR | 2 | Assigned to domain | WFCID | FCI | ||
MGVRG | Operation Quantity | MGVRG | QUAN | 13(3) | MENG13 | ||||
ASVRG | Operation scrap | ASVRG | QUAN | 13(3) | MENG13 | ||||
LMNGA | Total Yield Confirmed | LMNGA | QUAN | 13(3) | MENG13 | ||||
XMNGA | Total scrap quantity confirmed | XMNGA | QUAN | 13(3) | MENG13 | ||||
GMNGA | Confirmed yield in order unit of measure | GMNGA | QUAN | 13(3) | MENG13 | ||||
SSADD | Latest target input date | SSADD | DATS | 8 | DATUM | ||||
IADD | Actual input date | IADD | DATS | 8 | DATUM | ||||
FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ISAVD | Actual operation start (date) | ISAVD | DATS | 8 | DATUM | ||||
FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
N_IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
WARTZ | Queue time used for scheduling | MCWARTZ | QUAN | 9(3) | DAUER_6_3 | ||||
WRTZE | Unit of measure for queue time | WTRZE | UNIT | 3 | CUNIT | EINHEIT | |||
RUEST | Setup time | MCRUEST | QUAN | 9(3) | DAUER_6_3 | ||||
RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
BEARZ | Processing time | MCBEARZ | QUAN | 9(3) | DAUER_6_3 | ||||
BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
ABRUE | Teardown | MCABRUE | QUAN | 9(3) | DAUER_6_3 | ||||
ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
LIEGZ | Wait time used for scheduling | MCLIEGEZ | QUAN | 9(3) | DAUER_6_3 | ||||
V_LIEGZ | Wait time used for scheduling | MCLIEGEZ | QUAN | 9(3) | DAUER_6_3 | ||||
LIGZE | Unit of measure for wait time | LIGZE | UNIT | 3 | CUNIT | EINHEIT | |||
TRANZ | Move time used for scheduling | MCTRANZ | QUAN | 9(3) | DAUER_6_3 | ||||
KRUES | Scheduled cap. requirements for the op. segment 'setup' | MCKRUES | QUAN | 9(3) | DAUER_6_3 | ||||
KBEAS | Scheduled cap. requirements for the op. segment 'processing' | MCKBEAS | QUAN | 9(3) | DAUER_6_3 | ||||
KABRS | Scheduled cap. requirements for the op. segment teardown | MCKABRS | QUAN | 9(3) | DAUER_6_3 | ||||
KEINHV | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TRAZE | Unit of measure for move time | TRAZE | UNIT | 3 | CUNIT | EINHEIT | |||
DFZEHV | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
S_DFZV | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DFZV | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
KAPKZ | SFIS indicator for cumulative updating of capacity data | KAPKZ | CHAR | 1 | X | ||||
A | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
VDATU | Date of update for statistics updating | MC_VDATUM | DATS | 8 | DATUM | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
ZEITPV | Event for which updating should take place | DZEITP | CHAR | 2 | Assigned to domain | ZEITP | |||
LGORTM | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
CHARGM | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
BDMNG | Requirement Quantity | MC_BDMNG | QUAN | 15(3) | MENGV15 | ||||
ENMNG | Quantity withdrawn | MC_ENMNG | QUAN | 15(3) | MENGV15 | ||||
ENWRT | Issued Value | MC_ENWRT | CURR | 19(2) | WERTV10 | ||||
MEINSM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
GSBERM | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
TYPPS | Item Category | TYPPS | CHAR | 1 | TYPPS | ||||
PSKNZ | Fixed/Variable Indicator | FVFLG | CHAR | 1 | FVFLG | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
PREIS | Total Price in Local Currency | PPGXXX | CURR | 15(2) | WERTV8 | ||||
WERTN | Value (total) in controlling area currency | MC_WERTN | CURR | 19(2) | WERTV10 | ||||
WRTFX | Fixed Value in Controlling Area Currency | MC_WRTFX | CURR | 19(2) | WERTV10 | ||||
WRTVR | Variable Value in Controlling Area Currency | MC_WRTVR | CURR | 19(2) | WERTV10 | ||||
WAERSK | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
PPREIS | Planned price (total) in local currency | MC_PGPREIS | CURR | 15(2) | WERTV8 | ||||
PWERTN | Planned value (total) in controlling area currency | MC_PWERTN | CURR | 19(2) | WERTV10 | ||||
PWRTFX | Planned value (fixed) in controlling area currency | MC_PWRTFX | CURR | 19(2) | WERTV10 | ||||
PWRTVR | Planned value (variable) in controlling area currency | MC_PWRTVR | CURR | 19(2) | WERTV10 |
Key field | Non-key field |
How do I retrieve data from SAP table MCSFIS using ABAP code
The following ABAP code Example will allow you to do a basic selection on MCSFIS to SELECT all data from the tableDATA: WA_MCSFIS TYPE MCSFIS.
SELECT SINGLE *
FROM MCSFIS
INTO CORRESPONDING FIELDS OF WA_MCSFIS
WHERE...
How to access SAP table MCSFIS
Within an ECC or HANA version of SAP you can also view further information about MCSFIS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects