SAP table ILOA (PM Object Location and Account Assignment)

SAP table ILOA has 2 primary key fields being MANDT,ILOAN.

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

ILOA foreign key relationships

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