C_TechObjFlatVH

Value help for Technical Object details | view: CTECHOBJFLATVH1 | Extraction: Not supported | Component: Maintenance Notifications
Tables used: OBJKQMELAFIHAFKOQMIHJSTOJESTT370CT370C_TTGSBTGSBTBUT000T001TKA02TKA01CSKSCSKSCSKTTSPATSPATT370UEQUIT370TEQKTEQUZT370F_TIFLOSIFLOSIFLOTT370SIFLOTT370FIFLOTXT499SILOAAUFKT003OT003PT001WT357ADCPADR6ADRCADRPUSR21CRTXT000CRHDADR2ADR2ITOBCUSTIFLOUSRT024I
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
FunctionalLocationLabelName Functional Location Label ILOM_STRNO
TechnicalObjectDescription Technical Object Description
SuperiorTechnicalObject Technical Object
SuperiorObjIsEquipOrFuncnlLoc Technical Object Type
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
MaintenancePlanningPlantName Plant Name TEXT30
MaintenancePlannerGroupName Name of the Maintenance Planner Group TEXT18
PlantSectionPersonRespName Group of Employees Responsible for Company Area
AssetRoom Room CHAR8
MaintObjectFreeDefinedAttrib Sort Field
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
NumberOfOrders Number of Open Notifications DEC9
NmbrOfOpenMaintNotifications Number of Open Notifications DEC9
ConcatenatedActiveSystStsName Concatenated System Status
MainWorkCenterPlantName Plant Name TEXT30
SuperiorTechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
MaintObjectInternalID Object number J_OBJNR
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_TECHOBJFLATVH.ABCINDICATOR == T370C.ABCKZ
  • C_TECHOBJFLATVH.MANDT == T370C.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • C_TECHOBJFLATVH.MAINTENANCEPLANT == T499S.WERKS
  • C_TECHOBJFLATVH.MANDT == T499S.MANDT
  • C_TECHOBJFLATVH.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • C_TECHOBJFLATVH.AUTHORIZATIONGROUP == T370B.BEGRU
  • C_TECHOBJFLATVH.MANDT == T370B.MANDT
Business Area
  • Business Area
  • Client
  • C_TECHOBJFLATVH.BUSINESSAREA == TGSB.GSBER
  • C_TECHOBJFLATVH.MANDT == TGSB.MANDT
Catalog Profile
  • Client
  • Catalog Profile
  • C_TECHOBJFLATVH.MANDT == T352B.MANDT
  • C_TECHOBJFLATVH.CATALOGPROFILE == T352B.RBNR
Company Code
  • Client
  • Company Code
  • C_TECHOBJFLATVH.MANDT == T001.MANDT
  • C_TECHOBJFLATVH.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_TECHOBJFLATVH.MANDT == TKA01.MANDT
  • C_TECHOBJFLATVH.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • C_TECHOBJFLATVH.[column in domain "DATBI"] == CSKS.DATBI
  • C_TECHOBJFLATVH.MANDT == CSKS.MANDT
  • C_TECHOBJFLATVH.COSTCENTER == CSKS.KOSTL
  • C_TECHOBJFLATVH.CONTROLLINGAREA == CSKS.KOKRS
Currency Key
  • Client
  • Currency Key
  • C_TECHOBJFLATVH.MANDT == TCURC.MANDT
  • C_TECHOBJFLATVH.CURRENCY == TCURC.WAERS
Division
  • Division
  • ?
  • Client
  • ?
  • C_TECHOBJFLATVH.DIVISION == TVTA.SPART
  • C_TECHOBJFLATVH.[column in domain "VKORG"] == TVTA.VKORG
  • C_TECHOBJFLATVH.MANDT == TVTA.MANDT
  • C_TECHOBJFLATVH.[column in domain "VTWEG"] == TVTA.VTWEG
Equipment Number
  • Client
  • Equipment Number
  • Equipment Number
  • Technical Object
  • C_TECHOBJFLATVH.MANDT == EQUI.MANDT
  • C_TECHOBJFLATVH.EQUIPMENT == EQUI.EQUNR
  • C_TECHOBJFLATVH.EQUIPMENTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHOBJFLATVH.TECHNICALOBJECT == EQUI.EQUNR
Maintenance Plant
  • Maintenance Plant
  • Client
  • C_TECHOBJFLATVH.MAINTENANCEPLANT == T001W.WERKS
  • C_TECHOBJFLATVH.MANDT == T001W.MANDT
Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • C_TECHOBJFLATVH.MANDT == CRID.MANDT
  • C_TECHOBJFLATVH.MAINWORKCENTERTYPECODE == CRID.OBJTY
  • C_TECHOBJFLATVH.MAINWORKCENTERINTERNALID == CRID.OBJID
Plant
  • Client
  • Plant
  • C_TECHOBJFLATVH.MANDT == T001W.MANDT
  • C_TECHOBJFLATVH.MAINWORKCENTERPLANT == T001W.WERKS
Plant Section
  • Maintenance Plant
  • Client
  • Plant Section
  • C_TECHOBJFLATVH.MAINTENANCEPLANT == T357.WERKS
  • C_TECHOBJFLATVH.MANDT == T357.MANDT
  • C_TECHOBJFLATVH.PLANTSECTION == T357.BEBER
Technical Object
  • Client
  • Equipment Number
  • Equipment Number
  • Technical Object
  • C_TECHOBJFLATVH.MANDT == EQUI.MANDT
  • C_TECHOBJFLATVH.EQUIPMENT == EQUI.EQUNR
  • C_TECHOBJFLATVH.EQUIPMENTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHOBJFLATVH.TECHNICALOBJECT == EQUI.EQUNR
Technical Object Category
  • Client
  • Technical Object Category
  • C_TECHOBJFLATVH.MANDT == T370T.MANDT
  • C_TECHOBJFLATVH.TECHNICALOBJECTCATEGORY == T370T.EQTYP
Type of Technical Object
  • Type of Technical Object
  • Client
  • C_TECHOBJFLATVH.TECHNICALOBJECTTYPE == T370K.EQART
  • C_TECHOBJFLATVH.MANDT == T370K.MANDT
Object ID of PP work center
  • Object types of the CIM resource
  • Client
  • Object ID of PP work center
  • C_TECHOBJFLATVH.WORKCENTERTYPECODE == CRID.OBJTY
  • C_TECHOBJFLATVH.MANDT == CRID.MANDT
  • C_TECHOBJFLATVH.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • C_TECHOBJFLATVH.PLANT == T024I.IWERK
  • C_TECHOBJFLATVH.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_TECHOBJFLATVH.MANDT == T024I.MANDT
  • C_TECHOBJFLATVH.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance planning plant
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_TECHOBJFLATVH.PLANT == T399I.IWERK
  • C_TECHOBJFLATVH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_TECHOBJFLATVH.MANDT == T399I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_TECHOBJFLATVH.PLANT == T399I.IWERK
  • C_TECHOBJFLATVH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_TECHOBJFLATVH.MANDT == T399I.MANDT