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.
Source: IRLOT (Reference Functional Location (Table))
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 |
Possible values
|
||||||||||
IEQUII | Data origin for equip. inst. allowed field | INH_IEQUII | CHAR | 1 | 0 |
Possible values
|
||||||||||
EINZL | Single equipment installation at functional location | EINZL | CHAR | 1 | 0 |
Possible values
|
||||||||||
EINZLI | Data origin for authorization group field | INH_BEGRUI | CHAR | 1 | 0 |
Possible values
|
||||||||||
IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||||||
IWERKI | Data origin for planning plant field | INH_IWERKI | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
RBNR | Catalog Profile | RBNR | T352B | CHAR | 9 | 0 | ||||||||||
RBNR_I | Data origin for maintenance catalog field | INH_RBNR_I | CHAR | 1 | 0 |
Possible values
|
||||||||||
ABCKZ | ABC indicator for technical object | ABCKZ | T370C | CHAR | 1 | 0 | ||||||||||
ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 | ABCKZ | T370C | ABC indicator for technical objects | ABCKZ |
IRLOT | ABCKZ | IRLOT | MANDT | T370C | ABC indicator for technical objects | MANDT |
IRLOT | BEGRU | IRLOT | BEGRU | T370B | Technical object authorization group | BEGRU |
IRLOT | BEGRU | IRLOT | MANDT | T370B | Technical object authorization group | MANDT |
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 | OBJNR | ONR00 | General Object Number | OBJNR |
IRLOT | OBJNR | IRLOT | MANDT | ONR00 | General Object Number | MANDT |
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 | TRPMA | IRLOT | Reference Functional Location (Table) | TRPNR |
IRLOT | TRPMA | IRLOT | MANDT | IRLOT | Reference Functional Location (Table) | MANDT |