I_UtilsTechObjLocationAddr

Technical Object Location Address | view: IETECHOBJLOCADDR | ATTR | Extraction: Not supported | Component: Device Management
Tables used: ADCP, ADRC, IFLOT, ILOA
Column Name Description
FunctionalLocation Functional Location
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CountyCode County code for county CNTY_CODE
Master Data Relations | to Other Relations ↓ Join Conditions
Address Number
  • ?
  • ?
  • Client
  • Address Number
  • I_UTILSTECHOBJLOCATIONADDR.[column in domain "AD_NATION"] == ADRC.NATION
  • I_UTILSTECHOBJLOCATIONADDR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == ADRC.CLIENT
  • I_UTILSTECHOBJLOCATIONADDR.ADDRESSID == ADRC.ADDRNUMBER
Location of maintenance object
  • Client
  • Location of maintenance object
  • Location of maintenance object
  • Maintenance Plant
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T499S.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • I_UTILSTECHOBJLOCATIONADDR.ASSETLOCATION == T499S.STAND
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANT == T499S.WERKS
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T370B.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.AUTHORIZATIONGROUP == T370B.BEGRU
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • I_UTILSTECHOBJLOCATIONADDR.CITYNUMBER == ADRCITY.CITY_CODE
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == ADRCITY.CLIENT
  • I_UTILSTECHOBJLOCATIONADDR.COUNTRY == ADRCITY.COUNTRY
Controlling Area
  • Client
  • Controlling Area
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == TKA01.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • Controlling Area
  • I_UTILSTECHOBJLOCATIONADDR.[column in domain "DATBI"] == CSKS.DATBI
  • I_UTILSTECHOBJLOCATIONADDR.COSTCENTER == CSKS.KOSTL
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == CSKS.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.CONTROLLINGAREA == CSKS.KOKRS
Country key
  • Client
  • Country/Region Key
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T005.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.COUNTRY == T005.LAND1
Location of maintenance object
  • Client
  • Location of maintenance object
  • Location of maintenance object
  • Maintenance Plant
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T499S.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • I_UTILSTECHOBJLOCATIONADDR.ASSETLOCATION == T499S.STAND
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANT == T499S.WERKS
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T001W.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_UTILSTECHOBJLOCATIONADDR.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == ILOA.MANDT
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_UTILSTECHOBJLOCATIONADDR.REGION == T005S.BLAND
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T005S.MANDT
  • I_UTILSTECHOBJLOCATIONADDR.COUNTRY == T005S.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_UTILSTECHOBJLOCATIONADDR.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_UTILSTECHOBJLOCATIONADDR.MANDT == T399I.MANDT