C_ObjPgMaintOrder

Maintenance Order | view: COBJPGMAINTORD | Extraction: Not supported | Component: Plant Maintenance

Tables used: QMEL, AFIH, AFKO, AFKO, AFVC, AFPO, EKKO, EKPO, EKKN, RESB, JSTO, JEST, PRTE, T370C, T370C_T, PLKZ, PLKO, TGSB, TGSBT, T001, TKA02, TKA01, TPMUS, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, T499S, ILOA, T353I, T353I_T, MPOS, AUFK, AUFK, MPLA, T399W, T357M, T357M_T, TKO08, TKO09, T001W, T357, T356, CRTX, PROJ, PROJ, CNLDST_SHORTTX, T000, EAPL, TAPL, USR21, TJ30, TJ30T, PRPS, PRPS, CRHD, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, ITOBCUST, IFLOUSR, T350

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (9)
☰ Categorical (9)
Other (91)
🔗 Relations (40)

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
LatestAcceptableCompletionDate	Final Due Date
TaskListKeyDate	null
MaintOrdBasicStartDate	Basic Start Date
MaintOrdBasicEndDate	Basic finish date
MaintOrdSchedBasicStartDate	Scheduled start
ScheduledBasicEndDate	Scheduled finish
MaintOrdSchedBasicStartTime	Scheduled Start (Time)
MaintOrderReferenceDate	PM Order: Reference Date
CreationDate	Created On

Column Name	Description
ControllingObjectClass	Controlling Object Class	Show values
RefTimeForOrderCompletion	Default Values: Reference Time for Order Completion	Show values
MaintOrdTypeHasActvPhaseModel	Order Type Relevant for Phase Model in Reactive Maintenance	Show values
CompleteBusinessAndSetNotifSts	Complete (Business) and Determine Notification Status	Show values
CompleteTechlyAndSetNotifSts	Complete Technically and Determine Notification Status	Show values
DoNotExectOrderAndSetNotifSts	Do Not Execute Order and Determine Notification Status	Show values
ResetTechCompltnAndSetNotifSts	Cancel Technical Completion and Determine Notification Stat.	Show values
OrdIsNotSchedldAutomatically	Checkbox	Show values
MaintOrderHasActiveWorkflow	Is Workflow Active	Show values

Column Name	Description	Domain name
MaintOrderWithLeadingZeros	null
MaintenanceOrderDesc	Description	TEXT40
MaintenanceOrderTypeName	Name of an Order Type
MaintenanceProcessingPhase	Maintenance Processing Phase
MaintenanceProcessingPhaseDesc	Short Text for Fixed Values
MaintPriorityColorCode	null
MaintPriorityDesc	Priority Text
MaintenanceNotificationText	Short Text
TaskListGroup	Bill of Operations ID	PLNNR
TaskListType	Bill of Operations Type	PLNTY
TaskListGroupCounter	Bill of Operations Variant	ALTNR
TaskList	null
TaskListDesc	Routing Description
MaintenancePlanDesc	Maintenance Plan Text
MaintenanceItem	Maintenance item	POSNU
MaintenanceItemDescription	Item Short Text
TechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
TechnicalObjectDescription	Technical Object Description
FunctionalLocationName	Description of functional location	TEXT40
EquipmentName	Description of technical object	TEXT40
TechObjIsEquipOrFuncnlLoc	Technical Object Type
TechObjIsEquipOrFuncnlLocDesc	Description of Technical Object Type
OrderHasLongText	Order Has Long Text
MainWorkCenter	Work Center
MainWorkCenterText	Work Center Text
ConcatenatedActiveSystStsName	Concatenated System Status
ConcatenatedActiveUserStsName	Concatenated User Status
ConcatenatedOrderPhaseCtrlText	Phase control codes for maintenance order	CHAR1000
MaintObjNmbrOfPhaseCtrlCodes	null
MaintOrdHasOpenMainWork	Checkbox
OrderNmbrOfAttachedDocuments	null
MaintOrderNumberOfOperations	null
MainWorkCenterPlantName	Plant Name
MaintenancePlannerGroupName	Name of the Maintenance Planner Group
MaintenancePlanningPlantName	Plant Name
MaintOrdPersonResponsible_H	Person Responsible ID	I_PARNR
MaintOrdPersonResponsible	Person Responsible
PersonResponsibleName	Person Responsible Name
CreatedByUser	Entered By
CreatedByUserDescription	User Description
MaterialName	Material Description
SerialNumber	Serial Number	GERNR
AssemblyName	Material Description
OperationSystemConditionText	Text on Operating Condition
MaintenanceOrderPlanningCode	Maintenance order planning indicator
MaintOrderPlanningCodeName	Short Text for Fixed Values
MaintenanceActivityTypeName	Description of maintenance activity type
PlantName	Plant Name
AssetLocationName	Location Name	TEXT40
AssetRoom	Room	CHAR8
PlantSectionPersonRespName	Group of Employees Responsible for Company Area
PlantSectionPersonRespPhone	Phone Number of Employee Group Responsible for Company Area
WorkCenter	Work Center
WorkCenterText	Work Center Text
ABCIndicatorDesc	Description of ABC Indicator of Technical Object
SortField	Sort Field
CompanyCodeName	Name of Company Code or Company
BusinessAreaName	Business Area Description
ControllingAreaName	Controlling Area Name
CostCenterName	Cost Center Name	TEXT20
ProfitCenterName	Description of Profit Center
ControllingObjectClassName	Short Text for Fixed Values
OrderProcessingGroup	Processing group
OrderProcessingGroupName	Order Processing Group Name
Project	Project definition	PS_PSPID
ProjectDescription	Project Definition Name	TEXT40
WBSElement	Work Breakdown Structure Element (WBS Element)
WBSDescription	WBS Element Name
LocAcctAssgmtCompanyCodeName	Name of Company Code or Company
LocAcctAssgmtBusinessAreaDesc	Business Area Description
LocAcctAssgmtCtrlgAreaDesc	Controlling Area Name
LocAcctAssgmtCostCenterDesc	Cost Center Name
CityName	City	TEXT25
MasterFixedAssetDescription	Main Asset Text
LocAcctAssgmtWBSElement	Work Breakdown Structure Element (WBS Element)
LocAcctAssgmtWBSElementDesc	WBS Element Name
TechnicalObject	Technical Object	EAMS_TEC_OBJ
MaintenanceOrderThumbnailURL	null
MaintOrderIsFinallyConfirmed	Checkbox
UserStatus	null
StatusName	null
StatusProfile	Status Profile
MaintOrderHasOpenReservations	Checkbox
MaintOrdHasOpenPurchaseOrders	Checkbox
MaintOrdHasOpenServices	Checkbox
MaintOrdCostCriticality	null
MaintOrdTotalCost	null
MaintOrdProcessPhaseCode	Process Phase
MaintOrdProcessSubPhaseCode	Process Subphase
IsCloudSystem	Single-Character Flag	CHAR1
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_OBJPGMAINTORDER.ABCINDICATOR == T370C.ABCKZ` `C_OBJPGMAINTORDER.MANDT == T370C.MANDT`
Assembly Client Assembly	`C_OBJPGMAINTORDER.MANDT == MARA.MANDT` `C_OBJPGMAINTORDER.ASSEMBLY == MARA.MATNR`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`C_OBJPGMAINTORDER.MANDT == T499S.MANDT` `C_OBJPGMAINTORDER.ASSETLOCATION == T499S.STAND` `C_OBJPGMAINTORDER.MAINTENANCEPLANT == T499S.WERKS`
Scheduling type Client Scheduling type	`C_OBJPGMAINTORDER.MANDT == T482.MANDT` `C_OBJPGMAINTORDER.BASICSCHEDULINGTYPE == T482.TERMKZ`
Business Area Client Business Area Business Area	`C_OBJPGMAINTORDER.MANDT == TGSB.MANDT` `C_OBJPGMAINTORDER.LOCACCTASSGMTBUSINESSAREA == TGSB.GSBER` `C_OBJPGMAINTORDER.BUSINESSAREA == TGSB.GSBER`
Company Code Client Company Code Company Code	`C_OBJPGMAINTORDER.MANDT == T001.MANDT` `C_OBJPGMAINTORDER.COMPANYCODE == T001.BUKRS` `C_OBJPGMAINTORDER.LOCACCTASSGMTCOMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area Controlling Area	`C_OBJPGMAINTORDER.MANDT == TKA01.MANDT` `C_OBJPGMAINTORDER.LOCACCTASSGMTCONTROLLINGAREA == TKA01.KOKRS` `C_OBJPGMAINTORDER.CONTROLLINGAREA == TKA01.KOKRS`
Order Currency Client Order Currency	`C_OBJPGMAINTORDER.MANDT == TCURC.MANDT` `C_OBJPGMAINTORDER.CURRENCY == TCURC.WAERS`
Equipment Number Client Equipment Number	`C_OBJPGMAINTORDER.MANDT == EQUI.MANDT` `C_OBJPGMAINTORDER.EQUIPMENT == EQUI.EQUNR`
Asset Subnumber Main Asset Number Asset Subnumber Client Company Code Company Code	`C_OBJPGMAINTORDER.MASTERFIXEDASSET == ANLA.ANLN1` `C_OBJPGMAINTORDER.FIXEDASSET == ANLA.ANLN2` `C_OBJPGMAINTORDER.MANDT == ANLA.MANDT` `C_OBJPGMAINTORDER.COMPANYCODE == ANLA.BUKRS` `C_OBJPGMAINTORDER.LOCACCTASSGMTCOMPANYCODE == ANLA.BUKRS`
Functional Location Client Functional Location	`C_OBJPGMAINTORDER.MANDT == IFLOT.MANDT` `C_OBJPGMAINTORDER.FUNCTIONALLOCATION == IFLOT.TPLNR`
Business Area Client Business Area Business Area	`C_OBJPGMAINTORDER.MANDT == TGSB.MANDT` `C_OBJPGMAINTORDER.LOCACCTASSGMTBUSINESSAREA == TGSB.GSBER` `C_OBJPGMAINTORDER.BUSINESSAREA == TGSB.GSBER`
Company Code Client Company Code Company Code	`C_OBJPGMAINTORDER.MANDT == T001.MANDT` `C_OBJPGMAINTORDER.COMPANYCODE == T001.BUKRS` `C_OBJPGMAINTORDER.LOCACCTASSGMTCOMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area Controlling Area	`C_OBJPGMAINTORDER.MANDT == TKA01.MANDT` `C_OBJPGMAINTORDER.LOCACCTASSGMTCONTROLLINGAREA == TKA01.KOKRS` `C_OBJPGMAINTORDER.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Cost Center Client ? Controlling Area Controlling Area	`C_OBJPGMAINTORDER.LOCACCTASSGMTCOSTCENTER == CSKS.KOSTL` `C_OBJPGMAINTORDER.MANDT == CSKS.MANDT` `C_OBJPGMAINTORDER.[column in domain "DATBI"] == CSKS.DATBI` `C_OBJPGMAINTORDER.LOCACCTASSGMTCONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTORDER.CONTROLLINGAREA == CSKS.KOKRS`
Maintenance Activity Type Client Maintenance Activity Type	`C_OBJPGMAINTORDER.MANDT == T353I.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEACTIVITYTYPE == T353I.ILART`
Order Number Client Order Number Settlement order	`C_OBJPGMAINTORDER.MANDT == AUFK.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEORDER == AUFK.AUFNR` `C_OBJPGMAINTORDER.SETTLEMENTORDER == AUFK.AUFNR`
Order Type Order Type Client	`C_OBJPGMAINTORDER.MAINTENANCEORDERTYPE == T003O.AUART` `C_OBJPGMAINTORDER.MANDT == T003O.CLIENT`
Maintenance Plan Client Maintenance Plan	`C_OBJPGMAINTORDER.MANDT == MPLA.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Plant Client Maintenance Plant	`C_OBJPGMAINTORDER.MANDT == T001W.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEPLANT == T001W.WERKS`
Revision for Plant Maintenance and Customer Service Client Revision for Plant Maintenance and Customer Service Maintenance Planning Plant	`C_OBJPGMAINTORDER.MANDT == T352R.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEREVISION == T352R.REVNR` `C_OBJPGMAINTORDER.MAINTENANCEPLANNINGPLANT == T352R.IWERK`
Location and account assignment for technical object Client Location and account assignment for technical object	`C_OBJPGMAINTORDER.MANDT == ILOA.MANDT` `C_OBJPGMAINTORDER.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN`
Partner Function of Order Header Client Partner Function of Order Header	`C_OBJPGMAINTORDER.MANDT == TPAR.MANDT` `C_OBJPGMAINTORDER.MAINTORDERRESPPARTNERFUNCTION == TPAR.PARVW`
Priority Priority Type Client Priority	`C_OBJPGMAINTORDER.MAINTPRIORITYTYPE == T356.ARTPR` `C_OBJPGMAINTORDER.MANDT == T356.MANDT` `C_OBJPGMAINTORDER.MAINTPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`C_OBJPGMAINTORDER.MAINTPRIORITYTYPE == T356A.ARTPR` `C_OBJPGMAINTORDER.MANDT == T356A.MANDT`
Plant Client Plant Plant	`C_OBJPGMAINTORDER.MANDT == T001W.MANDT` `C_OBJPGMAINTORDER.PLANT == T001W.WERKS` `C_OBJPGMAINTORDER.MAINWORKCENTERPLANT == T001W.WERKS`
Material Number for Order Client Material Number for Order	`C_OBJPGMAINTORDER.MANDT == MARA.MANDT` `C_OBJPGMAINTORDER.MATERIAL == MARA.MATNR`
System Condition Client System Condition	`C_OBJPGMAINTORDER.MANDT == T357M.MANDT` `C_OBJPGMAINTORDER.OPERATIONSYSTEMCONDITION == T357M.ANLZU`
Plant Client Plant Plant	`C_OBJPGMAINTORDER.MANDT == T001W.MANDT` `C_OBJPGMAINTORDER.PLANT == T001W.WERKS` `C_OBJPGMAINTORDER.MAINWORKCENTERPLANT == T001W.WERKS`
Plant Section Plant Section Client Maintenance Plant	`C_OBJPGMAINTORDER.PLANTSECTION == T357.BEBER` `C_OBJPGMAINTORDER.MANDT == T357.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEPLANT == T357.WERKS`
Profit Center Client ? Controlling Area Controlling Area Profit Center	`C_OBJPGMAINTORDER.MANDT == CEPC.MANDT` `C_OBJPGMAINTORDER.[column in domain "DATBI"] == CEPC.DATBI` `C_OBJPGMAINTORDER.LOCACCTASSGMTCONTROLLINGAREA == CEPC.KOKRS` `C_OBJPGMAINTORDER.CONTROLLINGAREA == CEPC.KOKRS` `C_OBJPGMAINTORDER.PROFITCENTER == CEPC.PRCTR`
Responsible Cost Center Client ? Controlling Area Controlling Area Responsible Cost Center	`C_OBJPGMAINTORDER.MANDT == CSKS.MANDT` `C_OBJPGMAINTORDER.[column in domain "DATBI"] == CSKS.DATBI` `C_OBJPGMAINTORDER.LOCACCTASSGMTCONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTORDER.CONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL`
Settlement order Client Order Number Settlement order	`C_OBJPGMAINTORDER.MANDT == AUFK.MANDT` `C_OBJPGMAINTORDER.MAINTENANCEORDER == AUFK.AUFNR` `C_OBJPGMAINTORDER.SETTLEMENTORDER == AUFK.AUFNR`
Object ID of the Work Center Client Object ID of the Work Center ?	`C_OBJPGMAINTORDER.MANDT == CRID.MANDT` `C_OBJPGMAINTORDER.WORKCENTERINTERNALID == CRID.OBJID` `C_OBJPGMAINTORDER.[column in domain "CR_OBJTY"] == CRID.OBJTY`

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