I_LocationAnalysisCube

Location Analysis - Cube | view: ILOCANALYSISCUBE | TRAN | Extraction: Full only | 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

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (16)
☰ Categorical (4)
Other (31)
🔗 Relations (23)

Column Name	Description
MaintenanceNotification	Notification Number

Column Name	Description

Column Name	Description
📏 Unit of Measurement for Linear Data (LinearDataUnitOfMeasure):
LinearDataLength	null

Column Name	Description
CreationDate	Date on which the record was created
CreationTime	Time at Which Record Was Added
LastChangeDate	Last Changed On
NotificationCreationDate	Date of Notification
NotificationCreationTime	Time of Notification
NotificationCompletionDate	Date for Notification Completion
CompletionTime	Completion Time of Notification
NotificationReferenceDate	Notification Reference Date
RequiredStartDate	Required Start Date
RequiredStartTime	Required Start Time
RequiredEndDate	Required End Date
RequiredEndTime	Required End Time
MalfunctionStartDate	Start of Malfunction (Date)
MalfunctionStartTime	Start of Malfunction (Time)
MalfunctionEndDate	End of Malfunction (Date)
MalfunctionEndTime	End of Malfunction (Time)

Column Name	Description
NotifProcessingPhase	Notification Processing Phase	Show values
NotificationOrigin	Origin of Notification	Show values
MaintenanceObjectIsDown	Breakdown Indicator	Show values
TechObjIsEquipOrFuncnlLoc	Technical Object Type	Show values

Column Name	Description	Domain name
NotificationText	Short Text	TEXT40
IsDeleted	Object is deleted	CHAR1
MainWorkCenter	Main work center for maintenance tasks	ARBPL
WorkCenter	Work Center	ARBPL
AssetRoom	Room	CHAR8
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
LastChangeDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
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
LinearDataStartPoint	Start Point	EAML_POINT
LinearDataEndPoint	End Point	EAML_POINT
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
MaintObjectDowntimeDuration	Breakdown Duration	FLTP
TotalLeadTimeOfMaintNotif	Total Lead Time of Notifications	QSTATWERT
NrOfOutstandingMaintNotif	No. of Notifications with Status Outstanding	INT4
NrOfMaintNotifCmpltdOnSched	Number of Notifications Completed on Schedule	INT4
NumberOfMaintNotifTasks	No. of Tasks	INT4
NrOfMaintNotifSuccssflTasks	No. of Tasks with Status Successful	INT4
NrOfMaintNotifActiveTasks	Number of Tasks with Status 'Outstanding' or 'Released'	INT4

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object Client ABC Indicator for Technical Object	`I_LOCATIONANALYSISCUBE.MANDT == T370C.MANDT` `I_LOCATIONANALYSISCUBE.ABCINDICATOR == T370C.ABCKZ`
Assembly Assembly Client	`I_LOCATIONANALYSISCUBE.ASSEMBLY == MARA.MATNR` `I_LOCATIONANALYSISCUBE.MANDT == MARA.MANDT`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`I_LOCATIONANALYSISCUBE.MANDT == T499S.MANDT` `I_LOCATIONANALYSISCUBE.ASSETLOCATION == T499S.STAND` `I_LOCATIONANALYSISCUBE.MAINTENANCEPLANT == T499S.WERKS`
Technical Object Authorization Group Client Technical Object Authorization Group	`I_LOCATIONANALYSISCUBE.MANDT == T370B.MANDT` `I_LOCATIONANALYSISCUBE.AUTHORIZATIONGROUP == T370B.BEGRU`
Business Area Client Business Area	`I_LOCATIONANALYSISCUBE.MANDT == TGSB.MANDT` `I_LOCATIONANALYSISCUBE.BUSINESSAREA == TGSB.GSBER`
Catalog Profile Client Catalog Profile	`I_LOCATIONANALYSISCUBE.MANDT == T352B.MANDT` `I_LOCATIONANALYSISCUBE.CATALOGPROFILE == T352B.RBNR`
Company Code Client Company Code	`I_LOCATIONANALYSISCUBE.MANDT == T001.MANDT` `I_LOCATIONANALYSISCUBE.COMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area	`I_LOCATIONANALYSISCUBE.MANDT == TKA01.MANDT` `I_LOCATIONANALYSISCUBE.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client Controlling Area ? Cost Center	`I_LOCATIONANALYSISCUBE.MANDT == CSKS.MANDT` `I_LOCATIONANALYSISCUBE.CONTROLLINGAREA == CSKS.KOKRS` `I_LOCATIONANALYSISCUBE.[column in domain "DATBI"] == CSKS.DATBI` `I_LOCATIONANALYSISCUBE.COSTCENTER == CSKS.KOSTL`
Equipment Number Client Equipment Number	`I_LOCATIONANALYSISCUBE.MANDT == EQUI.MANDT` `I_LOCATIONANALYSISCUBE.EQUIPMENT == EQUI.EQUNR`
Functional Location Client Functional Location	`I_LOCATIONANALYSISCUBE.MANDT == IFLOT.MANDT` `I_LOCATIONANALYSISCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR`
Maintenance Plant Client Maintenance Plant	`I_LOCATIONANALYSISCUBE.MANDT == T001W.MANDT` `I_LOCATIONANALYSISCUBE.MAINTENANCEPLANT == T001W.WERKS`
Priority Client Priority Type Priority	`I_LOCATIONANALYSISCUBE.MANDT == T356.MANDT` `I_LOCATIONANALYSISCUBE.MAINTPRIORITYTYPE == T356.ARTPR` `I_LOCATIONANALYSISCUBE.MAINTPRIORITY == T356.PRIOK`
Priority Type Client Priority Type	`I_LOCATIONANALYSISCUBE.MANDT == T356A.MANDT` `I_LOCATIONANALYSISCUBE.MAINTPRIORITYTYPE == T356A.ARTPR`
Plant associated with main work center Client Plant associated with main work center Plant	`I_LOCATIONANALYSISCUBE.MANDT == T001W.MANDT` `I_LOCATIONANALYSISCUBE.MAINWORKCENTERPLANT == T001W.WERKS` `I_LOCATIONANALYSISCUBE.WORKCENTERPLANT == T001W.WERKS`
Country/Region of Manufacture Client Country/Region of Manufacture	`I_LOCATIONANALYSISCUBE.MANDT == T005.MANDT` `I_LOCATIONANALYSISCUBE.MANUFACTURERCOUNTRY == T005.LAND1`
Notification Type Client Notification Type	`I_LOCATIONANALYSISCUBE.MANDT == TQ80.MANDT` `I_LOCATIONANALYSISCUBE.NOTIFICATIONTYPE == TQ80.QMART`
Plant Section Client Plant Section Maintenance Plant	`I_LOCATIONANALYSISCUBE.MANDT == T357.MANDT` `I_LOCATIONANALYSISCUBE.PLANTSECTION == T357.BEBER` `I_LOCATIONANALYSISCUBE.MAINTENANCEPLANT == T357.WERKS`
Type of Technical Object Client Type of Technical Object	`I_LOCATIONANALYSISCUBE.MANDT == T370K.MANDT` `I_LOCATIONANALYSISCUBE.TECHNICALOBJECTTYPE == T370K.EQART`
Plant Client Plant associated with main work center Plant	`I_LOCATIONANALYSISCUBE.MANDT == T001W.MANDT` `I_LOCATIONANALYSISCUBE.MAINWORKCENTERPLANT == T001W.WERKS` `I_LOCATIONANALYSISCUBE.WORKCENTERPLANT == T001W.WERKS`

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