T001L

Transparent Table Customizing Table
23 Fields 11 CDS Views

Storage Locations

T001L is an SAP database table in S/4HANA. Storage Locations. It contains 23 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
F_Mmim_T001l_Auth view from Storage Location Authorities
I_ACMStorageLocVH view_entity from BASIC App Doc Storage Location
I_NominationInTrnstStorLocVH view from BASIC InTransit Storage Location
I_ProductionStorageLocationVH view from BASIC Production Storage Location Value Help
I_StorageLocation view from BASIC Storage Location
P_MRPAreaStorLoc view inner BASIC
pph_ddl_stock_2 view left_outer
pph_ddl_stock_kf_1 view left_outer
pph_ddmrp_stock_lines1 view left_outer DDMRP Stock
SHSM_H_MARD view left_outer CDS View for H_MARD (search help)
SHSM_T001L view from

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY lgort LGORT_D Location
lgobe LGOBE Description
spart SPART Division
xlong XLONG Neg.stocks SLoc
xbufx XBUFX FrzBookInv SLoc
diskz DISKZ MRP ind.
xblgo XBLGO Authorization
xress XRESS Stor. Resource
xhupf XHUPF HU reqmnt
parlg PARLG Partner storLoc
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
vstel VSTEL Shipping Point
lifnr ELIFN Supplier
kunnr EKUNN Customer
mesbs MB_MES_BUSINESS_SYSTEM Business System
messt MB_MES_STORLOC_TYPE Inv Mnngmt Type
configdeprecationcode CONFIG_DEPRECATION_CODE Validity
oih_licno OIH_LICNO License number
oig_itrfl OIG_ITRFL In-transit
oib_tnkassign OIB_TNKASSIGN Tank.assn.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Storage Locations
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T001L (
    MANDT,                  -- Client [MANDT]
    WERKS,                  -- Plant [WERKS_D]
    LGORT,                  -- Location [LGORT_D]
    LGOBE,                  -- Description [LGOBE]
    SPART,                  -- Division [SPART]
    XLONG,                  -- Neg.stocks SLoc [XLONG]
    XBUFX,                  -- FrzBookInv SLoc [XBUFX]
    DISKZ,                  -- MRP ind. [DISKZ]
    XBLGO,                  -- Authorization [XBLGO]
    XRESS,                  -- Stor. Resource [XRESS]
    XHUPF,                  -- HU reqmnt [XHUPF]
    PARLG,                  -- Partner storLoc [PARLG]
    VKORG,                  -- Sales Org. [VKORG]
    VTWEG,                  -- Distr. Channel [VTWEG]
    VSTEL,                  -- Shipping Point [VSTEL]
    LIFNR,                  -- Supplier [ELIFN]
    KUNNR,                  -- Customer [EKUNN]
    MESBS,                  -- Business System [MB_MES_BUSINESS_SYSTEM]
    MESST,                  -- Inv Mnngmt Type [MB_MES_STORLOC_TYPE]
    CONFIGDEPRECATIONCODE,  -- Validity [CONFIG_DEPRECATION_CODE]
    OIH_LICNO,              -- License number [OIH_LICNO]
    OIG_ITRFL,              -- In-transit [OIG_ITRFL]
    OIB_TNKASSIGN,          -- Tank.assn. [OIB_TNKASSIGN]
    PRIMARY KEY (MANDT, WERKS, LGORT)
);

Learn More