ILOA_VS

Location & Account Assignment for PM Object (Version Table) | #masterdata | Component: Functional Locations
Column Name Description
MANDT FK Client
VSNMR Number or description of a version
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_VS.ABCKZ == T370C.ABCKZ
  • ILOA_VS.MANDT == T370C.MANDT
Address Number
  • Address Number
  • ?
  • ?
  • ILOA_VS.MANDT == ADRC.CLIENT
  • ILOA_VS.ADRNR == ADRC.ADDRNUMBER
  • ILOA_VS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ILOA_VS.[column in domain "AD_NATION"] == ADRC.NATION
Asset Subnumber
  • Asset Subnumber
  • Company Code
  • Main Asset Number
  • ILOA_VS.MANDT == ANLA.MANDT
  • ILOA_VS.ANLUN == ANLA.ANLN2
  • ILOA_VS.BUKRS == ANLA.BUKRS
  • ILOA_VS.ANLNR == ANLA.ANLN1
Settlement order
  • Settlement order
  • Client
  • ILOA_VS.AUFNR == AUFK.AUFNR
  • ILOA_VS.MANDT == AUFK.MANDT
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • ILOA_VS.BEBER == T357.BEBER
  • ILOA_VS.MANDT == T357.MANDT
  • ILOA_VS.SWERK == T357.WERKS
Company Code
  • ILOA_VS.MANDT == T001.MANDT
  • ILOA_VS.BUKRS == T001.BUKRS
Standing order number
  • Standing order number
  • Client
  • ILOA_VS.DAUFN == AUFK.AUFNR
  • ILOA_VS.MANDT == AUFK.MANDT
Business Area
  • ILOA_VS.MANDT == TGSB.MANDT
  • ILOA_VS.GSBER == TGSB.GSBER
Controlling Area
  • ILOA_VS.MANDT == TKA01.MANDT
  • ILOA_VS.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • ILOA_VS.MANDT == CSKS.MANDT
  • ILOA_VS.[column in domain "DATBI"] == CSKS.DATBI
  • ILOA_VS.KOSTL == CSKS.KOSTL
  • ILOA_VS.KOKRS == CSKS.KOKRS
Client ILOA_VS.MANDT == T000.MANDT
Object ID of PP work center
  • Object ID of PP work center
  • Object types of the CIM resource
  • Client
  • ILOA_VS.PPSID == CRID.OBJID
  • ILOA_VS.CR_OBJTY == CRID.OBJTY
  • ILOA_VS.MANDT == CRID.MANDT
Division notif. header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • ILOA_VS.VKORG == TVTA.VKORG
  • ILOA_VS.VTWEG == TVTA.VTWEG
  • ILOA_VS.SPART == TVTA.SPART
  • ILOA_VS.MANDT == TVTA.MANDT
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • ILOA_VS.STORT == T499S.STAND
  • ILOA_VS.MANDT == T499S.MANDT
  • ILOA_VS.SWERK == T499S.WERKS
Maintenance Plant
  • ILOA_VS.MANDT == T001W.MANDT
  • ILOA_VS.SWERK == T001W.WERKS
Functional Location
  • ILOA_VS.MANDT == IFLOT.MANDT
  • ILOA_VS.TPLNR == IFLOT.TPLNR
Sales group
  • Sales group
  • Sales office
  • ILOA_VS.MANDT == TVBVK.MANDT
  • ILOA_VS.VKGRP == TVBVK.VKGRP
  • ILOA_VS.VKBUR == TVBVK.VKBUR
Sales organization notif. header
  • ILOA_VS.MANDT == TVKO.MANDT
  • ILOA_VS.VKORG == TVKO.VKORG
Distribution channel notif. header
  • Sales Organization
  • Client
  • Distribution Channel
  • ILOA_VS.VKORG == TVKOV.VKORG
  • ILOA_VS.MANDT == TVKOV.MANDT
  • ILOA_VS.VTWEG == TVKOV.VTWEG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • ILOA_VS.VKORG == TVKBZ.VKORG
  • ILOA_VS.MANDT == TVKBZ.MANDT
  • ILOA_VS.VTWEG == TVKBZ.VTWEG
  • ILOA_VS.SPART == TVKBZ.SPART
  • ILOA_VS.VKBUR == TVKBZ.VKBUR