C_MRPOrderComponent

Mfg Component and Maint Component | view: CMRPORDERCOMP | Extraction: Not supported | Component: Fiori UI for Production Planning and Control

Tables used: VBAP, AFKO, AFIH, RESB, AFVC, AFVV, AFPO, VBKD, VEDA, VBAK, PRTE, MATDOC_EXTRACT, MARA, AUFK, RSADD, RSDB, MAKT, T024D, ADR6, USR21, T003O, T003P, MKAL, T001, T001K, T001W, PROJ, CNLDST_SHORTTX, PRPS, CRHD, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, MKAL_AEND, T024I, /SAPSLL/TUNOS, TCS03

🔑 Keys (3)
💰 Amounts
∑ Quantities (12)
📅 Dates (9)
☰ Categorical (3)
Other (41)
🔗 Relations (12)

Column Name	Description
Reservation	Number of reservation/dependent requirements
ReservationItem	Reservation Item
RecordType	Reservation Record Type

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
OrderedQuantity	Requirement Quantity
WithdrawnQuantity	Withdrawn Quantity
OpenQuantity	null
CommittedQuantity	Available Quantity
OrderPlannedTotalQty	Manufacturing Order Planned Total Quantity
OrderPlannedScrapQty	Manufacturing Order Planned Scrap Quantity
ExpectedDeviationQuantity	Expected Yield Deviation
GoodsReceiptQty	Quantity of Goods Received for the Order Item
FixedLotSizeQuantity	Fixed lot size
MinimumLotSizeQuantity	Minimum Lot Size
MaximumLotSizeQuantity	Maximum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity

Column Name	Description
RequirementDate	Material Component Requirement Date
PlannedStartDate	Manufacturing Order Planned Start Date
OrderPlannedEndDate	Manufacturing Order Planned End Date
ActualStartDate	Manufacturing Order Actual Start Date
ActualEndDate	Manufacturing Order Actual End Date
ActualReleasedDate	Manufacturing Order Actual Release Date
ScheduledBasicStartDate	Manufacturing Order Scheduled Start Date
ScheduledBasicEndDate	Manufacturing Order Scheduled End Date
ScheduledReleaseDate	Manufacturing Order Scheduled Release Date

Column Name	Description
RequirementType	Requirement Type	Show values
MaterialProcurementCategory	Procurement Type	Show values
OrderCategory	Manufacturing Order Category	Show values

Column Name	Description	Domain name
MaterialName	Material Description	TEXT40
SupplyingPlant	null
MaterialProcurementType	Special procurement type	SOBSL
OrderType	Manufacturing Order Type	AUFART
PriorityCode	Order Importance Code	CHAR1
PlannedOrder	Planned Order	PLNUM
ProductionPlant	Production Plant	WERKS
MRPController	MRP Controller of Assembly Material	DISPO
MRPControllerName	Name of MRP controller	TEXT18
MRPControllerPhoneNumber	MRP Controller's Phone Number	CHAR12
EmailAddress	E-Mail Address	AD_SMTPADR
ProductionSupervisor	Production Supervisor	FEVOR
ProductionVersion	Production Version	VERID
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
TopLevelOrder	null
TopLevelOrderMaterial	null
MaterialGoodsReceiptDuration	Goods receipt processing time in days	DEC3
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialPlannedProductionDurn	null
MaterialReplenishmentLeadDurn	Total replenishment lead time (in workdays)	DEC3
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales Order Item	POSNR
WBSElementInternalID	Work Breakdown Structure Element Internal ID	PS_POSNR
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
ResponsiblePersonName	Name of responsible person (Project manager)	PS_VERNA
ProjectInternalID	Project (internal)	PS_S4_PROJ_PSPNR
ProjectDescription	Project Definition Name	TEXT40
Project	Project definition	PS_PSPID
TotalReplenishmentLeadDuration	Total replenishment lead time (in workdays)	DEC3
MaintPriorityType	null
MaintenancePlanningPlant	null
MaintenancePlannerGroup	null
MaintenanceRevision	null
MaintenancePlan	null
MaintenanceNotification	null
MaintenanceWorkCenter	null
MaintenanceWorkCenterPlant	null
ActivityType	null
MaintenancePlannerGroupName	null

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_MRPORDERCOMPONENT.BASEUNIT == T006.MSEHI` `C_MRPORDERCOMPONENT.MANDT == T006.MANDT`
Sold-to Party Sold-to Party Client	`C_MRPORDERCOMPONENT.CUSTOMER == KNA1.KUNNR` `C_MRPORDERCOMPONENT.MANDT == KNA1.MANDT`
Inventory Special Stock Type Inventory Special Stock Type Client	`C_MRPORDERCOMPONENT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ` `C_MRPORDERCOMPONENT.MANDT == T148.MANDT`
Manufacturing Order ID Manufacturing Order ID Client	`C_MRPORDERCOMPONENT.MANUFACTURINGORDER == AUFK.AUFNR` `C_MRPORDERCOMPONENT.MANDT == AUFK.MANDT`
Material Number Client Material Number Material Number	`C_MRPORDERCOMPONENT.MANDT == MARA.MANDT` `C_MRPORDERCOMPONENT.SALESORDERITEMMATERIAL == MARA.MATNR` `C_MRPORDERCOMPONENT.MATERIAL == MARA.MATNR`
Plant Client Plant Production Plant	`C_MRPORDERCOMPONENT.MANDT == T001W.MANDT` `C_MRPORDERCOMPONENT.MRPPLANT == T001W.WERKS` `C_MRPORDERCOMPONENT.PRODUCTIONPLANT == T001W.WERKS`
Purchasing Group Client Purchasing Group	`C_MRPORDERCOMPONENT.MANDT == T024.MANDT` `C_MRPORDERCOMPONENT.PURCHASINGGROUP == T024.EKGRP`
Project manager personnel number Client Responsible Person Number (Project Manager)	`C_MRPORDERCOMPONENT.MANDT == TCJ04.MANDT` `C_MRPORDERCOMPONENT.RESPONSIBLEPERSON == TCJ04.VERNR`
Rounding Profile ? ? Client Rounding Profile	`C_MRPORDERCOMPONENT.[column in domain "RDZAE"] == RDPR.RDZAE` `C_MRPORDERCOMPONENT.[column in domain "WERKS_D"] == RDPR.WERKS` `C_MRPORDERCOMPONENT.MANDT == RDPR.MANDT` `C_MRPORDERCOMPONENT.ROUNDINGPROFILE == RDPR.RDPRF`
Material: order item Client Material Number Material Number	`C_MRPORDERCOMPONENT.MANDT == MARA.MANDT` `C_MRPORDERCOMPONENT.SALESORDERITEMMATERIAL == MARA.MATNR` `C_MRPORDERCOMPONENT.MATERIAL == MARA.MATNR`
Order type in order header Sales Order Type Manufacturing Order Type Client	`C_MRPORDERCOMPONENT.SALESORDERTYPE == TVAK.AUART` `C_MRPORDERCOMPONENT.ORDERTYPE == TVAK.AUART` `C_MRPORDERCOMPONENT.MANDT == TVAK.MANDT`
Vendor Client Account Number of Supplier	`C_MRPORDERCOMPONENT.MANDT == LFA1.MANDT` `C_MRPORDERCOMPONENT.SUPPLIER == LFA1.LIFNR`