| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | No | T300 | LGNUM | Allow NULL? |
| 3 | LGTYP | Storage Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T301 | LGTYP | Allow NULL? |
| 4 | KZNKO | Indicator: Execute Zero Stock Check | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZNKO | Allow NULL? |
| 5 | KAPAP | Capacity Check Method | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_KAPAP | Allow NULL? |
| 6 | QUEIN | Indicator: Confirmation of Putaway Required | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_QUEIN | Allow NULL? |
| 7 | QUAUS | Indicator: confirmation of stock removal required | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_QUAUS | Allow NULL? |
| 8 | VOLLE | Indicator: complete stock removal required | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_VOLLE | Allow NULL? |
| 9 | MISCH | Indicator: mixed storage | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_MISCH | Allow NULL? |
| 10 | ZULAG | Indicator: addition to existing stock allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_ZULAG | Allow NULL? |
| 11 | NEGAT | Indicator: negative stock quantity allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_NEGAT | Allow NULL? |
| 12 | VRUCK | Indicator: Upon transfer return quantity to same storage bin | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_VRUCK | Allow NULL? |
| 13 | UEBER | Indicator: retain overdeliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_UEBER | Allow NULL? |
| 14 | RLTYP | Return storage type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T301 | T331_RLTYP | Allow NULL? |
| 15 | STAUS | Stock Removal Strategy | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_STAUS | Allow NULL? |
| 16 | STEIN | Putaway strategy | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_STEIN | Allow NULL? |
| 17 | KZINV | Inventory method | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | T331_KZINV | Allow NULL? |
| 18 | SKZEI | Blocking indicator: block bin for placement into stock | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_SKZEI | Allow NULL? |
| 19 | SKZAU | Blocking indicator: block storage bin for stock removals | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_SKZAU | Allow NULL? |
| 20 | LDEST | Name of printer | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSP03 | LVS_LDEST | Allow NULL? |
| 21 | SFIFO | Indicator: no stock removal if strict FIFO removal strat.set | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_SFIFO | Allow NULL? |
| 22 | SPEIN | Set blocking indicator at time of placement into storage | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_SPEIN | Allow NULL? |
| 23 | SPAUS | Set blocking indicator at time of stock removal | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_SPAUS | Allow NULL? |
| 24 | SPGRU | Blocking reason | char | 1 | 0 | CHAR | (N' ') | Yes | T330 | LVS_SPGRU | Allow NULL? |
| 25 | PRLET | Ind: Activate storage unit type check for stock placement | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_PRLET | Allow NULL? |
| 26 | PRBER | Indicator: storage section check active | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_PRBER | Allow NULL? |
| 27 | WGFKL | Water Pollution Class | char | 1 | 0 | NUMC | (N'0') | Yes | | MGEF_WGFKL | Allow NULL? |
| 28 | GEFAL | Indicator: management of hazardous materials active | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_GEFAL | Allow NULL? |
| 29 | KZUAP | Indicator: post and leave materials in same storage bin | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZUAP | Allow NULL? |
| 30 | INVPE | Continuous inventory upon placement into stock | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_INVPE | Allow NULL? |
| 31 | INVPN | Continuous inventory based on zero stock check | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_INVPN | Allow NULL? |
| 32 | LENVW | Indicator: Storage type with storage unit management | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_LENVW | Allow NULL? |
| 33 | IPUNK | Indicator: Storage type is an identification point | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_IPUNK | Allow NULL? |
| 34 | IPTYP | Identification point for storage type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T301 | T331_IPTYP | Allow NULL? |
| 35 | KPUNK | Indicator: Storage type is a pick point | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_KPUNK | Allow NULL? |
| 36 | KPTYP | Pick point for storage type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T301 | T331_KPTYP | Allow NULL? |
| 37 | BWWMP | WM movement type for internal warehouse supply | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T333 | T331_BWWMP | Allow NULL? |
| 38 | USEIN | Stock placement strategy via user exit | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_USEIN | Allow NULL? |
| 39 | USAUS | Stock removal strategy via user exit | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_USAUS | Allow NULL? |
| 40 | MAILK | Mail control for replenishment stor.type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T333M | T331_MAILK | Allow NULL? |
| 41 | INVCC | Inventory through Cycle Counting | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_INVCC | Allow NULL? |
| 42 | MINWM | Storage type does not manage bin stock | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_MINWM | Allow NULL? |
| 43 | MRAUS | Switch off quantity reduction for TOs for PP mat. staging | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_MRAUS | Allow NULL? |
| 44 | TBZUG | Database access to trans. requirements during qty reduction | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_TBZUG | Allow NULL? |
| 45 | MEAUS | Un.of measure type search for planned proc.time, picking TO | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_MEAUS | Allow NULL? |
| 46 | MEEIN | Un.of measure type search for planned proc.time, plcmnt TO | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_MEEIN | Allow NULL? |
| 47 | AKTKA | Active capacity check | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_AKTKA | Allow NULL? |
| 48 | RDMNG | Round off requested quantity for stock removal | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_RDMNG | Allow NULL? |
| 49 | NPLEI | Dest.stor.bin changeable during confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_NPLEI | Allow NULL? |
| 50 | PIKTA | Control for HU pick | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_PIKTA | Allow NULL? |
| 51 | NOGRE | Goods receipt posting not allowed for this storage type | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_NOGRE | Allow NULL? |
| 52 | NOGIS | No goods issue posting allowed for this storage type | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_NOGIS | Allow NULL? |
| 53 | NOTRP | Posting changes to this storage type not allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_NOTRP | Allow NULL? |
| 54 | NODIF | No difference posting allowed in this storage type | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_NODIF | Allow NULL? |
| 55 | REPLT | Replenishment method in the storage type | char | 1 | 0 | CHAR | (N' ') | Yes | | T331_REPLT | Allow NULL? |
| 56 | PROFILE | Picking Profile: HUs from WM | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | CHUWMPUT | PL_PROFILE_WM | Allow NULL? |
| 57 | LZONE | Zone | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LAGP_LZONE | Allow NULL? |
| 58 | XCORD | X Coordinate | decimal | 10 | 3 | QUAN | ((0)) | Yes | | LAGP_XCORD | |
| 59 | YCORD | Y Coordinate | decimal | 10 | 3 | QUAN | ((0)) | Yes | | LAGP_YCORD | |
| 60 | ZCORD | Z Coordinate | decimal | 10 | 3 | QUAN | ((0)) | Yes | | LAGP_ZCORD | |
