SAP TABLES | Production Planning and Control | Information System(PP-IS) SAP PP

MCSFIS SAP R/2 SFIS Data: Old Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP MCSFIS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP MCSFIS Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
.INCLUDEMCSFISK R/2 Structure PPIS - Header
SSOURSSOURCHAR4 Statistic(s) origin
AUFNRAUFNRCHAR12
*
Order NumberALPHA
AUFPLCO_AUFPLNUMC10 Routing number of operations in the order
RSNUMRSNUMNUMC10
*
Number of Reservation/Dependent Requirement
WERKSMWERKS_DCHAR4
*
Plant
MATNRMMATNRCHAR18
*
Material NumberMATN1
KSTARKSTARCHAR10
*
Cost ElementALPHA
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
LSTARLSTARCHAR6
*
Activity Type
WERKSKWERKS_DCHAR4
*
Plant
MATNRKMATNRCHAR18
*
Material NumberMATN1
ARBIDKCR_OBJIDNUMC8
*
Object ID of the resource
.INCLUDEMCAFKOS R/2 Sender Structure: PPC Order Header
AUARTAUFARTCHAR4
*
Order Type
AUTYPAUFTYPNUMC2 Order category
ERDATAUFERFDATDATS8 Created on
AEDATAUFAEDATDATS8 Change date for Order Master
OBJNRJ_OBJNRCHAR22
*
Object number
BUKRSBUKRSCHAR4
*
Company Code
WERKSWERKS_DCHAR4
*
Plant
PLGRPVAGRPCHAR3
*
Responsible planner group/department
DISPOCO_DISPOCHAR3
*
MRP controller for the order
FEVORVAGRPCHAR3
*
Responsible planner group/department
GLTRPCO_GLTRPDATS8 Basic finish date
GSTRPCO_GSTRPDATS8 Basic start date
FTRMSCO_FTRMSDATS8 Scheduled release date
GLTRSCO_GLTRSDATS8 Scheduled finish
GSTRSCO_GSTRSDATS8 Scheduled start
GSTRICO_GSTRIDATS8 Actual start date
GETRICO_GETRIDATS8 Confirmed Order Finish Date
GLTRICO_GLTRIDATS8 Actual finish date
FTRMICO_FTRMIDATS8 Actual release date
FTRMPCO_FTRMPDATS8 Planned release date
GASMGGASMGQUAN13(3) Total scrap quantity in the order
GAMNGGAMNGQUAN13(3) Total order quantity
GMEINMEINSUNIT3
*
Base Unit of MeasureCUNIT
VERIDVERIDCHAR4
*
Production Version


KUNUMKUNUMCHAR10
*
Customer NumberALPHA
.INCLUDEMCAFPOS R/2 Sender Structure: PPC Order Item
POSNRCO_POSNRNUMC4 Order Item Number
MATNRCO_MATNRCHAR18
*
Material Number for OrderMATN1
PWERKCO_PWERKCHAR4
*
Planning plant for the order
ETRMPCO_ETRMPDATS8 Opening date of the planned order
STRMPCO_STRMPDATS8 Start date of the planned order
LTRMPCO_LTRMPDATS8 Delivery date from planned order
LTRMICO_LTRMIDATS8 Actual delivery/finish date
PAMNGAVMNGQUAN13(3) Fixed quantity of scrap from production
PGMNGGSMNGQUAN13(3) Total planned order quantity
MEINSLAGMEUNIT3
*
Base Unit of MeasureCUNIT
PSAMGCO_PSAMGQUAN13(3) Scrap quantity in item
PSMNGCO_PSMNGQUAN13(3) Order item quantity
WEMNGCO_WEMNGQUAN13(3) Quantity of goods received for the order item
IAMNGCO_IAMNGQUAN13(3) Expected surplus/deficit for goods receipt
AMEINCO_AUFMEUNIT3
*
Unit of measure for in-house productionCUNIT
UMREZUMREZDEC5 Numerator for Conversion to Base Units of Measure
UMRENUMRENDEC5 Denominator for conversion to base units of measure
DFZEHDFZEHUNIT3 Unit of measure for execution timeCUNIT
S_DFZS_DFZQUAN7(1) Target execution time
I_DFZI_DFZQUAN7(1) Actual execution time
KEINHCY_KEINHUNIT3
*
Unit of of measure for displaying capacity requirementsCUNIT
KSUMSMC_KSUMSQUAN7(1) Total target capacity requirements
PLNUMPLNUMCHAR10
*
Planned order numberALPHA
KDAUFCO_KDAUFCHAR10
*
Sales order numberALPHA
KDPOSCO_KDPOSNUMC6
*
Sales order item
LGORTLGORT_DCHAR4
*
Storage Location
SERNRSERNRCHAR8
*
BOM explosion number
CHARGCHARG_DCHAR10
*
Batch Number
GSBERGSBERCHAR4
*
Business Area
ZEITPDZEITPCHAR2
*
Event for which updating should take place
.INCLUDEMCAFVGS R/2 Sender Structure: Order Operation
APLZLCIM_COUNTNUMC8 Internal counter
ZAEHLCIM_COUNTNUMC8 Internal counter
PLNFLPLNFOLGECHAR6 SequenceALPHA
VORNRVORNRCHAR4 Operation/Activity NumberNUMCV
ARBIDOBJEKTIDNUMC8 Object ID
KAPARKAPARTCHAR3
*
Capacity category


KAPIDKAPIDNUMC8
*
Capacity ID
ARBPLARBPLCHAR8 Work center
STEUSSTEUSCHAR4
*
Control key
OBJNRVJ_OBJNRCHAR22
*
Object number
MEINHVORMEUNIT3
*
Unit of Measure for Activity/OperationCUNIT
UMRENVUMRENDEC5 Denominator for conversion to base units of measure
UMREZVUMREZDEC5 Numerator for Conversion to Base Units of Measure
BMSCHBMSCHQUAN13(3) Base Quantity
VERTLVERTEILUNGCHAR2
*
Distribution function for capacity requirements
KALIDWFCIDCHAR2
*
Factory Calendar
MGVRGMGVRGQUAN13(3) Operation Quantity
ASVRGASVRGQUAN13(3) Operation scrap
LMNGALMNGAQUAN13(3) Total Yield Confirmed
XMNGAXMNGAQUAN13(3) Total scrap quantity confirmed
GMNGAGMNGAQUAN13(3) Confirmed yield in order unit of measure
SSADDSSADDDATS8 Latest target input date
IADDIADDDATS8 Actual input date
FSAVDFSAVDDATS8 Earliest scheduled start: Execution (date)
SSAVDSSAVDDATS8 Latest scheduled start: Execution (date)
ISDDISDDDATS8 Actual start: Execution (date)
ISAVDISAVDDATS8 Actual operation start (date)
FSEDDFSEDDDATS8 Earliest scheduled finish: Execution (date)
SSEDDSSEDDDATS8 Latest scheduled finish: Execution (date)
IEDDIEDDDATS8 Actual finish: Execution (date)
IEAVDIEAVDDATS8 Actual finish of operation (date)
N_IEAVDIEAVDDATS8 Actual finish of operation (date)
WARTZMCWARTZQUAN9(3) Queue time used for scheduling
WRTZEWTRZEUNIT3 Unit of measure for queue timeCUNIT
RUESTMCRUESTQUAN9(3) Setup time
RSTZERSTZEUNIT3 Unit of measure for setup timeCUNIT
BEARZMCBEARZQUAN9(3) Processing time
BEAZEBEAZEUNIT3 Unit of measure for processing timeCUNIT
ABRUEMCABRUEQUAN9(3) Teardown
ARUZEARUZEUNIT3 Unit of measure for teardownCUNIT
LIEGZMCLIEGEZQUAN9(3) Wait time used for scheduling
V_LIEGZMCLIEGEZQUAN9(3) Wait time used for scheduling
LIGZELIGZEUNIT3 Unit of measure for wait timeCUNIT
TRANZMCTRANZQUAN9(3) Move time used for scheduling
KRUESMCKRUESQUAN9(3) Scheduled cap. requirements for the op. segment "setup"

KBEASMCKBEASQUAN9(3) Scheduled cap. requirements for the op. segment "processing"
KABRSMCKABRSQUAN9(3) Scheduled cap. requirements for the op. segment teardown
KEINHVCY_KEINHUNIT3
*
Unit of of measure for displaying capacity requirementsCUNIT
TRAZETRAZEUNIT3 Unit of measure for move timeCUNIT
DFZEHVDFZEHUNIT3 Unit of measure for execution timeCUNIT
S_DFZVS_DFZQUAN7(1) Target execution time
I_DFZVI_DFZQUAN7(1) Actual execution time
KAPKZKAPKZCHAR1 SFIS indicator for cumulative updating of capacity data
ADUMMYCHAR1 Dummy function in length 1
VDATUMC_VDATUMDATS8 Date of update for statistics updating
DUMMYDUMMYCHAR1 Dummy function in length 1
ZEITPVDZEITPCHAR2
*
Event for which updating should take place
.INCLUDEMCCOMPS R/2 Sender Structure: Component
LGORTMLGORT_DCHAR4
*
Storage Location
CHARGMCHARG_DCHAR10
*
Batch Number
BDMNGMC_BDMNGQUAN15(3) Requirement Quantity
ENMNGMC_ENMNGQUAN15(3) Quantity withdrawn
ENWRTMC_ENWRTCURR19(2) Issued Value
MEINSMMEINSUNIT3
*
Base Unit of MeasureCUNIT
WAERSWAERSCUKY5
*
Currency Key
SOBKZSOBKZCHAR1
*
Special Stock Indicator
SHKZGSHKZGCHAR1 Debit/Credit Indicator
BWARTBWARTCHAR3
*
Movement Type (Inventory Management)
GSBERMGSBERCHAR4
*
Business Area
.INCLUDEMCKALKS R/2 Sender Structure: Costs
TYPPSTYPPSCHAR1 Item Category
PSKNZFVFLGCHAR1 Fixed/Variable Indicator
BWTARBWTAR_DCHAR10
*
Valuation Type
PREISPPGXXXCURR15(2) Total Price in Local Currency
WERTNMC_WERTNCURR19(2) Value (total) in controlling area currency
WRTFXMC_WRTFXCURR19(2) Fixed Value in Controlling Area Currency
WRTVRMC_WRTVRCURR19(2) Variable Value in Controlling Area Currency
WAERSKWAERSCUKY5
*
Currency Key
PPREISMC_PGPREISCURR15(2) Planned price (total) in local currency
PWERTNMC_PWERTNCURR19(2) Planned value (total) in controlling area currency
PWRTFXMC_PWRTFXCURR19(2) Planned value (fixed) in controlling area currency
PWRTVRMC_PWRTVRCURR19(2) Planned value (variable) in controlling area currency



Key field
Non-key field