1. Home
  2. Resources
  3. SAP Tables
  4. LGORT - Material Master View on Storage Location and Batch Selection

SAP Table LGORT

Material Master View on Storage Location and Batch Selection

LGORT (Material Master View on Storage Location and Batch Selection) 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 LGORT to other SAP tables.

LGORT table fields

Field Data element Checktable Datatype Length Decimals
ZEILL Item in Material Document MBLPO NUMC 4 0
XSELP Item selected (selected, chosen, ...) XSELP CHAR 1 0
X Yes
NULL No
XHELL Indicator: sequence of screen displays in foreground XHELL CHAR 1 0
X Yes
NULL No
BESTD Valuated Unrestricted-Use Stock LABST QUAN 13 3
BESTH Quantity in Unit of Entry ERFMG QUAN 13 3
BESTS Quantity in Unit of Entry ERFMG QUAN 13 3
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME UNIT 3 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
MANDT Client MANDT CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
SPERR Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
LABST Valuated Unrestricted-Use Stock LABST QUAN 13 3
UMLME Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
INSME Stock in Quality Inspection INSME QUAN 13 3
EINME Total Stock of All Restricted Batches EINME QUAN 13 3
SPEME Blocked Stock SPEME QUAN 13 3
RETME Blocked Stock Returns RETME QUAN 13 3
VMLAB Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
VMUML Stock in Transfer in Previous Period VMUML QUAN 13 3
VMINS Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
VMEIN Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
VMSPE Blocked stock of previous period VMSPE QUAN 13 3
VMRET Blocked Stock Returns in Previous Period VMRET QUAN 13 3
KZILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZVLL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZVLQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZILE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
KZVLE Physical inventory ind. for restricted-use stock, prev.pd KZVLE CHAR 3 0
KZILS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KZVLS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
LWEDT Date of last goods receipt LWEDT DATS 8 0
ZUSCH Batch status key DZUSCH CHAR 1 0
ZUSTD Batch in Restricted-Use Stock DZUSTD CHAR 1 0
X Yes
NULL No
CHAME Unit of issue for batch (deactivated) CHAME UNIT 3 0
SPERC Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
CLABS Valuated Unrestricted-Use Stock LABST QUAN 13 3
CUMLM Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
CINSM Stock in Quality Inspection INSME QUAN 13 3
CEINM Total Stock of All Restricted Batches EINME QUAN 13 3
CSPEM Blocked Stock SPEME QUAN 13 3
CRETM Blocked Stock Returns RETME QUAN 13 3
CVMLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
CVMUM Stock in Transfer in Previous Period VMUML QUAN 13 3
CVMIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
CVMEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
CVMSP Blocked stock of previous period VMSPE QUAN 13 3
CVMRE Blocked Stock Returns in Previous Period VMRET QUAN 13 3
KZICL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZICQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZICE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
KZICS Physical inventory indicator for blocked stock KZILS CHAR 3 0
FELDN Name of field FELDN CHAR 16 0
VERAB Availability date VERAB DATS 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KZCHF Indicator: Batch determination executed for line item KZCHF CHAR 1 0
X Yes
NULL No