1. SAP Tutorial
  2. PP Module

MCSFIS SAP table for – R/2 SFIS Data: Old

Here we would like to draw your attention to MCSFIS table in SAP. As we know it is being mainly used with the SAP PP-IS (Information System – PP) component which is coming under PP module (Production Planning). MCSFIS is a SAP standard transparent table used for storing R/2 SFIS Data: Old related data in SAP. It comes under the package MCF.

SAP MCSFIS table

Table MCSFIS technical data

TableMCSFIS
Data storingR/2 SFIS Data: Old
ModulePP
ComponentPP-IS
SAP PackageMCF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MCSFIS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MCSFIS table.

  • KOSTL : Cost Center
    Its a key field. Its data type is C (Character String) with field length 10
  • FSEDD : Earliest scheduled finish: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEDD : Confirmed date for execution finish
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • N_IEAVD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WRTZE : Unit of measure for queue time
    Its data type is C (Character String) with field length 3
  • RSTZE : Unit of measure for setup time
    Its data type is C (Character String) with field length 3
  • BEAZE : Unit of measure for processing time
    Its data type is C (Character String) with field length 3
  • ARUZE : Unit of measure for teardown
    Its data type is C (Character String) with field length 3
  • V_LIEGZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • TRANZ : Move time used for scheduling
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • KBEAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • WERKSK
    Its a key field. Its data type is C (Character String) with field length 4
  • KEINHV
    Its data type is C (Character String) with field length 3
  • DFZEHV
    Its data type is C (Character String) with field length 3
  • I_DFZV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • A
    Its data type is C (Character String) with field length 1
  • DUMMY
    Its data type is C (Character String) with field length 1
  • CHARGM
    Its data type is C (Character String) with field length 10
  • ENMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINSM
    Its data type is C (Character String) with field length 3
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • ARBIDK
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • PSKNZ
    Its data type is C (Character String) with field length 1
  • PREIS : Price
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WRTFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • WAERSK
    Its data type is C (Character String) with field length 5
  • PWERTN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • PWRTVR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AUART : Order Type
    Its data type is C (Character String) with field length 4
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is MCSFISK
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • DISPO : MRP controller
    Its data type is C (Character String) with field length 3
  • GLTRP : Basic finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FTRMS : Scheduled release date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • GSTRS : Scheduled start
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • GETRI : Confirmed Order Finish Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FTRMI : Actual release date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • GASMG : Total scrap quantity in the order
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GMEIN : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • KUNUM : Customer Number
    Its data type is C (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 4
  • PWERK : Planning plant for the order
    Its data type is C (Character String) with field length 4
  • STRMP : Start date of the planned order
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LTRMI : Actual delivery/finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PGMNG : Total planned order quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PSAMG : Scrap quantity in item
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WEMNG : Quantity of goods received for the order item
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AMEIN : Unit of measure for in-house production
    Its data type is C (Character String) with field length 3
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • RSNUM : Number of reservation/dependent requirements
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • S_DFZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • KEINH
    Its data type is C (Character String) with field length 3
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • ZEITP
    Its data type is C (Character String) with field length 2
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNFL : Sequence
    Its data type is C (Character String) with field length 6
  • ARBID : Object ID
    Its data type is N (Character String with Digits Only) with field length 8
  • KAPID : Capacity ID
    Its data type is N (Character String with Digits Only) with field length 8
  • MATNRM
    Its a key field. Its data type is C (Character String) with field length 18
  • STEUS : Control key
    Its data type is C (Character String) with field length 4
  • MEINH : Unit of Measure
    Its data type is C (Character String) with field length 3
  • UMREZV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VERTL : Distr.cap.reqmts (plant maint.,process order, network)
    Its data type is C (Character String) with field length 2
  • MGVRG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMNGA : Yield currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GMNGA : Previously confirmed yield in order unit of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SSADD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSAVD : Earliest scheduled start: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISDD : Confirmed date for start of execution
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8

    • MCSFIS related tables

    • MCPPCUST : Performance Customizing: PPIS
    • MCAFPOV : Versions: Order Item
    • MCKALKW : Versions: Cost Itemization
    • MCAFKOV : Versions: Order Header Data – PP Orders
    • MCCOMPV : Versions: Material Components
    • MCAFVGV : Versions: Order Procedure
    • MCKALKV : Versions: Cost Itemization

    MCSFIS related transaction codes under SAP package MCF

    • MCPB : Operation analysis: Dates
    • MCRK : Prod. Cost Analysis: Repetitive Mfg
    • MCP1 : SFIS: Operation Analysis Selection
    • MCRU : PP-PI: Operation Analysis Selection
    • MCR2 : SFIS: Change Evaluation
    • MCRQ : Call Standard Analyses: PP-IS
    • MCP3 : SFIS: Material Analysis Selection
    • MCP8 : Goods rcpt analysis: repetitive mfg
    • MCQ. : SFIS: Kanban analysis selection
    • MCPF : Material analysis: Dates
    • MCR9 : SFIS: Display Evaluation Structure
    • MCRV : PP-PI: Process Order Analysis
    • MCPK : Operation analysis: Quantities
    • MCPO : Material analysis: Quantities
    • MCRH : Display Settings: PPIS
    • MCRP : Matl consumptn anal.: repetitive mfg
    • MCP7 : SFIS: Work Center Analysis Selection
    • MCPS : Operation analysis: Lead time
    • MCPU : Production Order Analysis: Lead Time
    • MCRI : Product Cost Analysis: Selection

    Related References

    Related Tutorials

    MCAFVGV SAP table for – Versions: Order Procedure

    MCAFVGV table in SAP PP (Information System - PP) module. This tables is used for storing data of Versions: Order...

    KBEZ SAP table for – Add. data for table KBED (for indiv. capacities/splits)

    KBEZ table in SAP PP (Capacity Requirements Planning - PP) module. This tables is used for storing data of Add....

    MCAFPOV SAP table for – Versions: Order Item

    MCAFPOV table in SAP PP (Information System - PP) module. This tables is used for storing data of Versions: Order...

    VTIDERI SAP table for – Master Data Listed Options and Futures

    VTIDERI table in SAP TR (Treasury) module. This tables is used for storing data of Master Data Listed Options and...

    MDKP SAP table for – Header Data for MRP Document

    MDKP table in SAP PP (Material Requirements Planning - PP) module. This tables is used for storing data of Header...

    AFFH SAP table for – PRT assignment data for the work order

    AFFH table in SAP PP (Basic Data - PP) module. This tables is used for storing data of PRT assignment...

    MCAFKOV SAP table for – Versions: Order Header Data – PP Orders

    MCAFKOV table in SAP PP (Information System - PP) module. This tables is used for storing data of Versions: Order...

    «
    »