C_TechnicalObjectHierVH

Technical Object Hierarchical Value Help | view: CTECHOBJHIERVH | 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, T370S, IFLOT, T370F, IFLOTX, T499S, ILOA, T001W, T357, CRTX, T000, T370K, T370K_T, CRHD, ITOBCUST, IFLOUSR, T024I

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (30)
🔗 Relations (18)

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

Column Name	Description
CreationDate	Date on which the record was created
LastChangeDate	Last Changed On

Column Name	Description
TechObjIsEquipOrFuncnlLoc	Technical Object Type	Show values

Column Name	Description	Domain name
TechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
TechnicalObjectDescription	Technical Object Description	TEXT40
FunctionalLocation	Functional Location	TPLNR
ABCIndicatorDesc	Description of ABC Indicator of Technical Object	TEXT20
BusinessAreaName	Business Area Description	TEXT30
CompanyCodeName	Name of Company Code or Company	TEXT25
ControllingAreaName	Controlling Area Name	TEXT25
CostCenterDescription	Description of Cost Center	TEXT40
WorkCenter	Work Center	ARBPL
WorkCenterText	Work Center Text	TEXT40
MainWorkCenter	Main work center for maintenance tasks	ARBPL
MainWorkCenterText	Work Center Text	TEXT40
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	TEXT14
AssetRoom	Room	CHAR8
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
TechnicalObjectCategoryDesc	Equipment category description	TEXT30
TechnicalObjectTypeDesc	Text for Object Type	TEXT20
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	/PLMB/GOS_OTYPE_DESC
DrillDownState	null
HierarchyNodeLevel	null
ParentNodeUniqueID	null
HierarchyNodeUniqueID	null

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object Client ABC Indicator for Technical Object	`C_TECHNICALOBJECTHIERVH.MANDT == T370C.MANDT` `C_TECHNICALOBJECTHIERVH.ABCINDICATOR == T370C.ABCKZ`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`C_TECHNICALOBJECTHIERVH.MANDT == T499S.MANDT` `C_TECHNICALOBJECTHIERVH.ASSETLOCATION == T499S.STAND` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANT == T499S.WERKS`
Technical Object Authorization Group Client Technical Object Authorization Group	`C_TECHNICALOBJECTHIERVH.MANDT == T370B.MANDT` `C_TECHNICALOBJECTHIERVH.AUTHORIZATIONGROUP == T370B.BEGRU`
Business Area Client Business Area	`C_TECHNICALOBJECTHIERVH.MANDT == TGSB.MANDT` `C_TECHNICALOBJECTHIERVH.BUSINESSAREA == TGSB.GSBER`
Catalog Profile Client Catalog Profile	`C_TECHNICALOBJECTHIERVH.MANDT == T352B.MANDT` `C_TECHNICALOBJECTHIERVH.CATALOGPROFILE == T352B.RBNR`
Company Code Client Company Code	`C_TECHNICALOBJECTHIERVH.MANDT == T001.MANDT` `C_TECHNICALOBJECTHIERVH.COMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area	`C_TECHNICALOBJECTHIERVH.MANDT == TKA01.MANDT` `C_TECHNICALOBJECTHIERVH.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Client Controlling Area Cost Center	`C_TECHNICALOBJECTHIERVH.[column in domain "DATBI"] == CSKS.DATBI` `C_TECHNICALOBJECTHIERVH.MANDT == CSKS.MANDT` `C_TECHNICALOBJECTHIERVH.CONTROLLINGAREA == CSKS.KOKRS` `C_TECHNICALOBJECTHIERVH.COSTCENTER == CSKS.KOSTL`
Currency Key Client Currency Key	`C_TECHNICALOBJECTHIERVH.MANDT == TCURC.MANDT` `C_TECHNICALOBJECTHIERVH.CURRENCY == TCURC.WAERS`
Division Client Division ? ?	`C_TECHNICALOBJECTHIERVH.MANDT == TVTA.MANDT` `C_TECHNICALOBJECTHIERVH.DIVISION == TVTA.SPART` `C_TECHNICALOBJECTHIERVH.[column in domain "VKORG"] == TVTA.VKORG` `C_TECHNICALOBJECTHIERVH.[column in domain "VTWEG"] == TVTA.VTWEG`
Equipment Number Equipment Number Technical Object Client	`C_TECHNICALOBJECTHIERVH.EQUIPMENT == EQUI.EQUNR` `C_TECHNICALOBJECTHIERVH.TECHNICALOBJECT == EQUI.EQUNR` `C_TECHNICALOBJECTHIERVH.MANDT == EQUI.MANDT`
Maintenance Plant Client Maintenance Plant	`C_TECHNICALOBJECTHIERVH.MANDT == T001W.MANDT` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANT == T001W.WERKS`
Plant Section Client Plant Section Maintenance Plant	`C_TECHNICALOBJECTHIERVH.MANDT == T357.MANDT` `C_TECHNICALOBJECTHIERVH.PLANTSECTION == T357.BEBER` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANT == T357.WERKS`
Technical Object Equipment Number Technical Object Client	`C_TECHNICALOBJECTHIERVH.EQUIPMENT == EQUI.EQUNR` `C_TECHNICALOBJECTHIERVH.TECHNICALOBJECT == EQUI.EQUNR` `C_TECHNICALOBJECTHIERVH.MANDT == EQUI.MANDT`
Technical Object Category Client Technical Object Category	`C_TECHNICALOBJECTHIERVH.MANDT == T370T.MANDT` `C_TECHNICALOBJECTHIERVH.TECHNICALOBJECTCATEGORY == T370T.EQTYP`
Type of Technical Object Client Type of Technical Object	`C_TECHNICALOBJECTHIERVH.MANDT == T370K.MANDT` `C_TECHNICALOBJECTHIERVH.TECHNICALOBJECTTYPE == T370K.EQART`

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	`C_TECHNICALOBJECTHIERVH.MANDT == T024I.MANDT` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANNINGPLANT == T024I.IWERK`
Maintenance planning plant Client Maintenance Planning Plant	`C_TECHNICALOBJECTHIERVH.MANDT == T399I.MANDT` `C_TECHNICALOBJECTHIERVH.MAINTENANCEPLANNINGPLANT == T399I.IWERK`