MCSFIS - R/2 SFIS Data: Old

R/2 SFIS Data: Old information is stored in SAP table MCSFIS.
It is part of development package MCF in software component PP-IS. This development package consists of objects that can be grouped under "R/3 application development: Shop Floor Information System".

Fields for table MCSFIS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE		X		MCSFISK	0
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
AUFNR	Order Number	X	AUFNR	CHAR	24	*
AUFPL	Routing number of operations in the order	X	CO_AUFPL	NUMC	20
RSNUM	Number of reservation/dependent requirements	X	RSNUM	NUMC	20	*
WERKSM	Plant	X	WERKS_D	CHAR	8
MATNRM	Material Number	X	MATNR	CHAR	80
KSTAR	Cost Element	X	KSTAR	CHAR	20	*
KOSTL	Cost Center	X	KOSTL	CHAR	20	*
LSTAR	Activity Type	X	LSTAR	CHAR	12
WERKSK	Plant	X	WERKS_D	CHAR	8
MATNRK	Material Number	X	MATNR	CHAR	80
ARBIDK	Object ID of the resource	X	CR_OBJID	NUMC	16	*
.INCLUDE				MCAFKOS	0
AUART	Order Type		AUFART	CHAR	8	*
AUTYP	Order category		AUFTYP	NUMC	4
ERDAT	Created On		AUFERFDAT	DATS	16
AEDAT	Change Date for Order Master		AUFAEDAT	DATS	16
OBJNR	Object number		J_OBJNR	CHAR	44	*
BUKRS	Company Code		BUKRS	CHAR	8
WERKS	Plant		WERKS_D	CHAR	8
PLGRP	Responsible Planner Group or Department		VAGRP	CHAR	6
DISPO	MRP controller for the order		CO_DISPO	CHAR	6	*
FEVOR	Responsible Planner Group or Department		VAGRP	CHAR	6
GLTRP	Basic finish date		CO_GLTRP	DATS	16
GSTRP	Basic start date		CO_GSTRP	DATS	16
FTRMS	Scheduled release date		CO_FTRMS	DATS	16
GLTRS	Scheduled finish		CO_GLTRS	DATS	16
GSTRS	Scheduled start		CO_GSTRS	DATS	16
GSTRI	Actual start date		CO_GSTRI	DATS	16
GETRI	Confirmed Order Finish Date		CO_GETRI	DATS	16
GLTRI	Actual finish date		CO_GLTRI	DATS	16
FTRMI	Actual release date		CO_FTRMI	DATS	16
FTRMP	Planned Release Date		CO_FTRMP	DATS	16
GASMG	Total Scrap Quantity in the Order		GASMG	QUAN	7
GAMNG	Total Order Quantity		GAMNG	QUAN	7
GMEIN	Base Unit of Measure		MEINS	UNIT	6	*
VERID	Production Version		VERID	CHAR	8	*
KUNUM	Customer Number		KUNUM	CHAR	20	*
.INCLUDE				MCAFPOS	0
POSNR	Order item number		CO_POSNR	NUMC	8
MATNR	Material Number for Order		CO_MATNR	CHAR	80	*
PWERK	Planning Plant for an Order		CO_PWERK	CHAR	8	*
ETRMP	Opening Date of the Planned Order		CO_ETRMP	DATS	16
STRMP	Planned Order Planned Start Date		CO_STRMP	DATS	16
LTRMP	Delivery Date From Planned Order		CO_LTRMP	DATS	16
LTRMI	Actual Delivery/Finish Date		CO_LTRMI	DATS	16
PAMNG	Planned Scrap Quantity		AVMNG	QUAN	7
PGMNG	Planned Total Order Quantity		GSMNG	QUAN	7
MEINS	Base Unit of Measure		LAGME	UNIT	6	*
PSAMG	Order Item Planned Scrap Quantity		CO_PSAMG	QUAN	7
PSMNG	Order Item Planned Total Quantity		CO_PSMNG	QUAN	7
WEMNG	Quantity of Goods Received for the Order Item		CO_WEMNG	QUAN	7
IAMNG	Expected Surplus/Deficit For Goods Receipt		CO_IAMNG	QUAN	7
AMEIN	Unit of measure for in-house production		CO_AUFME	UNIT	6	*
UMREZ	Numerator for Conversion to Base Units of Measure		UMREZ	DEC	3
UMREN	Denominator for conversion to base units of measure		UMREN	DEC	3
DFZEH	Unit of measure for execution time		DFZEH	UNIT	6
S_DFZ	Target execution time		S_DFZ	QUAN	4
I_DFZ	Actual execution time		I_DFZ	QUAN	4
KEINH	Unit of Measure for Capacity Requirements		CY_KEINH	UNIT	6	*
KSUMS	Total target capacity requirements		MC_KSUMS	QUAN	4
PLNUM	Planned Order		PLNUM	CHAR	20
KDAUF	Sales Order		CO_KDAUF	CHAR	20
KDPOS	Sales Order Item		CO_KDPOS	NUMC	12
LGORT	Storage location		LGORT_D	CHAR	8	*
SERNR	BOM explosion number		SERNR	CHAR	16	*
CHARG	Batch Number		CHARG_D	CHAR	20	*
GSBER	Business Area		GSBER	CHAR	8	*
.INCLUDE				MCAFVGS	0
APLZL	Internal counter		CIM_COUNT	NUMC	16
PLNFL	Sequence		PLNFOLGE	CHAR	12
VORNR	Operation/Activity Number		VORNR	CHAR	8
ARBID	Object ID		OBJEKTID	NUMC	16
KAPAR	Capacity category		KAPART	CHAR	6	*
KAPID	Capacity ID		KAPID	NUMC	16	*
ARBPL	Work Center		ARBPL	CHAR	16
STEUS	Control key		STEUS	CHAR	8	*
OBJNRV	Object number		J_OBJNR	CHAR	44	*
MEINH	Unit of measure for activity		VORME	UNIT	6	*
UMRENV	Denominator for conversion to base units of measure		UMREN	DEC	3
UMREZV	Numerator for Conversion to Base Units of Measure		UMREZ	DEC	3
BMSCH	Base Quantity		BMSCH	QUAN	7
VERTL	Distribution function for capacity requirements		VERTEILUNG	CHAR	4	*
KALID	Factory Calendar		WFCID	CHAR	4	*
MGVRG	Operation Total Quantity		MGVRG	QUAN	7
ASVRG	Operation Planned Scrap Quantity		ASVRG	QUAN	7
LMNGA	Total Confirmed Yield		LMNGA	QUAN	7
XMNGA	Total Scrap Quantity Confirmed		XMNGA	QUAN	7
GMNGA	Confirmed yield in order unit of measure		GMNGA	QUAN	7
SSADD	Latest target input date		SSADD	DATS	16
IADD	Actual input date		IADD	DATS	16
FSAVD	Earliest scheduled start: Execution (date)		FSAVD	DATS	16
SSAVD	Latest scheduled start: Execution (date)		SSAVD	DATS	16
ISDD	Actual Execution Start Date		ISDD	DATS	16
ISAVD	Actual Operation Start Date		ISAVD	DATS	16
FSEDD	Earliest scheduled finish: Execution (date)		FSEDD	DATS	16
SSEDD	Latest scheduled finish: Execution (date)		SSEDD	DATS	16
IEDD	Actual Execution End Date		IEDD	DATS	16
IEAVD	Actual Operation End Date		IEAVD	DATS	16
N_IEAVD	Actual Operation End Date		IEAVD	DATS	16
WARTZ	Queue time used for scheduling		MCWARTZ	QUAN	5
WRTZE	Unit of Measure for Queue Time		WTRZE	UNIT	6
RUEST	Setup time		MCRUEST	QUAN	5
RSTZE	Unit of Measure for Setup Time		RSTZE	UNIT	6
BEARZ	Processing time		MCBEARZ	QUAN	5
BEAZE	Unit of measure for processing time		BEAZE	UNIT	6
ABRUE	Teardown		MCABRUE	QUAN	5
ARUZE	Unit of Measure for Teardown		ARUZE	UNIT	6
LIEGZ	Wait Time Used for Scheduling		MCLIEGEZ	QUAN	5
V_LIEGZ	Wait Time Used for Scheduling		MCLIEGEZ	QUAN	5
LIGZE	Unit of Measure for Wait Time		LIGZE	UNIT	6
TRANZ	Move time used for scheduling		MCTRANZ	QUAN	5
KRUES	Scheduled cap. requirements for the op. segment "setup"		MCKRUES	QUAN	5
KBEAS	Scheduled cap. requirements for the op. segment "processing"		MCKBEAS	QUAN	5
KABRS	Scheduled cap. requirements for the op. segment teardown		MCKABRS	QUAN	5
KEINHV	Unit of Measure for Capacity Requirements		CY_KEINH	UNIT	6	*
TRAZE	Unit of Measure for Move Time		TRAZE	UNIT	6
DFZEHV	Unit of measure for execution time		DFZEH	UNIT	6
S_DFZV	Target execution time		S_DFZ	QUAN	4
I_DFZV	Actual execution time		I_DFZ	QUAN	4
KAPKZ	SFIS indicator for cumulative updating of capacity data		KAPKZ	CHAR	2
A	Dummy function in length 1		DUMMY	CHAR	2
VDATU	Date of update for statistics updating		MC_VDATUM	DATS	16
DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				MCCOMPS	0
LGORTM	Storage location		LGORT_D	CHAR	8	*
CHARGM	Batch Number		CHARG_D	CHAR	20	*
BDMNG	Requirement Quantity		MC_BDMNG	QUAN	8
ENMNG	Quantity withdrawn		MC_ENMNG	QUAN	8
ENWRT	Issued Value		MC_ENWRT	CURR	10
MEINSM	Base Unit of Measure		MEINS	UNIT	6	*
WAERS	Currency Key		WAERS	CUKY	10	*
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	*
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
BWART	Movement type (inventory management)		BWART	CHAR	6	*
GSBERM	Business Area		GSBER	CHAR	8	*
.INCLUDE				MCKALKS	0
TYPPS	Item Category		TYPPS	CHAR	2
PSKNZ	Fixed/Variable Indicator		FVFLG	CHAR	2
BWTAR	Valuation Type		BWTAR_D	CHAR	20	*
PREIS	Total Price in Local Currency		PPGXXX	CURR	8
WERTN	Value (total) in controlling area currency		MC_WERTN	CURR	10
WRTFX	Fixed Value in Controlling Area Currency		MC_WRTFX	CURR	10
WRTVR	Variable Value in Controlling Area Currency		MC_WRTVR	CURR	10
WAERSK	Currency Key		WAERS	CUKY	10	*
PPREIS	Planned price (total) in local currency		MC_PGPREIS	CURR	8
PWERTN	Planned value (total) in controlling area currency		MC_PWERTN	CURR	10
PWRTFX	Planned value (fixed) in controlling area currency		MC_PWRTFX	CURR	10
PWRTVR	Planned value (variable) in controlling area currency		MC_PWRTVR	CURR	10