SAP table IRLOT (Reference Functional Location (Table))
SAP table IRLOT has 2 primary key fields being MANDT,TRPNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| 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 |
IRLOT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 IRLOT | ABCKZ | T370C | ABC indicator for technical objects | MANDT |
| 1 IRLOT | BEGRU | T370B | Technical object authorization group | MANDT |
| 1 IRLOT | BEGRU | T370B | Technical object authorization group | BEGRU |
| 0 IRLOT | INGRP | T024I | Maintenance planner groups | INGRP |
| 1 IRLOT | IWERK | T399I | Planning plant parameters | MANDT |
| 0 IRLOT | LGWID | CRID | CIM Resource - Entities | MANDT |
| 0 IRLOT | LGWID | CRID | CIM Resource - Entities | OBJID |
| 1 IRLOT | MANDT | T000 | Clients | MANDT |
| 0 IRLOT | MLANG | T002 | Language Keys (Component BC-I18) | SPRAS |
| 1 IRLOT | OBJNR | ONR00 | General Object Number | MANDT |
| 0 IRLOT | RBNR | T352B | Technical report | MANDT |
| 1 IRLOT | RLTYP | T370R | Reference Functional Location Category | MANDT |
| 1 IRLOT | RLTYP | T370R | Reference Functional Location Category | RLTYP |
| 0 IRLOT | SUBMT | MARA | General Material Data | MANDT |
| 0 IRLOT | SUBMT | MARA | General Material Data | MATNR |
| 1 IRLOT | TPLKZ | T370S | Functional Location Structure Indicators | MANDT |
| 1 IRLOT | TPLKZ | T370S | Functional Location Structure Indicators | TPLKZ |
| 0 IRLOT | TRPMA | IRLOT | Reference Functional Location (Table) | TRPNR |