C_LocationAnalysisQuery

Location Analysis Query | view: CLOCANALYQUERY | TRAN | Extraction: Not supported | Component: Maintenance Notifications
Tables used: QMEL, QMSM, QMIH, JSTO, JEST, BUT000, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, EAML_D_LFE_DATA, ILOA, ADCP, ADR6, ADRC, ADRP, USR21, PRPS, CRHD, ADR2, ADR2, 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
NotificationCreationDate Date of Notification
NotificationReferenceDate Notification Reference Date
RequiredStartDate Required Start Date
RequiredEndDate Required End Date
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionEndDate End of Malfunction (Date)
Column Name Description
NotifProcessingPhase Notification Processing Phase Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
Column Name Description Domain name
NotificationText Short Text TEXT40
MainWorkCenter Main work center for maintenance tasks ARBPL
WorkCenter Work Center ARBPL
AssetRoom Room CHAR8
MaintObjectFreeDefinedAttrib Sort Field CHAR30
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ReportedByUser Name of Person Reporting Notification USNAM
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction
ConstructionMonth Month of Construction
NumberOfCreatedMaintNotifs No.of recorded notifications MCZAEHLER
NumberOfReportedBreakdowns Number of machine breakdowns reported MCZAEHLER
NumberOfCreatedMaintOrders PMIS: number of maintenance orders created MCZAEHLER
NumberOfCompletedMaintNotif No. of completed notifications MCZAEHLER
NmbrOfDeltdMaintNotifications Number of Deleted Notifications DEC9
NmbrOfOpenMaintNotifications Number of Open Notifications DEC9
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_LOCATIONANALYSISQUERY.ABCINDICATOR == T370C.ABCKZ
  • C_LOCATIONANALYSISQUERY.MANDT == T370C.MANDT
Assembly
  • Assembly
  • Client
  • C_LOCATIONANALYSISQUERY.ASSEMBLY == MARA.MATNR
  • C_LOCATIONANALYSISQUERY.MANDT == MARA.MANDT
Location of maintenance object
  • Location of maintenance object
  • Maintenance Plant
  • Client
  • C_LOCATIONANALYSISQUERY.ASSETLOCATION == T499S.STAND
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANT == T499S.WERKS
  • C_LOCATIONANALYSISQUERY.MANDT == T499S.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • C_LOCATIONANALYSISQUERY.AUTHORIZATIONGROUP == T370B.BEGRU
  • C_LOCATIONANALYSISQUERY.MANDT == T370B.MANDT
Business Area
  • Business Area
  • Client
  • C_LOCATIONANALYSISQUERY.BUSINESSAREA == TGSB.GSBER
  • C_LOCATIONANALYSISQUERY.MANDT == TGSB.MANDT
Catalog Profile
  • Catalog Profile
  • Client
  • C_LOCATIONANALYSISQUERY.CATALOGPROFILE == T352B.RBNR
  • C_LOCATIONANALYSISQUERY.MANDT == T352B.MANDT
Company Code
  • Company Code
  • Client
  • C_LOCATIONANALYSISQUERY.COMPANYCODE == T001.BUKRS
  • C_LOCATIONANALYSISQUERY.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_LOCATIONANALYSISQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_LOCATIONANALYSISQUERY.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • C_LOCATIONANALYSISQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_LOCATIONANALYSISQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_LOCATIONANALYSISQUERY.COSTCENTER == CSKS.KOSTL
  • C_LOCATIONANALYSISQUERY.MANDT == CSKS.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_LOCATIONANALYSISQUERY.EQUIPMENT == EQUI.EQUNR
  • C_LOCATIONANALYSISQUERY.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • C_LOCATIONANALYSISQUERY.FUNCTIONALLOCATION == IFLOT.TPLNR
  • C_LOCATIONANALYSISQUERY.MANDT == IFLOT.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANT == T001W.WERKS
  • C_LOCATIONANALYSISQUERY.MANDT == T001W.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTPRIORITYTYPE == T356.ARTPR
  • C_LOCATIONANALYSISQUERY.MAINTPRIORITY == T356.PRIOK
  • C_LOCATIONANALYSISQUERY.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_LOCATIONANALYSISQUERY.MANDT == T356A.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • C_LOCATIONANALYSISQUERY.MANUFACTURERCOUNTRY == T005.LAND1
  • C_LOCATIONANALYSISQUERY.MANDT == T005.MANDT
Notification Type
  • Notification Type
  • Client
  • C_LOCATIONANALYSISQUERY.NOTIFICATIONTYPE == TQ80.QMART
  • C_LOCATIONANALYSISQUERY.MANDT == TQ80.MANDT
Plant Section
  • Maintenance Plant
  • Plant Section
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANT == T357.WERKS
  • C_LOCATIONANALYSISQUERY.PLANTSECTION == T357.BEBER
  • C_LOCATIONANALYSISQUERY.MANDT == T357.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • C_LOCATIONANALYSISQUERY.TECHNICALOBJECTTYPE == T370K.EQART
  • C_LOCATIONANALYSISQUERY.MANDT == T370K.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_LOCATIONANALYSISQUERY.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_LOCATIONANALYSISQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_LOCATIONANALYSISQUERY.MANDT == T399I.MANDT