IRLOT

Transparent Table Application Table
32 Fields 1 CDS Views

Reference Functional Location (Table)

IRLOT is an SAP database table in S/4HANA. Reference Functional Location (Table). It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ReferenceFunctionalLocation view_entity from BASIC Reference Functional Location

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY trpnr TRPNR RefLocation
mlang MLANG Primary lang.
tplkz TPLKZ StrIndicator
rltyp RLTYP RefLocCategory
trpma TRPMA Superior RFL
erdat ICRDT Created on
ernam ICRNA Created by
aedat IUPDT Changed on
aenam IUPNA Changed by
begru IAUTG Authorization Group
lvorm RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
submt SUBMT ConstType
mapar RESERVE_CHAR_030 SAP Development Reserve: Format CHAR, Length 30
iequi IEQUI EquipInstall.
iequii INH_IEQUII EqInst. orig.
einzl EINZL Single inst.
einzli INH_BEGRUI AuthGrp orig.
iwerk IWERK Planning Plant
iwerki INH_IWERKI PlPlan orig.
ingrp INGRP Planner Group
ingrpi INH_INGRPI MPlGroup orig.
pm_objty PM_OBJTY Object Type
lgwid LGWID Work Center
lgwidi INH_LGWIDI WorkCtr origin
rbnr RBNR Catalog Profile
rbnr_i INH_RBNR_I MntCatlg orig.
abckz ABCKZ ABC Indic.
abckzi INH_ABCKZI ABC ind. orig.
objnr J_OBJNR Object number
reffuncnllocextidentifier ASM_RFL_EXTERNAL_ID External ID
reffuncnllocisexternal ASM_RFL_IS_EXTERNAL External

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.

-- Reference Functional Location (Table)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IRLOT (
    MANDT,                      -- Client [MANDT]
    TRPNR,                      -- RefLocation [TRPNR]
    MLANG,                      -- Primary lang. [MLANG]
    TPLKZ,                      -- StrIndicator [TPLKZ]
    RLTYP,                      -- RefLocCategory [RLTYP]
    TRPMA,                      -- Superior RFL [TRPMA]
    ERDAT,                      -- Created on [ICRDT]
    ERNAM,                      -- Created by [ICRNA]
    AEDAT,                      -- Changed on [IUPDT]
    AENAM,                      -- Changed by [IUPNA]
    BEGRU,                      -- Authorization Group [IAUTG]
    LVORM,                      -- SAP Development Reserve: Format CHAR, Length 1 [RESERVE_CHAR_001]
    SUBMT,                      -- ConstType [SUBMT]
    MAPAR,                      -- SAP Development Reserve: Format CHAR, Length 30 [RESERVE_CHAR_030]
    IEQUI,                      -- EquipInstall. [IEQUI]
    IEQUII,                     -- EqInst. orig. [INH_IEQUII]
    EINZL,                      -- Single inst. [EINZL]
    EINZLI,                     -- AuthGrp orig. [INH_BEGRUI]
    IWERK,                      -- Planning Plant [IWERK]
    IWERKI,                     -- PlPlan orig. [INH_IWERKI]
    INGRP,                      -- Planner Group [INGRP]
    INGRPI,                     -- MPlGroup orig. [INH_INGRPI]
    PM_OBJTY,                   -- Object Type [PM_OBJTY]
    LGWID,                      -- Work Center [LGWID]
    LGWIDI,                     -- WorkCtr origin [INH_LGWIDI]
    RBNR,                       -- Catalog Profile [RBNR]
    RBNR_I,                     -- MntCatlg orig. [INH_RBNR_I]
    ABCKZ,                      -- ABC Indic. [ABCKZ]
    ABCKZI,                     -- ABC ind. orig. [INH_ABCKZI]
    OBJNR,                      -- Object number [J_OBJNR]
    REFFUNCNLLOCEXTIDENTIFIER,  -- External ID [ASM_RFL_EXTERNAL_ID]
    REFFUNCNLLOCISEXTERNAL,     -- External [ASM_RFL_IS_EXTERNAL]
    PRIMARY KEY (MANDT, TRPNR)
);

Learn More