C_MaintenanceOrderWrkflwInbox

Maintenance Order Workflow for My Inbox | view: CORDWFLINBOX | Extraction: Not supported | Component: Maintenance Orders

Tables used: QMEL, AFIH, AFKO, AFPO, JEST, PRTE, PLKZ, PLKO, T001, TKA02, TKA01, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, MPOS, AUFK, MPLA, T399W, T001W, PROJ, T000, EAPL, TAPL, PRPS, CRHD, ITOBCUST, IFLOUSR, T350

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (22)
🔗 Relations (19)

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
MaintOrdBasicStartDate	Basic Start Date
MaintOrdBasicEndDate	Basic finish date

Column Name	Description

Column Name	Description	Domain name
MaintOrderWithLeadingZeros	null
MaintenanceOrderDesc	Description	TEXT40
NotificationText	Short Text	TEXT40
MaintenancePlanDesc	Maintenance Plan Text	TEXT40
MaintenanceItem	Maintenance item	POSNU
MaintenanceItemDescription	Item Short Text	TEXT40
TaskList	null
TaskListDesc	Routing Description	TEXT40
MaintOrdMainWorkCenter	Main work center for maintenance tasks
MaintOrdMainWorkCenterPlant	Plant associated with main work center
MainWorkCenterPlantName	Plant Name	TEXT30
MaintenancePlanningPlantName	Plant Name	TEXT30
MaintOrdPersonResponsible	Person Responsible ID
PersonResponsibleName	Person Responsible Name
TechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
TechnicalObjectDescription	Technical Object Description
SerialNumber	Serial Number	GERNR
MaintOrdTotalCost	null
CompanyCodeName	Name of Company Code or Company	TEXT25
LocAcctAssgmtCtrlgAreaDesc	Controlling Area Name
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40

Master Data Relations \| to Other Relations ↓	Join Conditions
Assembly Assembly Client	`C_MAINTENANCEORDERWRKFLWINBOX.ASSEMBLY == MARA.MATNR` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == MARA.MANDT`
Company Code Company Code Client	`C_MAINTENANCEORDERWRKFLWINBOX.COMPANYCODE == T001.BUKRS` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_MAINTENANCEORDERWRKFLWINBOX.CONTROLLINGAREA == TKA01.KOKRS` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == TKA01.MANDT`
Order Currency Order Currency Client	`C_MAINTENANCEORDERWRKFLWINBOX.CURRENCY == TCURC.WAERS` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == TCURC.MANDT`
Equipment Number Equipment Number Client	`C_MAINTENANCEORDERWRKFLWINBOX.EQUIPMENT == EQUI.EQUNR` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == EQUI.MANDT`
Functional Location Functional Location Client	`C_MAINTENANCEORDERWRKFLWINBOX.FUNCTIONALLOCATION == IFLOT.TPLNR` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == IFLOT.MANDT`
Cost Center Cost Center ? Controlling Area Client	`C_MAINTENANCEORDERWRKFLWINBOX.LOCACCTASSGMTCOSTCENTER == CSKS.KOSTL` `C_MAINTENANCEORDERWRKFLWINBOX.[column in domain "DATBI"] == CSKS.DATBI` `C_MAINTENANCEORDERWRKFLWINBOX.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == CSKS.MANDT`
Order Number Order Number Settlement order Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEORDER == AUFK.AUFNR` `C_MAINTENANCEORDERWRKFLWINBOX.SETTLEMENTORDER == AUFK.AUFNR` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == AUFK.MANDT`
Order Type Order Type Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEORDERTYPE == T003O.AUART` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == T003O.CLIENT`
Maintenance Plan Maintenance Plan Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEPLAN == MPLA.WARPL` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == MPLA.MANDT`
Location and account assignment for technical object Location and account assignment for technical object Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == ILOA.MANDT`
Partner Function of Order Header Partner Function of Order Header Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTORDERRESPPARTNERFUNCTION == TPAR.PARVW` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == TPAR.MANDT`
Material Number for Order Client Material Number for Order	`C_MAINTENANCEORDERWRKFLWINBOX.MANDT == MARA.MANDT` `C_MAINTENANCEORDERWRKFLWINBOX.MATERIAL == MARA.MATNR`
Settlement order Order Number Settlement order Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEORDER == AUFK.AUFNR` `C_MAINTENANCEORDERWRKFLWINBOX.SETTLEMENTORDER == AUFK.AUFNR` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == AUFK.MANDT`
Object ID of the Work Center Object ID of the Work Center Client ?	`C_MAINTENANCEORDERWRKFLWINBOX.WORKCENTERINTERNALID == CRID.OBJID` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == CRID.MANDT` `C_MAINTENANCEORDERWRKFLWINBOX.[column in domain "CR_OBJTY"] == CRID.OBJTY`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_MAINTENANCEORDERWRKFLWINBOX.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_MAINTENANCEORDERWRKFLWINBOX.MANDT == T399I.MANDT`