SAP table T331 (Storage Type Control)

SAP table T331 has 3 primary key fields being MANDT,LGNUM,LGTYP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
KZNKO Indicator: Execute Zero Stock Check CHAR 1 0 LVS_KZNKO
KAPAP Capacity Check Method CHAR 1 0 T331_KAPAP
No capacity check
1 Check according to maximum weight
2 Check based on palletization accord. to SUT 1
3 Check based on maximum quantity per bin in storage type
4 Usage check based on material
5 Usage check based on SUT
6 Usage check based on material plus SUT
QUEIN Indicator: Confirmation of Putaway Required CHAR 1 0 T331_QUEIN
QUAUS Indicator: confirmation of stock removal required CHAR 1 0 T331_QUAUS
VOLLE Indicator: complete stock removal required CHAR 1 0 T331_VOLLE
MISCH Indicator: mixed storage CHAR 1 0 T331_MISCH
Mixed storage not allowed
A Several homogeneous storage units per bin
B Several batches per bin and pallet (only SU bulk storage)
C Several batches per bin (only SU bulk storage)
P One mixed storage unit per bin
X Mixed storage without limitations
ZULAG Indicator: addition to existing stock allowed CHAR 1 0 T331_ZULAG
Addition to existing stock generally not permitted.
M Addition to existing stock via addtn ID in material record.
X Addition to existing stock permitted.
NEGAT Indicator: negative stock quantity allowed CHAR 1 0 T331_NEGAT
VRUCK Indicator: Upon transfer return quantity to same storage bin CHAR 1 0 T331_VRUCK
UEBER Indicator: retain overdeliveries CHAR 1 0 T331_UEBER
RLTYP Return storage type CHAR 3 0 T301 T331_RLTYP
STAUS Stock Removal Strategy CHAR 1 0 T331_STAUS
No stock removal strategy
A Partial quantity management
F FIFO (First in first out)
G FIFO (First in First Out), GUID-Based
H Shelf life expiration date
L LIFO (Last in first out)
M Large/small quantities included
P Fixed bin from material master
R Dynamic coordinate reference number
STEIN Putaway strategy CHAR 1 0 T331_STEIN
Manual stock placement
B Bulk storage
C Open storage
F Fixed bins
I Addition to existing stock
K Near picking bin
L Next empty bin
P Storage unit type
Q Dynamic coordinate quant number
R Dynamic coordinate reference number
KZINV Inventory method CHAR 2 0 T331_KZINV
No inventory
PZ Continuous inventory
ST Annual inventory
SKZEI Blocking indicator: block bin for placement into stock CHAR 1 0 T331_SKZEI
SKZAU Blocking indicator: block storage bin for stock removals CHAR 1 0 T331_SKZAU
LDEST Name of printer CHAR 4 0 TSP03 LVS_LDEST
SFIFO Indicator: no stock removal if strict FIFO removal strat.set CHAR 1 0 T331_SFIFO
SPEIN Set blocking indicator at time of placement into storage CHAR 1 0 T331_SPEIN
SPAUS Set blocking indicator at time of stock removal CHAR 1 0 T331_SPAUS
SPGRU Blocking reason CHAR 1 0 T330 LVS_SPGRU
PRLET Ind: Activate storage unit type check for stock placement CHAR 1 0 T331_PRLET
PRBER Indicator: storage section check active CHAR 1 0 T331_PRBER
No storage section determination or check
X Storage section determination and check
Y Storage section determination, no check
WGFKL Water Pollution Class NUMC 1 0 MGEF_WGFKL
0 Not a water pollutant
1 Minimal water pollution danger
2 Water pollutant
3 Extreme water pollution danger
GEFAL Indicator: management of hazardous materials active CHAR 1 0 T331_GEFAL
No hazardous material check
1 Hazardous material check only at storage type level
2 Haz.mat.check at stor.type and stor.section levels
KZUAP Indicator: post and leave materials in same storage bin CHAR 1 0 LVS_KZUAP
INVPE Continuous inventory upon placement into stock CHAR 1 0 LVS_INVPE
INVPN Continuous inventory based on zero stock check CHAR 1 0 LVS_INVPN
LENVW Indicator: Storage type with storage unit management CHAR 1 0 T331_LENVW
IPUNK Indicator: Storage type is an identification point CHAR 1 0 T331_IPUNK
IPTYP Identification point for storage type CHAR 3 0 T301 T331_IPTYP
KPUNK Indicator: Storage type is a pick point CHAR 1 0 T331_KPUNK
KPTYP Pick point for storage type CHAR 3 0 T301 T331_KPTYP
BWWMP WM movement type for internal warehouse supply NUMC 3 0 T333 T331_BWWMP
USEIN Stock placement strategy via user exit CHAR 1 0 T331_USEIN
USAUS Stock removal strategy via user exit CHAR 1 0 T331_USAUS
MAILK Mail control for replenishment stor.type CHAR 2 0 T333M T331_MAILK
INVCC Inventory through Cycle Counting CHAR 1 0 LVS_INVCC
MINWM Storage type does not manage bin stock CHAR 1 0 T331_MINWM
MRAUS Switch off quantity reduction for TOs for PP mat. staging CHAR 1 0 T331_MRAUS
TBZUG Database access to trans. requirements during qty reduction CHAR 1 0 T331_TBZUG
MEAUS Un.of measure type search for planned proc.time, picking TO CHAR 1 0 T331_MEAUS
MEEIN Un.of measure load cat. det for planned proc.time, plcmnt TO CHAR 1 0 T331_MEEIN
AKTKA Active capacity check CHAR 1 0 T331_AKTKA
RDMNG Round off requested quantity for stock removal CHAR 1 0 T331_RDMNG
NPLEI Dest.stor.bin changeable during confirmation CHAR 1 0 LVS_NPLEI
Storage bin cannot be changed during confirmation
1 Storage bin can be changed during confirmation
PIKTA Control for HU pick CHAR 1 0 T331_PIKTA
Adopt source HU with lower-level HUs into pick HU
1 Propose source HU as destination HU
2 Movement type controls proposal for destination HU
3 Only adopt content (mat. and lower-level HUs) into pick HU
NOGRE Goods receipt posting not allowed for this storage type CHAR 1 0 T331_NOGRE
Goods receipt posting allowed for this storage type
X Goods receipt posting not allowed for this storage type
NOGIS No goods issue posting allowed for this storage type CHAR 1 0 T331_NOGIS
Goods issue posting allowed for this storage type
X Goods issue posting not allowed for this storage type
NOTRP Posting changes to this storage type not allowed CHAR 1 0 T331_NOTRP
Posting changes to this storage type allowed
X Posting changes to this storage type not allowed
NODIF No difference posting allowed in this storage type CHAR 1 0 T331_NODIF
Clearing differences allowed
X Clearing differences not allowed
REPLT Replenishment method in the storage type CHAR 1 0 T331_REPLT
Replenishment report
1 Transfer orders (immed.) for fixed bin
2 Transfer orders (immed.) random
PROFILE Picking Profile: HUs from WM CHAR 4 0 CHUWMPUT PL_PROFILE_WM
LZONE Zone CHAR 10 0 LAGP_LZONE
XCORD X Coordinate QUAN 10 3 LAGP_XCORD
YCORD Y Coordinate QUAN 10 3 LAGP_YCORD
ZCORD Z Coordinate QUAN 10 3 LAGP_ZCORD

T331 foreign key relationships

Table Field Check Table Check Field
0 T331 BWWMP T333 WM Movement Types MANDT
0 T331 BWWMP T333 WM Movement Types LGNUM
1 T331 IPTYP T301 WM Storage Types MANDT
1 T331 IPTYP T301 WM Storage Types LGNUM
1 T331 IPTYP T301 WM Storage Types LGTYP
0 T331 KPTYP T301 WM Storage Types MANDT
0 T331 KPTYP T301 WM Storage Types LGNUM
0 T331 KPTYP T301 WM Storage Types LGTYP
1 T331 LDEST TSP03 Spool: Printer declaration PADEST
0 T331 LGNUM T300 WM Warehouse Numbers MANDT
0 T331 LGNUM T300 WM Warehouse Numbers LGNUM
1 T331 LGTYP T301 WM Storage Types MANDT
1 T331 LGTYP T301 WM Storage Types LGNUM
1 T331 LGTYP T301 WM Storage Types LGTYP
0 T331 MAILK T333M Mail control for background processing MANDT
0 T331 MAILK T333M Mail control for background processing LGNUM
1 T331 PROFILE CHUWMPUT Picking Parameter for HUs from WM for Picking Profile PROFILE
0 T331 RLTYP T301 WM Storage Types MANDT
0 T331 RLTYP T301 WM Storage Types LGNUM
0 T331 RLTYP T301 WM Storage Types LGTYP
1 T331 SPGRU T330 Blocking Reasons MANDT
1 T331 SPGRU T330 Blocking Reasons LGNUM
1 T331 SPGRU T330 Blocking Reasons SPGRU