ILOA SAP (PM Object Location and Account Assignment) Table details
Dictionary Type: Table
Description: PM Object Location and Account Assignment
Description: PM Object Location and Account Assignment
Table field list including key, data, relationships and ABAP select examples
ILOA is a standard SAP Table which is used to store PM Object Location and Account Assignment data and is available within R/3 SAP systems depending on the version and release level.
The ILOA table consists of various fields, each holding specific information or linking keys about PM Object Location and Account Assignment data available in SAP. These include ILOAN (Location and account assignment for technical object), TPLNR (Functional Location), ABCKZ (ABC indicator for technical object), ABCKZI (Data origin for ABC indicator field).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ILOA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOAN | ||||
TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | INHER | ||||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
EQFNRI | Data origin for sort field | INH_EQFNRI | CHAR | 1 | INHER | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
SWERKI | Data origin for maintenance plant field | INH_SWERKI | CHAR | 1 | INHER | ||||
STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
STORTI | Data origin for location field | INH_STORTI | CHAR | 1 | INHER | ||||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
MSGRPI | Data origin for room number field | INH_MSGRPI | CHAR | 1 | INHER | ||||
BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
BEBERI | Data origin for plant section field | INH_BEBERI | CHAR | 1 | INHER | ||||
CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
PPSIDI | Data origin for PP work center field | INH_PPSIDI | CHAR | 1 | INHER | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSBERI | Data origin for business area field | INH_GSBERI | CHAR | 1 | INHER | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOKRSI | Data origin for controlling area field | INH_KOKRSI | CHAR | 1 | INHER | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
KOSTLI | Data origin for cost center field | INH_KOSTLI | CHAR | 1 | INHER | ||||
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
PROIDI | Data origin for WBS element field | INH_PROIDI | CHAR | 1 | INHER | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUKRSI | Data origin for company code field | INH_BUKRSI | CHAR | 1 | INHER | ||||
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLNRI | Data origin for asset main no./sub-no. fields | INH_ANLNRI | CHAR | 1 | INHER | ||||
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
ANLUNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
DAUFNI | Data origin of standing order number field | INH_DAUFNI | CHAR | 1 | INHER | ||||
AUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDE | |
AUFNRI | Data origin for settlement order field | INH_AUFNRI | CHAR | 1 | INHER | ||||
TPLNRI | Data origin for functional location field | INH_TPLNRI | CHAR | 1 | INHER | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VKORGI | Data origin for sales organization field | INH_VKORGI | CHAR | 1 | INHER | ||||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
VTWEGI | Data origin of distribution channel field | INH_VTWEGI | CHAR | 1 | INHER | ||||
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
SPARTI | Data origin for division field | INH_SPARTI | CHAR | 1 | INHER | ||||
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
ADRNRI | Data origin for address field | INH_ADRNRI | CHAR | 1 | INHER | ||||
OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG |
Key field | Non-key field |
How do I retrieve data from SAP table ILOA using ABAP code
The following ABAP code Example will allow you to do a basic selection on ILOA to SELECT all data from the tableDATA: WA_ILOA TYPE ILOA.
SELECT SINGLE *
FROM ILOA
INTO CORRESPONDING FIELDS OF WA_ILOA
WHERE...
How to access SAP table ILOA
Within an ECC or HANA version of SAP you can also view further information about ILOA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects