SAP table reference
IRLOT
Reference Functional Location (Table)Explore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table IRLOT.
SAP table IRLOT has 2 primary key fields: MANDT,TRPNR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
IRLOT fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key TRPNR | Reference functional location | CHAR | 30 | 0 | TRPNR | ||
| MLANG | Primary language for object texts | LANG | 1 | 0 | T002 | MLANG | |
| TPLKZ | Functional Location Structure Indicator | CHAR | 5 | 0 | T370S | TPLKZ | |
| RLTYP | Reference functional location category | CHAR | 1 | 0 | T370R | RLTYP | |
| TRPMA | Superior reference functional location | CHAR | 30 | 0 | IRLOT | TRPMA | |
| ERDAT | Date on which the object was created | DATS | 8 | 0 | ICRDT | ||
| ERNAM | Name of User Who Created the Object | CHAR | 12 | 0 | ICRNA | ||
| AEDAT | Date on which the object was last changed | DATS | 8 | 0 | IUPDT | ||
| AENAM | Name of the user who last changed the object | CHAR | 12 | 0 | IUPNA | ||
| BEGRU | Technical Object Authorization Group | CHAR | 4 | 0 | T370B | IAUTG | |
| LVORM | SAP Development Reserve: Format CHAR, Length 1 | CHAR | 1 | 0 | RESERVE_CHAR_001 | ||
| SUBMT | Construction type material of the object | CHAR | 40 | 0 | MARA | SUBMT | |
| MAPAR | SAP Development Reserve: Format CHAR, Length 30 | CHAR | 30 | 0 | RESERVE_CHAR_030 | ||
| IEQUI | Installation of equipment allowed at the functional location | CHAR | 1 | 0 | IEQUI | ||
| IEQUII | Data origin for equip. inst. allowed field | CHAR | 1 | 0 | INH_IEQUII | ||
| EINZL | Single equipment installation at functional location | CHAR | 1 | 0 | EINZL | ||
| EINZLI | Data origin for authorization group field | CHAR | 1 | 0 | INH_BEGRUI | ||
| IWERK | Maintenance Planning Plant | CHAR | 4 | 0 | T399I | IWERK | |
| IWERKI | Data origin for planning plant field | CHAR | 1 | 0 | INH_IWERKI | ||
| INGRP | Planner Group for Customer Service and Plant Maintenance | CHAR | 3 | 0 | T024I | INGRP | |
| INGRPI | Data origin for maintenance planner group field | CHAR | 1 | 0 | INH_INGRPI | ||
| PM_OBJTY | Object Type of CIM Resources for Work Center | CHAR | 2 | 0 | PM_OBJTY | ||
| LGWID | Object ID of the Work Center | NUMC | 8 | 0 | CRID | LGWID | |
| LGWIDI | Data Origin for the Field 'Work Center' | CHAR | 1 | 0 | INH_LGWIDI | ||
| RBNR | Catalog Profile | CHAR | 9 | 0 | T352B | RBNR | |
| RBNR_I | Data origin for maintenance catalog field | CHAR | 1 | 0 | INH_RBNR_I | ||
| ABCKZ | ABC Indicator for Technical Object | CHAR | 1 | 0 | T370C | ABCKZ | |
| ABCKZI | Data origin for ABC indicator field | CHAR | 1 | 0 | INH_ABCKZI | ||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR |
/ Relationships
IRLOT relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| IRLOT | ABCKZ | T370C | ABC indicator for technical objects | MANDT |
| IRLOT | BEGRU | T370B | Technical object authorization group | MANDT |
| IRLOT | BEGRU | T370B | Technical object authorization group | BEGRU |
| IRLOT | INGRP | T024I | Maintenance planner groups | INGRP |
| IRLOT | IWERK | T399I | Planning plant parameters | MANDT |
| IRLOT | LGWID | CRID | CIM Resource - Entities | MANDT |
| IRLOT | LGWID | CRID | CIM Resource - Entities | OBJID |
| IRLOT | MANDT | T000 | Clients | MANDT |
| IRLOT | MLANG | T002 | Language Keys (Component BC-I18) | SPRAS |
| IRLOT | OBJNR | ONR00 | General Object Number | MANDT |
| IRLOT | RBNR | T352B | Technical report | MANDT |
| IRLOT | RLTYP | T370R | Reference Functional Location Category | MANDT |
| IRLOT | RLTYP | T370R | Reference Functional Location Category | RLTYP |
| IRLOT | SUBMT | MARA | General Material Data | MANDT |
| IRLOT | SUBMT | MARA | General Material Data | MATNR |
| IRLOT | TPLKZ | T370S | Functional Location Structure Indicators | MANDT |
| IRLOT | TPLKZ | T370S | Functional Location Structure Indicators | TPLKZ |
| IRLOT | TRPMA | IRLOT | Reference Functional Location (Table) | TRPNR |