MSSQ

Project Stock Total | view | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
SOBKZ FK Special Stock Indicator
PSPNR FK Work Breakdown Structure Element (WBS Element)
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
SQLAB Valuated Unrestricted-Use Stock
SQINS Stock in Quality Inspection
SQSPE Blocked Stock
SQEIN Total Stock of All Restricted Batches
SQTRA Stock in transit
SQBWE Valuated Goods Receipt Blocked Stock, Project
/CWM/SQLAB Valuated Unrestricted-Use Stock
/CWM/SQINS Stock in Quality Inspection
/CWM/SQSPE Blocked Stock
/CWM/SQEIN Total Stock of All Restricted Batches
/CWM/SQTRA Stock in transit
/CWM/SQBWE Valuated Goods Receipt Blocked Stock, Project
Column Name Description
ERSDA Created On
Column Name Description
KZBWS Valuation of Special Stock Show values
SQRUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
Master Data Relations Join Conditions
Client MSSQ.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MSSQ.MATNR == MARA.MATNR
  • MSSQ.MANDT == MARA.MANDT
Special Stock Indicator
  • MSSQ.MANDT == T148.MANDT
  • MSSQ.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSSQ.MATNR == MARC.MATNR
  • MSSQ.MANDT == MARC.MANDT
  • MSSQ.WERKS == MARC.WERKS