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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
IEQUII
Data origin for equip. inst. allowed field
|
INH_IEQUII |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
EINZL
Single equipment installation at functional location
|
EINZL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
EINZLI
Data origin for authorization group field
|
INH_BEGRUI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T399I |
CHAR
|
4 | 0 | |||||||||||
|
IWERKI
Data origin for planning plant field
|
INH_IWERKI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
PM_OBJTY
Object Type of CIM Resources for Work Center
|
PM_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
RBNR
Catalog Profile
|
RBNR | T352B |
CHAR
|
9 | 0 | |||||||||||
|
RBNR_I
Data origin for maintenance catalog field
|
INH_RBNR_I |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ABCKZ
ABC indicator for technical object
|
ABCKZ | T370C |
CHAR
|
1 | 0 | |||||||||||
|
ABCKZI
Data origin for ABC indicator field
|
INH_ABCKZI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| IRLOT | INGRP | IRLOT | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| IRLOT | INGRP | IRLOT | INGRP |
T024I
Maintenance planner groups
|
INGRP |
| IRLOT | IWERK | IRLOT | MANDT |
T399I
Planning plant parameters
|
MANDT |
| IRLOT | IWERK | IRLOT | IWERK |
T399I
Planning plant parameters
|
IWERK |
| IRLOT | LGWID | IRLOT | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| IRLOT | LGWID | IRLOT | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| IRLOT | LGWID | IRLOT | LGWID |
CRID
CIM Resource - Entities
|
OBJID |
| 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 | SUBMT |
MARA
General Material Data
|
MATNR |
| IRLOT | SUBMT | IRLOT | MANDT |
MARA
General Material Data
|
MANDT |
| IRLOT | TPLKZ | IRLOT | MANDT |
T370S
Functional Location Structure Indicators
|
MANDT |
| IRLOT | TPLKZ | IRLOT | TPLKZ |
T370S
Functional Location Structure Indicators
|
TPLKZ |
| IRLOT | TRPMA | IRLOT | MANDT |
IRLOT
Reference Functional Location (Table)
|
MANDT |
| IRLOT | TRPMA | IRLOT | TRPMA |
IRLOT
Reference Functional Location (Table)
|
TRPNR |