1. Home
  2. Resources
  3. SAP Tables
  4. SMSSQ - Lock Table MSSQ

SAP Table SMSSQ

Lock Table MSSQ

SMSSQ (Lock Table MSSQ) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SMSSQ to other SAP tables.

SMSSQ table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
RMSSQ Return code MSSQ RMSSQ CHAR 1 0
X Yes
NULL No
XDBUP Database update XDBUP CHAR 1 0
X Yes
NULL No
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
SQLAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
SQINS Stock in Quality Inspection INSME QUAN 13 3
SQSPE Blocked Stock SPEME QUAN 13 3
SQEIN Total Stock of All Restricted Batches EINME QUAN 13 3
SQLAB_OLD Valuated Unrestricted-Use Stock LABST QUAN 13 3
SQINS_OLD Stock in Quality Inspection INSME QUAN 13 3
SQSPE_OLD Blocked Stock SPEME QUAN 13 3
SQEIN_OLD Total Stock of All Restricted Batches EINME QUAN 13 3
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
SQTRA Stock in transit SQTRA QUAN 13 3
SQTRA_OLD Stock in transit SQTRA QUAN 13 3
SQVTR Stock in transit for prev. period SQVTR QUAN 13 3
SQVTR_OLD Stock in transit for prev. period SQVTR QUAN 13 3
RMSSQH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
SQLFM Current period (posting period) LFMON NUMC 2 0
SQGJA Fiscal Year of Current Period LFGJA NUMC 4 0
SQRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No
SQBWE Valuated Goods Receipt Blocked Stock, Project SQBWE QUAN 13 3
SQBWE_OLD Valuated Goods Receipt Blocked Stock, Project SQBWE QUAN 13 3
SQVBW Valuated Goods Receipt Blocked Stock, Project SQBWE QUAN 13 3
SQVBW_OLD Valuated Goods Receipt Blocked Stock, Project SQBWE QUAN 13 3