C_TechObjNotifSubQuery

Tech. Object and Notification Subquery | view: CTECHOBJNOTIF | TRAN | Extraction: Not supported | Component: Maintenance Notifications
Tables used: QMEL, QMIH, JSTO, JEST, T370U, EQUI, T370T, EQKT, EQUZ, T370F_T, IFLOS, IFLOT, T370F, IFLOTX, ILOA, T370K, T370K_T, CRHD, ITOBCUST, IFLOUSR
Column Name Description
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
Column Name Description Domain name
TechObjIsEquipOrFuncnlLoc Technical Object Type SYCHAR132
TechnicalObjectDescription Technical Object Description TEXT40
TechObjIsEquipOrFuncnlLocDesc Description of Technical Object Type /PLMB/GOS_OTYPE_DESC
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
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
MainWorkCenter Work Center ARBPL
MaintenanceWorkCenter Work Center ARBPL
MaintObjectFreeDefinedAttrib Sort Field CHAR30
AssetRoom Room CHAR8
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_TECHOBJNOTIFSUBQUERY.ABCINDICATOR == T370C.ABCKZ
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T370C.MANDT
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T499S.MANDT
  • C_TECHOBJNOTIFSUBQUERY.ASSETLOCATION == T499S.STAND
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANT == T499S.WERKS
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T370B.MANDT
  • C_TECHOBJNOTIFSUBQUERY.AUTHORIZATIONGROUP == T370B.BEGRU
Business Area
  • Business Area
  • Client
  • C_TECHOBJNOTIFSUBQUERY.BUSINESSAREA == TGSB.GSBER
  • C_TECHOBJNOTIFSUBQUERY.MANDT == TGSB.MANDT
Catalog Profile
  • Catalog Profile
  • Client
  • C_TECHOBJNOTIFSUBQUERY.CATALOGPROFILE == T352B.RBNR
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T352B.MANDT
Company Code
  • Company Code
  • Client
  • C_TECHOBJNOTIFSUBQUERY.COMPANYCODE == T001.BUKRS
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_TECHOBJNOTIFSUBQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_TECHOBJNOTIFSUBQUERY.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_TECHOBJNOTIFSUBQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_TECHOBJNOTIFSUBQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_TECHOBJNOTIFSUBQUERY.MANDT == CSKS.MANDT
  • C_TECHOBJNOTIFSUBQUERY.COSTCENTER == CSKS.KOSTL
Division
  • Division
  • ?
  • Client
  • ?
  • C_TECHOBJNOTIFSUBQUERY.DIVISION == TVTA.SPART
  • C_TECHOBJNOTIFSUBQUERY.[column in domain "VKORG"] == TVTA.VKORG
  • C_TECHOBJNOTIFSUBQUERY.MANDT == TVTA.MANDT
  • C_TECHOBJNOTIFSUBQUERY.[column in domain "VTWEG"] == TVTA.VTWEG
Equipment Number
  • Client
  • Equipment Number
  • Technical Object
  • Technical Object
  • C_TECHOBJNOTIFSUBQUERY.MANDT == EQUI.MANDT
  • C_TECHOBJNOTIFSUBQUERY.EQUIPMENT == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHOBJECTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHNICALOBJECT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • C_TECHOBJNOTIFSUBQUERY.MANDT == IFLOT.MANDT
  • C_TECHOBJNOTIFSUBQUERY.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T001W.MANDT
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANT == T001W.WERKS
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • C_TECHOBJNOTIFSUBQUERY.PLANTSECTION == T357.BEBER
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T357.MANDT
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANT == T357.WERKS
Technical Object
  • Client
  • Equipment Number
  • Technical Object
  • Technical Object
  • C_TECHOBJNOTIFSUBQUERY.MANDT == EQUI.MANDT
  • C_TECHOBJNOTIFSUBQUERY.EQUIPMENT == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHOBJECTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHNICALOBJECT == EQUI.EQUNR
Equipment category
  • Equipment category
  • Client
  • C_TECHOBJNOTIFSUBQUERY.TECHNICALOBJECTCATEGORY == T370T.EQTYP
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T370T.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • C_TECHOBJNOTIFSUBQUERY.TECHNICALOBJECTTYPE == T370K.EQART
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T370K.MANDT
Technical Object
  • Client
  • Equipment Number
  • Technical Object
  • Technical Object
  • C_TECHOBJNOTIFSUBQUERY.MANDT == EQUI.MANDT
  • C_TECHOBJNOTIFSUBQUERY.EQUIPMENT == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHOBJECTWITHLEADINGZEROS == EQUI.EQUNR
  • C_TECHOBJNOTIFSUBQUERY.TECHNICALOBJECT == EQUI.EQUNR
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T024I.MANDT
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance planning plant
  • Client
  • Maintenance Planning Plant
  • C_TECHOBJNOTIFSUBQUERY.MANDT == T399I.MANDT
  • C_TECHOBJNOTIFSUBQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK