ILOA

PM Object Location and Account Assignment | #masterdata | Component: Functional Locations

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (23)
Other (2)
🔗 Relations (22)

Column Name	Description
MANDT FK	Client
ILOAN	Location and account assignment for technical object

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
ABCKZI	Data origin for ABC indicator field	Show values
EQFNRI	Data origin for sort field	Show values
SWERKI	Data origin for maintenance plant field	Show values
STORTI	Data origin for location field	Show values
MSGRPI	Data origin for room number field	Show values
BEBERI	Data origin for plant section field	Show values
CR_OBJTY	Object types of the CIM resource	Show values
PPSIDI	Data origin for PP work center field	Show values
GSBERI	Data origin for business area field	Show values
KOKRSI	Data origin for controlling area field	Show values
KOSTLI	Data origin for cost center field	Show values
PROIDI	Data origin for WBS element field	Show values
BUKRSI	Data origin for company code field	Show values
ANLNRI	Data origin for asset main no./sub-no. fields	Show values
ANLUNI	Data origin indicator	Show values
DAUFNI	Data origin of standing order number field	Show values
AUFNRI	Data origin for settlement order field	Show values
TPLNRI	Data origin for functional location field	Show values
VKORGI	Data origin for sales organization field	Show values
VTWEGI	Data origin of distribution channel field	Show values
SPARTI	Data origin for division field	Show values
ADRNRI	Data origin for address field	Show values
OWNER	Object reference indicator	Show values

Column Name	Description	Domain name
EQFNR	Sort Field	CHAR30
MSGRP	Room	CHAR8

Master Data Relations	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`ILOA.ABCKZ == T370C.ABCKZ` `ILOA.MANDT == T370C.MANDT`
Address Number Address Number ? ?	`ILOA.MANDT == ADRC.CLIENT` `ILOA.ADRNR == ADRC.ADDRNUMBER` `ILOA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `ILOA.[column in domain "AD_NATION"] == ADRC.NATION`
Asset Subnumber Asset Subnumber Company Code Main Asset Number	`ILOA.MANDT == ANLA.MANDT` `ILOA.ANLUN == ANLA.ANLN2` `ILOA.BUKRS == ANLA.BUKRS` `ILOA.ANLNR == ANLA.ANLN1`
Settlement order Settlement order Client	`ILOA.AUFNR == AUFK.AUFNR` `ILOA.MANDT == AUFK.MANDT`
Plant Section Plant Section Client Maintenance Plant	`ILOA.BEBER == T357.BEBER` `ILOA.MANDT == T357.MANDT` `ILOA.SWERK == T357.WERKS`
Company Code	`ILOA.MANDT == T001.MANDT` `ILOA.BUKRS == T001.BUKRS`
Standing order number Standing order number Client	`ILOA.DAUFN == AUFK.AUFNR` `ILOA.MANDT == AUFK.MANDT`
Business Area	`ILOA.MANDT == TGSB.MANDT` `ILOA.GSBER == TGSB.GSBER`
Controlling Area	`ILOA.MANDT == TKA01.MANDT` `ILOA.KOKRS == TKA01.KOKRS`
Cost Center ? Cost Center Controlling Area	`ILOA.MANDT == CSKS.MANDT` `ILOA.[column in domain "DATBI"] == CSKS.DATBI` `ILOA.KOSTL == CSKS.KOSTL` `ILOA.KOKRS == CSKS.KOKRS`
Client	`ILOA.MANDT == T000.MANDT`
Object ID of PP work center Object ID of PP work center Object types of the CIM resource Client	`ILOA.PPSID == CRID.OBJID` `ILOA.CR_OBJTY == CRID.OBJTY` `ILOA.MANDT == CRID.MANDT`
Division Sales Organization Distribution Channel Division Client	`ILOA.VKORG == TVTA.VKORG` `ILOA.VTWEG == TVTA.VTWEG` `ILOA.SPART == TVTA.SPART` `ILOA.MANDT == TVTA.MANDT`
Location of maintenance object Location of maintenance object Client Maintenance Plant	`ILOA.STORT == T499S.STAND` `ILOA.MANDT == T499S.MANDT` `ILOA.SWERK == T499S.WERKS`
Maintenance Plant	`ILOA.MANDT == T001W.MANDT` `ILOA.SWERK == T001W.WERKS`
Functional Location	`ILOA.MANDT == IFLOT.MANDT` `ILOA.TPLNR == IFLOT.TPLNR`
Sales group Sales group Sales office	`ILOA.MANDT == TVBVK.MANDT` `ILOA.VKGRP == TVBVK.VKGRP` `ILOA.VKBUR == TVBVK.VKBUR`
Sales organization	`ILOA.MANDT == TVKO.MANDT` `ILOA.VKORG == TVKO.VKORG`
Distribution channel Sales Organization Client Distribution Channel	`ILOA.VKORG == TVKOV.VKORG` `ILOA.MANDT == TVKOV.MANDT` `ILOA.VTWEG == TVKOV.VTWEG`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Sales Organization Client Distribution Channel Division Sales office	`ILOA.VKORG == TVKBZ.VKORG` `ILOA.MANDT == TVKBZ.MANDT` `ILOA.VTWEG == TVKBZ.VTWEG` `ILOA.SPART == TVKBZ.SPART` `ILOA.VKBUR == TVKBZ.VKBUR`