1. Home
  2. Resources
  3. SAP Tables
  4. ILOA - PM Object Location and Account Assignment

SAP Table ILOA

PM Object Location and Account Assignment

ILOA (PM Object Location and Account Assignment) 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 ILOA to other SAP tables.

ILOA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
ABCKZI Data origin for ABC indicator field INH_ABCKZI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin for sort field INH_EQFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK T001W CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Location of maintenance object PMLOC T499S CHAR 10 0
STORTI Data origin for location field INH_STORTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin for room number field INH_MSGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER T357 CHAR 3 0
BEBERI Data origin for plant section field INH_BEBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID CRID NUMC 8 0
PPSIDI Data origin for PP work center field INH_PPSIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
GSBER Business Area GSBER TGSB CHAR 4 0
GSBERI Data origin for business area field INH_GSBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOKRSI Data origin for controlling area field INH_KOKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOSTLI Data origin for cost center field INH_KOSTLI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PROIDI Data origin for WBS element field INH_PROIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS T001 CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLNRI Data origin for asset main no./sub-no. fields INH_ANLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN AUFK CHAR 12 0
DAUFNI Data origin of standing order number field INH_DAUFNI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
AUFNR Settlement order ILOM_ORDST AUFK CHAR 12 0
AUFNRI Data origin for settlement order field INH_AUFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
TPLNRI Data origin for functional location field INH_TPLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VKORG Sales Organization VKORG TVKO CHAR 4 0
VKORGI Data origin for sales organization field INH_VKORGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
VTWEGI Data origin of distribution channel field INH_VTWEGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SPART Division SPART TVTA CHAR 2 0
SPARTI Data origin for division field INH_SPARTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0

ILOA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ILOA ABCKZ ILOA MANDT T370C ABC indicator for technical objects MANDT
ILOA ABCKZ ILOA ABCKZ T370C ABC indicator for technical objects ABCKZ
ILOA ADRNR ILOA MANDT ADRC Addresses (Business Address Services) CLIENT
ILOA ADRNR ILOA ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
ILOA ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
ILOA ADRNR * ADRC Addresses (Business Address Services) NATION
ILOA ANLNR ILOA ANLNR ANLH Main asset number ANLN1
ILOA ANLNR ILOA MANDT ANLH Main asset number MANDT
ILOA ANLNR ILOA BUKRS ANLH Main asset number BUKRS
ILOA ANLUN ILOA MANDT ANLA Asset Master Record Segment MANDT
ILOA ANLUN ILOA BUKRS ANLA Asset Master Record Segment BUKRS
ILOA ANLUN ILOA ANLNR ANLA Asset Master Record Segment ANLN1
ILOA ANLUN ILOA ANLUN ANLA Asset Master Record Segment ANLN2
ILOA AUFNR ILOA MANDT AUFK Order master data MANDT
ILOA AUFNR ILOA AUFNR AUFK Order master data AUFNR
ILOA BEBER ILOA MANDT T357 Plant Section MANDT
ILOA BEBER ILOA SWERK T357 Plant Section WERKS
ILOA BEBER ILOA BEBER T357 Plant Section BEBER
ILOA BUKRS ILOA MANDT T001 Company Codes MANDT
ILOA BUKRS ILOA BUKRS T001 Company Codes BUKRS
ILOA DAUFN ILOA MANDT AUFK Order master data MANDT
ILOA DAUFN ILOA DAUFN AUFK Order master data AUFNR
ILOA GSBER ILOA MANDT TGSB Business Areas MANDT
ILOA GSBER ILOA GSBER TGSB Business Areas GSBER
ILOA KOKRS ILOA KOKRS TKA01 Controlling Areas KOKRS
ILOA KOKRS ILOA MANDT TKA01 Controlling Areas MANDT
ILOA KOSTL ILOA KOSTL CSKS Cost Center Master Data KOSTL
ILOA KOSTL SYST DATUM CSKS Cost Center Master Data DATBI
ILOA KOSTL ILOA MANDT CSKS Cost Center Master Data MANDT
ILOA KOSTL ILOA KOKRS CSKS Cost Center Master Data KOKRS
ILOA MANDT ILOA MANDT T000 Clients MANDT
ILOA PPSID ILOA MANDT CRID CIM Resource - Entities MANDT
ILOA PPSID ILOA CR_OBJTY CRID CIM Resource - Entities OBJTY
ILOA PPSID ILOA PPSID CRID CIM Resource - Entities OBJID
ILOA PROID ILOA MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
ILOA PROID ILOA PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
ILOA SPART ILOA VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
ILOA SPART ILOA SPART TVTA Organizational Unit: Sales Area(s) SPART
ILOA SPART ILOA MANDT TVTA Organizational Unit: Sales Area(s) MANDT
ILOA SPART ILOA VKORG TVTA Organizational Unit: Sales Area(s) VKORG
ILOA STORT ILOA MANDT T499S Location MANDT
ILOA STORT ILOA SWERK T499S Location WERKS
ILOA STORT ILOA STORT T499S Location STAND
ILOA SWERK ILOA MANDT T001W Plants/Branches MANDT
ILOA SWERK ILOA SWERK T001W Plants/Branches WERKS
ILOA TPLNR ILOA MANDT IFLOT Functional Location (Table) MANDT
ILOA TPLNR ILOA TPLNR IFLOT Functional Location (Table) TPLNR
ILOA VKBUR ILOA VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
ILOA VKBUR ILOA VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
ILOA VKBUR ILOA SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
ILOA VKBUR ILOA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
ILOA VKBUR ILOA MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
ILOA VKGRP ILOA MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
ILOA VKGRP ILOA VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
ILOA VKGRP ILOA VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
ILOA VKORG ILOA VKORG TVKO Organizational Unit: Sales Organizations VKORG
ILOA VKORG ILOA MANDT TVKO Organizational Unit: Sales Organizations MANDT
ILOA VTWEG ILOA MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
ILOA VTWEG ILOA VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
ILOA VTWEG ILOA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG