C_TechnicalObjectFlatVH

Technical Object | view: CTECHOBJFLATVH | Extraction: Not supported | Component: Plant Maintenance
Tables used: JSTO, JEST, T370C, T370C_T, TGSB, TGSBT, T001, TKA02, TKA01, CSKS, CSKT, TSPA, TSPAT, T370U, EQUI, T370T, EQKT, EQUZ, T370F_T, IFLOS, IFLOT, T370S, T370F, IFLOTX, T499S, ILOA, T001W, T357, CRTX, T000, CRHD, ITOBCUST, IFLOUSR, T024I
Column Name Description
TechnicalObject FK Technical Object
TechObjIsEquipOrFuncnlLoc Technical Object Type
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
MainWorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
Column Name Description Domain name
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
FunctionalLocationLabelName Functional Location Label ILOM_STRNO
TechnicalObjectDescription Technical Object Description
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
ABCIndicatorDesc Description of ABC Indicator of Technical Object TEXT20
BusinessAreaName Business Area Description
CompanyCodeName Name of Company Code or Company TEXT25
ControllingAreaName Controlling Area Name TEXT25
CostCenterDescription Description of Cost Center
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
MainWorkCenter Main work center for maintenance tasks
MainWorkCenterText Work Center Text
MaintenancePlantName Plant Name TEXT30
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
MaintenancePlannerGroupName Name of the Maintenance Planner Group TEXT18
PlantSectionPersonRespName Group of Employees Responsible for Company Area
AssetRoom Room CHAR8
MaintObjectFreeDefinedAttrib Sort Field CHAR30
TechnicalObjectCategoryDesc Equipment category description TEXT30
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
DivisionName Division Description TEXT20
LocationName Location Name TEXT40
TechObjIsEquipOrFuncnlLocDesc Description of Technical Object Type
TechObjInstallationLocation Installation Location of Technical Object CHAR255
HierarchyNodeLevel null
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_TECHNICALOBJECTFLATVH.ABCINDICATOR == T370C.ABCKZ
  • C_TECHNICALOBJECTFLATVH.MANDT == T370C.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANT == T499S.WERKS
  • C_TECHNICALOBJECTFLATVH.MANDT == T499S.MANDT
  • C_TECHNICALOBJECTFLATVH.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • C_TECHNICALOBJECTFLATVH.AUTHORIZATIONGROUP == T370B.BEGRU
  • C_TECHNICALOBJECTFLATVH.MANDT == T370B.MANDT
Business Area
  • Business Area
  • Client
  • C_TECHNICALOBJECTFLATVH.BUSINESSAREA == TGSB.GSBER
  • C_TECHNICALOBJECTFLATVH.MANDT == TGSB.MANDT
Catalog Profile
  • Catalog Profile
  • Client
  • C_TECHNICALOBJECTFLATVH.CATALOGPROFILE == T352B.RBNR
  • C_TECHNICALOBJECTFLATVH.MANDT == T352B.MANDT
Company Code
  • Company Code
  • Client
  • C_TECHNICALOBJECTFLATVH.COMPANYCODE == T001.BUKRS
  • C_TECHNICALOBJECTFLATVH.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_TECHNICALOBJECTFLATVH.CONTROLLINGAREA == TKA01.KOKRS
  • C_TECHNICALOBJECTFLATVH.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • C_TECHNICALOBJECTFLATVH.CONTROLLINGAREA == CSKS.KOKRS
  • C_TECHNICALOBJECTFLATVH.[column in domain "DATBI"] == CSKS.DATBI
  • C_TECHNICALOBJECTFLATVH.COSTCENTER == CSKS.KOSTL
  • C_TECHNICALOBJECTFLATVH.MANDT == CSKS.MANDT
Currency Key
  • Currency Key
  • Client
  • C_TECHNICALOBJECTFLATVH.CURRENCY == TCURC.WAERS
  • C_TECHNICALOBJECTFLATVH.MANDT == TCURC.MANDT
Division
  • Division
  • ?
  • Client
  • ?
  • C_TECHNICALOBJECTFLATVH.DIVISION == TVTA.SPART
  • C_TECHNICALOBJECTFLATVH.[column in domain "VTWEG"] == TVTA.VTWEG
  • C_TECHNICALOBJECTFLATVH.MANDT == TVTA.MANDT
  • C_TECHNICALOBJECTFLATVH.[column in domain "VKORG"] == TVTA.VKORG
Equipment Number
  • Equipment Number
  • Technical Object
  • Equipment Number
  • Client
  • C_TECHNICALOBJECTFLATVH.EQUIPMENT == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.TECHNICALOBJECT == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.EQUIPMENTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.MANDT == EQUI.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANT == T001W.WERKS
  • C_TECHNICALOBJECTFLATVH.MANDT == T001W.MANDT
Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • Client
  • C_TECHNICALOBJECTFLATVH.MAINWORKCENTERTYPECODE == CRID.OBJTY
  • C_TECHNICALOBJECTFLATVH.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_TECHNICALOBJECTFLATVH.MANDT == CRID.MANDT
Plant
  • Plant
  • Client
  • C_TECHNICALOBJECTFLATVH.MAINWORKCENTERPLANT == T001W.WERKS
  • C_TECHNICALOBJECTFLATVH.MANDT == T001W.MANDT
Plant Section
  • Plant Section
  • Maintenance Plant
  • Client
  • C_TECHNICALOBJECTFLATVH.PLANTSECTION == T357.BEBER
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANT == T357.WERKS
  • C_TECHNICALOBJECTFLATVH.MANDT == T357.MANDT
Technical Object
  • Equipment Number
  • Technical Object
  • Equipment Number
  • Client
  • C_TECHNICALOBJECTFLATVH.EQUIPMENT == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.TECHNICALOBJECT == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.EQUIPMENTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHNICALOBJECTFLATVH.MANDT == EQUI.MANDT
Technical Object Category
  • Technical Object Category
  • Client
  • C_TECHNICALOBJECTFLATVH.TECHNICALOBJECTCATEGORY == T370T.EQTYP
  • C_TECHNICALOBJECTFLATVH.MANDT == T370T.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • C_TECHNICALOBJECTFLATVH.TECHNICALOBJECTTYPE == T370K.EQART
  • C_TECHNICALOBJECTFLATVH.MANDT == T370K.MANDT
Object ID of PP work center
  • Object ID of PP work center
  • Object types of the CIM resource
  • Client
  • C_TECHNICALOBJECTFLATVH.WORKCENTERINTERNALID == CRID.OBJID
  • C_TECHNICALOBJECTFLATVH.WORKCENTERTYPECODE == CRID.OBJTY
  • C_TECHNICALOBJECTFLATVH.MANDT == CRID.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • C_TECHNICALOBJECTFLATVH.PLANT == T024I.IWERK
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_TECHNICALOBJECTFLATVH.MANDT == T024I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_TECHNICALOBJECTFLATVH.PLANT == T399I.IWERK
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_TECHNICALOBJECTFLATVH.MANDT == T399I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_TECHNICALOBJECTFLATVH.PLANT == T399I.IWERK
  • C_TECHNICALOBJECTFLATVH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_TECHNICALOBJECTFLATVH.MANDT == T399I.MANDT