SE11 ABAP Dictionary SE11 T001L

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

T001L

Storage Locations
SAP SAP Transparent Table 20 Fields
Primary Key:
MANDT WERKS LGORT

Dictionary Fields Fields

(20 dari 20 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
WERKS
KEY Plant CHAR 4 - T001W Plant
3
LGORT
KEY Stor. Loc. CHAR 4 - T001L Storage Location
4
LGOBE
- Descr. CHAR 16 - - Description of Storage Location
5
SPART
- Division CHAR 2 - - Division
6
XLONG
- Neg.stocks CHAR 1 - - Negative stocks allowed in storage location
7
XBUFX
- FrzBookInv CHAR 1 - - Freezing book inventory bal. allowed in stor. loc.
8
DISKZ
- MRP CHAR 1 - - Storage location MRP indicator
9
XBLGO
- Authoriztn CHAR 1 - - Storage location authorization for goods movements active
10
XRESS
- St. res. CHAR 1 - - Storage location is allocated to resource (storage resource)
11
XHUPF
- HU reqmnt CHAR 1 - - Handling unit requirement
12
PARLG
- Part. SLoc CHAR 4 - - Partner storage location of the handling unit
13
VKORG
- Sales org. CHAR 4 - - Sales Organization
14
VTWEG
- Distr. Chl CHAR 2 - - Distribution Channel
15
VSTEL
- Ship Point CHAR 4 - - Shipping Point/Receiving Point
16
LIFNR
- Vendor CHAR 10 - LFA1 Vendor Account Number
17
KUNNR
- Customer CHAR 10 - KNA1 Account Number of Customer
18
OIH_LICNO
- License nr CHAR 15 - - License number for untaxed stock
19
OIG_ITRFL
- Intr.flag CHAR 1 - - TD in-transit flag
20
OIB_TNKASSIGN
- TkInd CHAR 1 - - Silo Managament: Tank assignment indicator

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk T001L.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes
SE11 SE16
Related Tables
T001W LFA1 KNA1
ANSI SQL Query 
SELECT a.WERKS,
       a.LGORT,
       a.LGOBE,
       a.SPART,
       a.XLONG,
       a.XBUFX,
       a.DISKZ
FROM T001L AS a
WHERE a.WERKS = '0001'
  AND a.LGORT = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~werks,
       a~lgort,
       a~lgobe,
       a~spart,
       a~xlong,
       a~xbufx,
       a~diskz
  FROM t001l AS a
  WHERE a~werks = '0001'
  and a~lgort = '0001'
  INTO TABLE @DATA(lt_t001l)
  UP TO 100 ROWS.