1. Home
  2. Resources
  3. SAP Tables
  4. IRLOT - Reference Functional Location (Table)

SAP Table IRLOT

Reference Functional Location (Table)

IRLOT (Reference Functional Location (Table)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IRLOT to other SAP tables.

IRLOT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TRPNR Reference functional location TRPNR CHAR 30 0
MLANG Primary language for object texts MLANG T002 LANG 1 0
TPLKZ Functional location structure indicator TPLKZ T370S CHAR 5 0
RLTYP Reference functional location category RLTYP T370R CHAR 1 0
TRPMA Superior reference functional location TRPMA IRLOT CHAR 30 0
ERDAT Date on which the object was created ICRDT DATS 8 0
ERNAM Name of User Who Created the Object ICRNA CHAR 12 0
AEDAT Date on which the object was last changed IUPDT DATS 8 0
AENAM Name of the user who last changed the object IUPNA CHAR 12 0
BEGRU Technical object authorization group IAUTG T370B CHAR 4 0
LVORM SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
SUBMT Construction type material of the object SUBMT MARA CHAR 18 0
MAPAR SAP Development Reserve: Format CHAR, Length 30 RESERVE_CHAR_030 CHAR 30 0
IEQUI Installation of equipment allowed at the functional location IEQUI CHAR 1 0
X Yes
NULL No
IEQUII Data origin for equip. inst. allowed field INH_IEQUII CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EINZL Single equipment installation at functional location EINZL CHAR 1 0
X Yes
NULL No
EINZLI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IWERK Maintenance Planning Plant IWERK T399I CHAR 4 0
IWERKI Data origin for planning plant field INH_IWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
INGRP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
INGRPI Data origin for maintenance planner group field INH_INGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
LGWID Object ID of the Work Center LGWID CRID NUMC 8 0
LGWIDI Data Origin for the Field 'Work Center' INH_LGWIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
RBNR Catalog Profile RBNR T352B CHAR 9 0
RBNR_I Data origin for maintenance catalog field INH_RBNR_I CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
ABCKZI Data origin for ABC indicator field INH_ABCKZI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
OBJNR Object number J_OBJNR ONR00 CHAR 22 0

IRLOT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IRLOT ABCKZ IRLOT MANDT T370C ABC indicator for technical objects MANDT
IRLOT ABCKZ IRLOT ABCKZ T370C ABC indicator for technical objects ABCKZ
IRLOT BEGRU IRLOT MANDT T370B Technical object authorization group MANDT
IRLOT BEGRU IRLOT BEGRU T370B Technical object authorization group BEGRU
IRLOT INGRP IRLOT IWERK T024I Maintenance planner groups IWERK
IRLOT INGRP IRLOT INGRP T024I Maintenance planner groups INGRP
IRLOT INGRP IRLOT MANDT T024I Maintenance planner groups MANDT
IRLOT IWERK IRLOT MANDT T399I Planning plant parameters MANDT
IRLOT IWERK IRLOT IWERK T399I Planning plant parameters IWERK
IRLOT LGWID IRLOT LGWID CRID CIM Resource - Entities OBJID
IRLOT LGWID IRLOT MANDT CRID CIM Resource - Entities MANDT
IRLOT LGWID IRLOT PM_OBJTY CRID CIM Resource - Entities OBJTY
IRLOT MANDT IRLOT MANDT T000 Clients MANDT
IRLOT MLANG IRLOT MLANG T002 Language Keys (Component BC-I18) SPRAS
IRLOT OBJNR IRLOT MANDT ONR00 General Object Number MANDT
IRLOT OBJNR IRLOT OBJNR ONR00 General Object Number OBJNR
IRLOT RBNR IRLOT MANDT T352B Technical report MANDT
IRLOT RBNR IRLOT RBNR T352B Technical report RBNR
IRLOT RLTYP IRLOT MANDT T370R Reference Functional Location Category MANDT
IRLOT RLTYP IRLOT RLTYP T370R Reference Functional Location Category RLTYP
IRLOT SUBMT IRLOT MANDT MARA General Material Data MANDT
IRLOT SUBMT IRLOT SUBMT MARA General Material Data MATNR
IRLOT TPLKZ IRLOT TPLKZ T370S Functional Location Structure Indicators TPLKZ
IRLOT TPLKZ IRLOT MANDT T370S Functional Location Structure Indicators MANDT
IRLOT TRPMA IRLOT MANDT IRLOT Reference Functional Location (Table) MANDT
IRLOT TRPMA IRLOT TRPMA IRLOT Reference Functional Location (Table) TRPNR