P_FunctionalLocationSearch

Functional Location Anchor View for CDS Search Model | view: PFLOCSEARCH | Extraction: Not supported | Component: Plant Maintenance
Tables used: IFLOT
Column Name Description
FunctionalLocation Functional Location
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Weight Unit (GrossWeightUnit):
GrossWeight Gross weight
Column Name Description
CreationDate Date on which the object was created
LastChangeDate Date on which the object was last changed
AcquisitionDate Acquisition date
OperationStartDate Start-up Date of the Technical Object
Column Name Description
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
ConstructionMonth Month of construction Show values
Column Name Description Domain name
CreatedByUser Name of User Who Created the Object USNAM
LastChangedByUser Name of the user who last changed the object USNAM
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
ManufacturerPartNmbr Manufacturer part number MAPAR
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
InventoryNumber Inventory number INVNR_ANLA
SizeOrDimensionText Size/dimension GROES
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations | to Other Relations ↓ Join Conditions
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.AUTHORIZATIONGROUP == T370B.BEGRU
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T370B.MANDT
Catalog Profile
  • Catalog Profile
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.CATALOGPROFILE == T352B.RBNR
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T352B.MANDT
Construction type material of the object
  • Construction type material of the object
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.CONSTRUCTIONMATERIAL == MARA.MATNR
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == MARA.MANDT
Currency Key
  • Currency Key
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.CURRENCY == TCURC.WAERS
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == TCURC.MANDT
Functional Location Structure Indicator
  • Functional Location Structure Indicator
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.FUNCLOCATIONSTRUCTURE == T370S.TPLKZ
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T370S.MANDT
Functional location category
  • Functional location category
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T370F.MANDT
Weight Unit
  • Weight Unit
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.GROSSWEIGHTUNIT == T006.MSEHI
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T006.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == ILOA.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.MANUFACTURERCOUNTRY == T005.LAND1
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T005.MANDT
Superior functional location
  • Superior functional location
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == IFLOT.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.TECHNICALOBJECTTYPE == T370K.EQART
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T370K.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.WORKCENTERINTERNALID == CRID.OBJID
  • P_FUNCTIONALLOCATIONSEARCH.WORKCENTERTYPECODE == CRID.OBJTY
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == CRID.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
  • P_FUNCTIONALLOCATIONSEARCH.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_FUNCTIONALLOCATIONSEARCH.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_FUNCTIONALLOCATIONSEARCH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_FUNCTIONALLOCATIONSEARCH.MANDT == T399I.MANDT