SAP-tabelreferentie
IRLOT
Reference Functional Location (Table)Bekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel IRLOT.
SAP-tabel IRLOT heeft 2 primaire sleutelvelden: MANDT,TRPNR.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
IRLOT velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel 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 |
/ Relaties
IRLOT relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |