I_MaintenanceItemBasic

Basic view for MaintenanceItem | view: IMAINTITEMBASIC | Extraction: Not supported | Component: Maintenance Task Lists
Tables used: MPOS, T399W
Column Name Description
MaintenanceItem Maintenance item
Column Name Description
Column Name Description
Column Name Description
CreationDate Date of creation
LastChangeDate Last Changed On
Column Name Description
MaintenanceItemHasLongText Long Text Indicator Show values
WorkCenterTypeCode Object types of the CIM resource Show values
MaintenanceItemIsInactive Indicator that maintenance item is inactive Show values
ImmediateReleaseIsBlocked Do Not Release Immediately Show values
MaintenancePlanCallObject Call object for maintenance plan Show values
MaintItemCausesAreDisplayed Show Causes tab Show values
MaintItemReasonsAreDisplayed Show Reasons tab Show values
Column Name Description Domain name
SettlementRuleIsMaintained Indicator showing settlement rule maintained CHAR01
TaskListGroup Key for Task List Group
TaskListGroupCounter Group Counter
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
MaintenanceItemDescription Item Short Text
MaintenancePlanItemPosition Item in the maintenance plan WPPOS
SerialNumber Serial Number GERNR
MaintenanceItemObjectList Object list number OBJKN
OperationSystemCondition System Condition ANLZU
NumberOfTaskListExecutions Execution factor for whole task list AFAKT
SalesDocument Sales Document VBELN
PurchaseOrder Purchase order number EBELN
PurchaseOrderItem Purchase order item number EBELP
SettlementOrder Settlement order AUFNR
LastChangeDateTime Time Stamp for BI Delta Extraction RKE_TSTMP
MaintPlanLastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CycleSetSequence Cycle Set Sequence NUMC2
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
ServiceDocumentType Business Transaction Type CRM_PROCESS_TYPE
ServiceContract Transaction ID CRM_OBJECT_ID
ServiceContractItem Shortened Item Number in Document CRMS4_NUMBER_INT
ServiceOrderTemplate Transaction ID CRM_OBJECT_ID
Product Product Number MATNR
ServiceDocumentPriority Activity Priority SC_PRIO
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEITEMBASIC.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEITEMBASIC.MANDT == MARA.MANDT
Business area
  • Business Area
  • Client
  • I_MAINTENANCEITEMBASIC.BUSINESSAREA == TGSB.GSBER
  • I_MAINTENANCEITEMBASIC.MANDT == TGSB.MANDT
Equipment number
  • Equipment Number
  • Client
  • I_MAINTENANCEITEMBASIC.EQUIPMENT == EQUI.EQUNR
  • I_MAINTENANCEITEMBASIC.MANDT == EQUI.MANDT
Maintenance activity type
  • Maintenance activity type
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTENANCEITEMBASIC.MANDT == T353I.MANDT
Order number
  • Order number
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTENANCEITEMBASIC.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTENANCEITEMBASIC.MANDT == T003O.CLIENT
Maintenance plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEITEMBASIC.MANDT == MPLA.MANDT
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLAN == MPLA.WARPL
Maintenance strategy
  • Maintenance Strategy
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCESTRATEGY == T351.STRAT
  • I_MAINTENANCEITEMBASIC.MANDT == T351.MANDT
Location/account assignment to item object
  • Location and account assignment for technical object
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_MAINTENANCEITEMBASIC.MANDT == ILOA.MANDT
Priority
  • Priority
  • ?
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTPRIORITY == T356.PRIOK
  • I_MAINTENANCEITEMBASIC.[column in domain "ARTPR"] == T356.ARTPR
  • I_MAINTENANCEITEMBASIC.MANDT == T356.MANDT
WORK CENTER
  • Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • I_MAINTENANCEITEMBASIC.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCEITEMBASIC.WORKCENTERTYPECODE == CRID.OBJTY
  • I_MAINTENANCEITEMBASIC.MANDT == CRID.MANDT
Material number
  • Client
  • Material Number
  • I_MAINTENANCEITEMBASIC.MANDT == MARA.MANDT
  • I_MAINTENANCEITEMBASIC.MATERIAL == MARA.MATNR
Notification type
  • Notification Type
  • Client
  • I_MAINTENANCEITEMBASIC.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTENANCEITEMBASIC.MANDT == TQ80.MANDT
TASK LIST TYPE
  • Task List Type
  • Client
  • I_MAINTENANCEITEMBASIC.TASKLISTTYPE == TCA01.PLNTY
  • I_MAINTENANCEITEMBASIC.MANDT == TCA01.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance plan category
  • Maintenance item category
  • Maintenance plan category
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLANCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMBASIC.MANDT == T399P.MANDT
Maintenance planner group
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTENANCEITEMBASIC.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTENANCEITEMBASIC.MANDT == T399I.MANDT
Maintenance item category
  • Maintenance item category
  • Maintenance plan category
  • Client
  • I_MAINTENANCEITEMBASIC.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMBASIC.MAINTENANCEPLANCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMBASIC.MANDT == T399P.MANDT