MSSQ SAP table for – Project Stock Total

Here we would like to draw your attention to MSSQ table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). MSSQ is a SAP standard transparent table used for storing Project Stock Total related data in SAP. It comes under the package MG.

SAP MSSQ table

Table MSSQ technical data

TableMSSQ
Data storingProject Stock Total
ModuleLO
ComponentLO-MD
SAP PackageMG
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MSSQ 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 MSSQ table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SQEIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • SQRUE
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its a key field. Its data type is C (Character String) with field length 4
  • PSPNR : Standard WBS element
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • LFMON
    Its data type is N (Character String with Digits Only) with field length 2
  • SQINS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7