0FUNCT_LOC2_ATTR

Technical Location with Alternative IDs | #ATTR | Extraction method: V | No Delta | Component: Plant Maintenance Master Data
Tables used: ILOA, IFLOS, IFLOT → show details
Column Name Description
TPLNR Functional Location
FLTYP FK Functional location category
SUBMT FK Construction type material of the object
IWERK FK Maintenance Planning Plant
INGRP FK Planner Group for Customer Service and Plant Maintenance
ABCKZ FK ABC Indicator for Technical Object
SWERK FK Maintenance Plant
STORT FK Location of maintenance object
MSGRP Room
BEBER FK Plant Section
ADRNR FK Address Number
KOKRS FK Controlling Area
KOSTL FK Cost Center
BUKRS FK Company Code
ANLNR FK Main Asset Number
ALKEY FK Labeling system for functional locations Show values
STRNO Functional Location Label
DATAB Start-up Date of the Technical Object
ERDAT Date on which the object was created
AEDAT Date on which the object was last changed
VERSN Version of functional location label
Column Name Description
Column Name Description
Column Name Description
DATAB Start-up Date of the Technical Object
ERDAT Date on which the object was created
AEDAT Date on which the object was last changed
ERDAT_S Date on which the object was created
Column Name Description
ACTVS Active version Show values
PRKEY Primary labeling system Show values
REUSE Indicator "Reusable" Show values
Column Name Description Domain name
TPLKZ Functional Location Structure Indicator TPLKZ
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • 0FUNCT_LOC2_ATTR.MANDT == T370C.MANDT
  • 0FUNCT_LOC2_ATTR.ABCKZ == T370C.ABCKZ
Address Number
  • Address Number
  • Client
  • 0FUNCT_LOC2_ATTR.ADRNR == ADRC.ADDRNUMBER
  • 0FUNCT_LOC2_ATTR.MANDT == ADRC.CLIENT
Labeling system for functional locations
  • Labeling system for functional locations
  • Client
  • 0FUNCT_LOC2_ATTR.ALKEY == IFLOALT.ALKEY
  • 0FUNCT_LOC2_ATTR.MANDT == IFLOALT.MANDT
Plant Section
  • Maintenance Plant
  • Client
  • Plant Section
  • 0FUNCT_LOC2_ATTR.SWERK == T357.WERKS
  • 0FUNCT_LOC2_ATTR.MANDT == T357.MANDT
  • 0FUNCT_LOC2_ATTR.BEBER == T357.BEBER
Company Code
  • Company Code
  • Client
  • 0FUNCT_LOC2_ATTR.BUKRS == T001.BUKRS
  • 0FUNCT_LOC2_ATTR.MANDT == T001.MANDT
Functional location category
  • Functional location category
  • Client
  • 0FUNCT_LOC2_ATTR.FLTYP == T370F.FLTYP
  • 0FUNCT_LOC2_ATTR.MANDT == T370F.MANDT
Controlling Area
  • Controlling Area
  • Client
  • 0FUNCT_LOC2_ATTR.KOKRS == TKA01.KOKRS
  • 0FUNCT_LOC2_ATTR.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • Client
  • 0FUNCT_LOC2_ATTR.KOKRS == CSKS.KOKRS
  • 0FUNCT_LOC2_ATTR.KOSTL == CSKS.KOSTL
  • 0FUNCT_LOC2_ATTR.MANDT == CSKS.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • 0FUNCT_LOC2_ATTR.SWERK == T499S.WERKS
  • 0FUNCT_LOC2_ATTR.MANDT == T499S.MANDT
  • 0FUNCT_LOC2_ATTR.STORT == T499S.STAND
Construction type material of the object
  • Client
  • Construction type material of the object
  • 0FUNCT_LOC2_ATTR.MANDT == MARA.MANDT
  • 0FUNCT_LOC2_ATTR.SUBMT == MARA.MATNR
Maintenance Plant
  • Maintenance Plant
  • Client
  • 0FUNCT_LOC2_ATTR.SWERK == T001W.WERKS
  • 0FUNCT_LOC2_ATTR.MANDT == T001W.MANDT
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
  • 0FUNCT_LOC2_ATTR.INGRP == T024I.INGRP
  • 0FUNCT_LOC2_ATTR.IWERK == T024I.IWERK
  • 0FUNCT_LOC2_ATTR.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • 0FUNCT_LOC2_ATTR.MANDT == T399I.MANDT
  • 0FUNCT_LOC2_ATTR.IWERK == T399I.IWERK