1. Home
  2. Resources
  3. SAP Tables
  4. SMSKU - Lock Table MSKU

SAP Table SMSKU

Lock Table MSKU

SMSKU (Lock Table MSKU) 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 SMSKU to other SAP tables.

SMSKU table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KUNNR Customer Number KUNNR CHAR 10 0
RMSKU Return code MSKU RMSKU 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
KULAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
KUINS Stock in Quality Inspection INSME QUAN 13 3
KUEIN Total Stock of All Restricted Batches EINME QUAN 13 3
KUVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
KUVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
KUVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
KULAB_OLD Valuated Unrestricted-Use Stock LABST QUAN 13 3
KUINS_OLD Stock in Quality Inspection INSME QUAN 13 3
KUEIN_OLD Total Stock of All Restricted Batches EINME QUAN 13 3
KUVLA_OLD Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
KUVIN_OLD Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
KUVEI_OLD Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
RMSKUH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
KULFM Current period (posting period) LFMON NUMC 2 0
KUGJA Fiscal Year of Current Period LFGJA NUMC 4 0
KURUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No
KUUML Stock in Transfer for Customer Consignment (Plant to Plant) UMLME_W QUAN 13 3
KUUML_OLD Stock in Transfer for Customer Consignment (Plant to Plant) UMLME_W QUAN 13 3
KUVUM Stock in Transfer in Previous Period VMUML QUAN 13 3
KUVUM_OLD Stock in Transfer in Previous Period VMUML QUAN 13 3