P_EquiTimeSegFuncLocationUnion

Union view of Equipment Time segment and Functional location | view: PEQTSEGFLOCU | Extraction: Not supported | Component: Maintenance Notifications
Tables used: EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, T499S, ILOA, ITOBCUST, IFLOUSR
Column Name Description
TechnicalObject FK Technical Object
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
ValidityEndDate Valid To Date
EquipUsagePeriodSequenceNumber Consecutive numbering of EquipUsagePeriods on same day
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Unit of weight (GrossWeightUnit):
GrossWeight Weight of object
Column Name Description
ValidityEndDate Valid To Date
ValidityEndTime Equipment usage period time stamp
ValidityStartDate Valid-From Date
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
LocationName Location Name TEXT40
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
Location of maintenance object
  • Location of maintenance object
  • ?
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.ASSETLOCATION == T499S.STAND
  • P_EQUITIMESEGFUNCLOCATIONUNION.[column in domain "WERKS_D"] == T499S.WERKS
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T499S.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.AUTHORIZATIONGROUP == T370B.BEGRU
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T370B.MANDT
Catalog Profile
  • Catalog Profile
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.CATALOGPROFILE == T352B.RBNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T352B.MANDT
Construction type material of the object
  • Construction type material of the object
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.CONSTRUCTIONMATERIAL == MARA.MATNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == MARA.MANDT
Currency Key
  • Currency Key
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.CURRENCY == TCURC.WAERS
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TCURC.MANDT
Distribution channel
  • Sales Organization
  • Client
  • Distribution Channel
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESORGANIZATION == TVKOV.VKORG
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TVKOV.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Equipment Number
  • Technical Object
  • Equipment Number
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.TECHNICALOBJECT == EQUI.EQUNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.EQUIPMENT == EQUI.EQUNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == EQUI.MANDT
Unit of weight
  • Unit of weight
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.GROSSWEIGHTUNIT == T006.MSEHI
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T006.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == ILOA.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANUFACTURERCOUNTRY == T005.LAND1
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T005.MANDT
Division
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • P_EQUITIMESEGFUNCLOCATIONUNION.ORGANIZATIONDIVISION == TVTA.SPART
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESORGANIZATION == TVTA.VKORG
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TVTA.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales group
  • Client
  • Sales office
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESGROUP == TVBVK.VKGRP
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TVBVK.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESOFFICE == TVBVK.VKBUR
Sales organization
  • Sales Organization
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESORGANIZATION == TVKO.VKORG
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TVKO.MANDT
Functional Location
  • Client
  • Functional Location
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == IFLOT.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == EQUI.MANDT
Technical Object
  • Technical Object
  • Equipment Number
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.TECHNICALOBJECT == EQUI.EQUNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.EQUIPMENT == EQUI.EQUNR
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == EQUI.MANDT
Technical Object Category
  • Technical Object Category
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.TECHNICALOBJECTCATEGORY == T370T.EQTYP
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T370T.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.TECHNICALOBJECTTYPE == T370K.EQART
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T370K.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • P_EQUITIMESEGFUNCLOCATIONUNION.WORKCENTERINTERNALID == CRID.OBJID
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == CRID.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.WORKCENTERTYPECODE == CRID.OBJTY
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_EQUITIMESEGFUNCLOCATIONUNION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_EQUITIMESEGFUNCLOCATIONUNION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T024I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Client
  • P_EQUITIMESEGFUNCLOCATIONUNION.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == T399I.MANDT
Sales office
  • Division
  • Sales Organization
  • Client
  • Sales office
  • Distribution Channel
  • P_EQUITIMESEGFUNCLOCATIONUNION.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESORGANIZATION == TVKBZ.VKORG
  • P_EQUITIMESEGFUNCLOCATIONUNION.MANDT == TVKBZ.MANDT
  • P_EQUITIMESEGFUNCLOCATIONUNION.SALESOFFICE == TVKBZ.VKBUR
  • P_EQUITIMESEGFUNCLOCATIONUNION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG