P_EquipmentFuncnlLocUnion

Equipment Functional Location Union | view: PEQUIFLOCUNION | Extraction: Not supported | Component: Equipment
Tables used: EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, ITOBCUST, IFLOUSR
Column Name Description
TechnicalObject FK Technical Object
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Unit of weight (GrossWeightUnit):
GrossWeight Weight of object
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
AcquisitionDate Acquisition date
OperationStartDate Start-up Date of the Technical Object
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
ConstructionMonth Month of construction Show values
TechnicalObjectHasLongText Long Text Indicator Show values
SuperiorObjIsEquipOrFuncnlLoc Technical Object Type Show values
Column Name Description Domain name
FunctionalLocation Functional Location TPLNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
MaintObjectInternalID Object number J_OBJNR
TechnicalObjectSortCode Technical identification number TIDNR
ManufacturerPartNmbr Manufacturer part number MAPAR
SizeOrDimensionText Size/dimension GROES
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
InventoryNumber Inventory number INVNR_ANLA
FuncLocStrucIdentifyingLevel Number of Identifying Level ILOM_LEVEL_KZ
FuncLocStruc2ndIdentifyingLvl Number of 2nd Identifying Level ILOM_LEVEL_KZ
FuncLocationStructure Functional Location Structure Indicator TPLKZ
SerialNumber Serial Number GERNR
TechnicalObjectDescription Technical Object Description TEXT40
SuperiorTechnicalObject Technical Object EAMS_TEC_OBJ
SuperiorTechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
SuperiorTechnicalObjectName Technical Object Description TEXT40
Master Data Relations | to Other Relations ↓ Join Conditions
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T370B.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.AUTHORIZATIONGROUP == T370B.BEGRU
Catalog Profile
  • Client
  • Catalog Profile
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T352B.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.CATALOGPROFILE == T352B.RBNR
Construction type material of the object
  • Client
  • Construction type material of the object
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == MARA.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.CONSTRUCTIONMATERIAL == MARA.MATNR
Currency Key
  • Client
  • Currency Key
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TCURC.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.CURRENCY == TCURC.WAERS
Distribution channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TVKOV.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SALESORGANIZATION == TVKOV.VKORG
  • P_EQUIPMENTFUNCNLLOCUNION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Equipment Number
  • Client
  • Equipment Number
  • Technical Object
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == EQUI.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.EQUIPMENT == EQUI.EQUNR
  • P_EQUIPMENTFUNCNLLOCUNION.TECHNICALOBJECT == EQUI.EQUNR
Unit of weight
  • Client
  • Unit of weight
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T006.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.GROSSWEIGHTUNIT == T006.MSEHI
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == ILOA.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T005.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.MANUFACTURERCOUNTRY == T005.LAND1
Material Number
  • Client
  • Material Number
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == MARA.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.MATERIAL == MARA.MATNR
Division
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TVTA.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SALESORGANIZATION == TVTA.VKORG
  • P_EQUIPMENTFUNCNLLOCUNION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_EQUIPMENTFUNCNLLOCUNION.ORGANIZATIONDIVISION == TVTA.SPART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TVBVK.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SALESOFFICE == TVBVK.VKBUR
  • P_EQUIPMENTFUNCNLLOCUNION.SALESGROUP == TVBVK.VKGRP
Sales organization
  • Client
  • Sales Organization
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TVKO.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SALESORGANIZATION == TVKO.VKORG
Functional Location
  • Client
  • Functional Location
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == IFLOT.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • P_EQUIPMENTFUNCNLLOCUNION.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == EQUI.MANDT
Technical Object
  • Client
  • Equipment Number
  • Technical Object
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == EQUI.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.EQUIPMENT == EQUI.EQUNR
  • P_EQUIPMENTFUNCNLLOCUNION.TECHNICALOBJECT == EQUI.EQUNR
Technical Object Category
  • Client
  • Technical Object Category
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T370T.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.TECHNICALOBJECTCATEGORY == T370T.EQTYP
Type of Technical Object
  • Client
  • Type of Technical Object
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T370K.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.TECHNICALOBJECTTYPE == T370K.EQART
Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == CRID.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.WORKCENTERTYPECODE == CRID.OBJTY
  • P_EQUIPMENTFUNCNLLOCUNION.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T024I.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_EQUIPMENTFUNCNLLOCUNION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance planning plant
  • Client
  • Maintenance Planning Plant
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == T399I.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.MAINTENANCEPLANNINGPLANT == T399I.IWERK
Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • Sales office
  • Division
  • P_EQUIPMENTFUNCNLLOCUNION.MANDT == TVKBZ.MANDT
  • P_EQUIPMENTFUNCNLLOCUNION.SALESORGANIZATION == TVKBZ.VKORG
  • P_EQUIPMENTFUNCNLLOCUNION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_EQUIPMENTFUNCNLLOCUNION.SALESOFFICE == TVKBZ.VKBUR
  • P_EQUIPMENTFUNCNLLOCUNION.ORGANIZATIONDIVISION == TVKBZ.SPART