I_MRPPlannedOrder

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

Tables used: VBAP, EKKO, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, MARA, KNA1, MARA, MAKT, PLAF, MARA, MKAL, T001, T001K, T001W, PROJ, PROJ, CNLDST_SHORTTX, T024, T024E, TVAK, TVAKT, LFA1, PRPS, MKAL_AEND, MKAL_AEND, MARC

🔑 Keys (1)
💰 Amounts
∑ Quantities (8)
📅 Dates (3)
☰ Categorical (4)
Other (32)
🔗 Relations (19)

Column Name	Description
PlannedOrder	Planned Order

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
PlndOrderPlannedTotalQty	Planned Total Order Quantity
PlndOrderPlannedScrapQty	Planned Scrap Quantity
GoodsReceiptQuantity	Quantity of Goods Received
MaterialFixedLotSizeQuantity	Fixed lot size
MaterialMinLotSizeQuantity	Minimum Lot Size
MaterialMaxLotSizeQuantity	Maximum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity
PlndOrderPlannedOpenQty	null

Column Name	Description
PlannedOrderOpeningDate	Planned Opening Date in Planned Order
PlndOrderPlannedStartDate	Planned Order Start Date
PlndOrderPlannedEndDate	Planned Order End Date

Column Name	Description
PlannedOrderType	Planned Order Type	Show values
MaterialProcurementCategory	Material Procurement Category	Show values
MaterialProcurementType	Material Procurement Type	Show values
IsPlannedWithoutFinalAssembly	Indicator: Planning Without Final Assembly	Show values

Column Name	Description	Domain name
PlannedOrderTypeName	Planned Order Type Name	TEXT60
SupplierIsFixed	null
MaterialName	Material Description	TEXT40
SupplierName	Supplier Full Name	TEXT220
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingGroupPhoneNumber	Telephone no.: dialling code+number	CHAR30
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales Order Item	POSNR
SalesOrderType	Sales Order Type	AUART
SalesOrderTypeName	Sales Document Type Description	TEXT20
SalesOrderItemMaterialName	Material Description	TEXT40
Customer	Customer Number	KUNNR
CustomerName	Name of Customer	TEXT80
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
Project	Project definition	PS_PSPID
ProjectDescription	Project Definition Name	TEXT40
MaterialProcurementCatName	Material Procurement Category Name	DDTEXT
MaterialGoodsReceiptDuration	Material Goods Receipt Duration in Days	DEC3
SettlementReservation	Settlement Reservation	RSNUM
MRPElementIsEditable	null
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialPlannedProductionDurn	In-house production time	DEC3
TotalReplenishmentLeadDuration	Total replenishment lead time (in workdays)	DEC3
QuickViewCategory	null
MRPElementCategory	null

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`I_MRPPLANNEDORDER.MANDT == T006.MANDT` `I_MRPPLANNEDORDER.BASEUNIT == T006.MSEHI`
Inventory Special Stock Type Inventory Special Stock Type Client	`I_MRPPLANNEDORDER.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ` `I_MRPPLANNEDORDER.MANDT == T148.MANDT`
Material Client Planning material Product Number Material Number	`I_MRPPLANNEDORDER.MANDT == MARA.MANDT` `I_MRPPLANNEDORDER.MATERIAL == MARA.MATNR` `I_MRPPLANNEDORDER.PRODUCT == MARA.MATNR` `I_MRPPLANNEDORDER.SALESORDERITEMMATERIAL == MARA.MATNR`
Rounding Profile ? ? Client Rounding Profile	`I_MRPPLANNEDORDER.[column in domain "RDZAE"] == RDPR.RDZAE` `I_MRPPLANNEDORDER.[column in domain "WERKS_D"] == RDPR.WERKS` `I_MRPPLANNEDORDER.MANDT == RDPR.MANDT` `I_MRPPLANNEDORDER.MATERIALROUNDINGPROFILE == RDPR.RDPRF`
MRP Area MRP Area Client	`I_MRPPLANNEDORDER.MRPAREA == MDLV.BERID` `I_MRPPLANNEDORDER.MANDT == MDLV.MANDT`
MRP Controller Planning Plant MRP Controller Client	`I_MRPPLANNEDORDER.MRPPLANT == T024D.WERKS` `I_MRPPLANNEDORDER.MRPCONTROLLER == T024D.DISPO` `I_MRPPLANNEDORDER.MANDT == T024D.MANDT`
Plant Planning Plant Client	`I_MRPPLANNEDORDER.MRPPLANT == T001W.WERKS` `I_MRPPLANNEDORDER.MANDT == T001W.MANDT`
Plant Plant Client	`I_MRPPLANNEDORDER.PLANT == T001W.WERKS` `I_MRPPLANNEDORDER.MANDT == T001W.MANDT`
Material Client Planning material Product Number Material Number	`I_MRPPLANNEDORDER.MANDT == MARA.MANDT` `I_MRPPLANNEDORDER.MATERIAL == MARA.MATNR` `I_MRPPLANNEDORDER.PRODUCT == MARA.MATNR` `I_MRPPLANNEDORDER.SALESORDERITEMMATERIAL == MARA.MATNR`
Plant Production Plant Production Plant Client	`I_MRPPLANNEDORDER.SUPPLYINGPLANT == T001W.WERKS` `I_MRPPLANNEDORDER.PRODUCTIONPLANT == T001W.WERKS` `I_MRPPLANNEDORDER.MANDT == T001W.MANDT`
Planner Group (Routing) Production Supervisor Production Plant Production Plant Client	`I_MRPPLANNEDORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR` `I_MRPPLANNEDORDER.SUPPLYINGPLANT == T024F.WERKS` `I_MRPPLANNEDORDER.PRODUCTIONPLANT == T024F.WERKS` `I_MRPPLANNEDORDER.MANDT == T024F.MANDT`
Production Version Production Plant Production Plant Production Version Client Planning material Product Number Material Number	`I_MRPPLANNEDORDER.SUPPLYINGPLANT == MKAL.WERKS` `I_MRPPLANNEDORDER.PRODUCTIONPLANT == MKAL.WERKS` `I_MRPPLANNEDORDER.PRODUCTIONVERSION == MKAL.VERID` `I_MRPPLANNEDORDER.MANDT == MKAL.MANDT` `I_MRPPLANNEDORDER.MATERIAL == MKAL.MATNR` `I_MRPPLANNEDORDER.PRODUCT == MKAL.MATNR` `I_MRPPLANNEDORDER.SALESORDERITEMMATERIAL == MKAL.MATNR`
Project Client Project (internal)	`I_MRPPLANNEDORDER.MANDT == PROJ.MANDT` `I_MRPPLANNEDORDER.PROJECTINTERNALID == PROJ.PSPNR`
Purchasing Group Purchasing Group Client	`I_MRPPLANNEDORDER.PURCHASINGGROUP == T024.EKGRP` `I_MRPPLANNEDORDER.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`I_MRPPLANNEDORDER.PURCHASINGORGANIZATION == T024E.EKORG` `I_MRPPLANNEDORDER.MANDT == T024E.MANDT`
Project manager personnel number Client Responsible Person Number (Project Manager)	`I_MRPPLANNEDORDER.MANDT == TCJ04.MANDT` `I_MRPPLANNEDORDER.RESPONSIBLEPERSON == TCJ04.VERNR`
Material: order item Client Planning material Product Number Material Number	`I_MRPPLANNEDORDER.MANDT == MARA.MANDT` `I_MRPPLANNEDORDER.MATERIAL == MARA.MATNR` `I_MRPPLANNEDORDER.PRODUCT == MARA.MATNR` `I_MRPPLANNEDORDER.SALESORDERITEMMATERIAL == MARA.MATNR`
Fixed Vendor Fixed Vendor Client	`I_MRPPLANNEDORDER.SUPPLIER == LFA1.LIFNR` `I_MRPPLANNEDORDER.MANDT == LFA1.MANDT`
Plant Production Plant Production Plant Client	`I_MRPPLANNEDORDER.SUPPLYINGPLANT == T001W.WERKS` `I_MRPPLANNEDORDER.PRODUCTIONPLANT == T001W.WERKS` `I_MRPPLANNEDORDER.MANDT == T001W.MANDT`