C_MRPMaintenanceOrderComponent

MRP Maintenance Order Component | view: CMRPMAINTORDCOMP | Extraction: Not supported | Component: Fiori UI for Production Planning and Control

Tables used: AFIH, AFKO, RESB, AFKO, AFVC, AFVV, MATDOC_EXTRACT, MARA, AUFK, AUFK, RSADD, RSDB, AUFK, MARA, MAKT, T003O, T003P, MARA, T001, T001K, T001W, CRHD, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, MARC, T024I, /SAPSLL/TUNOS

🔑 Keys (2)
💰 Amounts
∑ Quantities (8)
📅 Dates (6)
☰ Categorical (3)
Other (53)
🔗 Relations (22)

Column Name	Description
Reservation	Number of reservation/dependent requirements
ReservationItem	Item Number of Reservation / Dependent Requirements

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
OrderedQuantity	Requirement Quantity
WithdrawnQuantity	Quantity withdrawn
OpenQuantity	null
FixedLotSizeQuantity	Fixed lot size
MinimumLotSizeQuantity	Minimum Lot Size
MaximumLotSizeQuantity	Maximum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity
OrderPlannedTotalQty	Actual work

Column Name	Description
PlannedStartDate	Basic Start Date
OrderPlannedEndDate	Basic finish date
ActualStartDate	Actual Execution Start Date
ActualEndDate	Actual Execution End Date
ScheduledBasicStartDate	Earliest scheduled start: Execution (date)
ScheduledBasicEndDate	Earliest scheduled finish: Execution (date)

Column Name	Description
MaterialProcurementCategory	Procurement Type	Show values
OrderCategory	Order category	Show values
IsDeleted	Item is deleted	Show values

Column Name	Description	Domain name
RecordType	Record type	RSART
RequirementType	null
MaterialName	Material Description	TEXT40
SupplyingPlant	null
RequirementDate	null
Supplier	null
MaterialProcurementType	Special procurement type	SOBSL
OrderTypeName	Name of an Order Type	TEXT40
PlannedOrder	null
ProductionPlant	null
MRPController	null
MRPControllerName	null
MRPControllerPhoneNumber	null
EmailAddress	null
ProductionSupervisor	null
ProductionVersion	null
ProductionVersionText	null
ProductionLine	null
InventorySpecialStockType	null
CommittedQuantity	null
OrderPlannedScrapQty	null
ExpectedDeviationQuantity	null
GoodsReceiptQty	null
ActualReleasedDate	null
ScheduledReleaseDate	null
TopLevelOrder	null
TopLevelOrderMaterial	null
MaterialGoodsReceiptDuration	null
MaterialPlannedDeliveryDurn	null
MaterialPlannedProductionDurn	null
MaterialReplenishmentLeadDurn	null
SalesOrder	null
SalesOrderItem	null
SalesOrderType	null
SalesOrderItemMaterial	null
Customer	null
WBSElementInternalID	null
WBSElement	null
WBSDescription	null
ResponsiblePerson	null
ResponsiblePersonName	null
ProjectInternalID	null
ProjectDescription	null
Project	null
TotalReplenishmentLeadDuration	Total replenishment lead time (in workdays)	DEC3
MaintenanceWorkCenter	Work Center	ARBPL
MaintenancePlannerGroupName	Name of the Maintenance Planner Group	TEXT18
MaintenanceOrderOperation	Operation/Activity Number	VORNR
MaintenanceOrderComponent	BOM item number	SPOSN
ComponentDescription	BOM Item Text (Line 1)	TEXT40
MaintOrderRoutingNumber	Routing number of operations in the order	AUFPL
MaintOrderOperationCounter	Internal counter	CIM_COUNT
PurchaseRequisition	Purchase Requisition Number	BANFN

Master Data Relations \| to Other Relations ↓	Join Conditions
Maintenance Activity Type Maintenance Activity Type Client	`C_MRPMAINTENANCEORDERCOMPONENT.ACTIVITYTYPE == T353I.ILART` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T353I.MANDT`
Base Unit of Measure Base Unit of Measure Client	`C_MRPMAINTENANCEORDERCOMPONENT.BASEUNIT == T006.MSEHI` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T006.MANDT`
Item category (bill of material) Client Item category (bill of material)	`C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T418.MANDT` `C_MRPMAINTENANCEORDERCOMPONENT.ITEMCATEGORY == T418.POSTP`
Order Number Order Number Order Number Client	`C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEORDER == AUFK.AUFNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANUFACTURINGORDER == AUFK.AUFNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == AUFK.MANDT`
Maintenance Plan Maintenance Plan Client	`C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEPLAN == MPLA.WARPL` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == MPLA.MANDT`
Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Revision for Plant Maintenance and Customer Service Client	`C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEREVISION == T352R.REVNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T352R.MANDT`
Plant Plant Plant Client	`C_MRPMAINTENANCEORDERCOMPONENT.MRPPLANT == T001W.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T001W.MANDT`
Priority Priority Priority ? Client	`C_MRPMAINTENANCEORDERCOMPONENT.PRIORITYCODE == T356.PRIOK` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTPRIORITYTYPE == T356.PRIOK` `C_MRPMAINTENANCEORDERCOMPONENT.[column in domain "ARTPR"] == T356.ARTPR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T356.MANDT`
Order Number Order Number Order Number Client	`C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEORDER == AUFK.AUFNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANUFACTURINGORDER == AUFK.AUFNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == AUFK.MANDT`
Material Number Material Number Client	`C_MRPMAINTENANCEORDERCOMPONENT.MATERIAL == MARA.MATNR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_MRPMAINTENANCEORDERCOMPONENT.MATERIALGROUP == T023.MATKL` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T023.MANDT`
Plant Plant Plant Client	`C_MRPMAINTENANCEORDERCOMPONENT.MRPPLANT == T001W.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T001W.MANDT`
Order Type Order Type Client	`C_MRPMAINTENANCEORDERCOMPONENT.ORDERTYPE == T003O.AUART` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T003O.CLIENT`
Priority Priority Priority ? Client	`C_MRPMAINTENANCEORDERCOMPONENT.PRIORITYCODE == T356.PRIOK` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTPRIORITYTYPE == T356.PRIOK` `C_MRPMAINTENANCEORDERCOMPONENT.[column in domain "ARTPR"] == T356.ARTPR` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T356.MANDT`
Purchasing Group for External Processing Activity Purchasing Group for External Processing Activity Client	`C_MRPMAINTENANCEORDERCOMPONENT.PURCHASINGGROUP == T024.EKGRP` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T024.MANDT`
Rounding Profile ? ? Rounding Profile Client	`C_MRPMAINTENANCEORDERCOMPONENT.[column in domain "RDZAE"] == RDPR.RDZAE` `C_MRPMAINTENANCEORDERCOMPONENT.[column in domain "WERKS_D"] == RDPR.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.ROUNDINGPROFILE == RDPR.RDPRF` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == RDPR.MANDT`
Storage location Storage location Plant Plant Client	`C_MRPMAINTENANCEORDERCOMPONENT.STORAGELOCATION == T001L.LGORT` `C_MRPMAINTENANCEORDERCOMPONENT.MRPPLANT == T001L.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEWORKCENTERPLANT == T001L.WERKS` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T001L.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_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_MRPMAINTENANCEORDERCOMPONENT.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_MRPMAINTENANCEORDERCOMPONENT.MANDT == T399I.MANDT`