I_MRPPurchaseOrder

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

Tables used: VBAP, EKKO, EKPO, EKKN, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, MARA, ADCP, ADRC, ADR6, TKA01, KNA1, MARA, MAKT, MARA, T001, T001K, T001W, PROJ, PROJ, CNLDST_SHORTTX, T024, T163, T163Y, EINE, T000, T006, T006A, PRPS, CNLDST_SHORTTX, MARC

🔑 Keys (3)
💰 Amounts
∑ Quantities (11)
📅 Dates (3)
☰ Categorical (3)
Other (30)
🔗 Relations (22)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchasing Document
ScheduleLine	Delivery Schedule Line Counter

Column Name	Description

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderItemQuantityUnit):
StandardPurchaseOrderQuantity	Standard Purchase Order Quantity
MaximumOrderQuantity	Maximum Purchase Order Quantity
MinimumOrderQuantity	Minimum Purchase Order Quantity
MaterialFixedLotSizeQuantity	Fixed lot size
MaterialMinLotSizeQuantity	Minimum Lot Size
MaterialMaxLotSizeQuantity	Maximum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity
PurchaseOrderItemQuantity	Purchase Order Quantity
ScheduleLineOrderQuantity	Scheduled Quantity
GoodsReceiptQuantity	Quantity of goods received
ScheduleLineOpenQuantity	null

Column Name	Description
ScheduleLineOrderDate	Order date of schedule line
DeliveryDate	Item delivery date
ProductAvailabilityDate	Material Staging/Availability Date

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
PartialDeliveryIsAllowed	Partial Delivery at Item Level (Stock Transfer)	Show values
IsOrderAcknRqd	Order Acknowledgment Requirement	Show values

Column Name	Description	Domain name
MRPElementItem	null
MaterialName	Material Description	TEXT40
MaterialProcurementCatName	Text for Item Category	TEXT20
MRPPlant	Plant	WERKS
SupplyingPlant	Supplying (issuing) plant in case of stock transport order	WERKS
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
SalesDocument	Sales and Distribution Document Number	VBELN
SalesDocumentItem	Sales Document Item	POSNR
SalesOrderItemMaterialName	Material Description	TEXT40
CustomerName	Name of Customer	TEXT80
CustomerFullName	Customer Full Name	TEXT220
PhoneNumber	First telephone no.: dialling code+number	CHAR30
EmailAddress	E-Mail Address	AD_SMTPADR
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
WBSElementDescription	Language-Dependent Short Text	TEXT40
ResponsiblePersonName	Name of responsible person (Project manager)	PS_VERNA
Project	Project definition	PS_PSPID
ProjectDescription	Project Definition Name	TEXT40
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingGroupPhoneNumber	null
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialGoodsReceiptDuration	Goods receipt processing time in days	DEC3
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
MaterialStagingTime	Staging Time in Days	WRF_PSCD_MST
PurchaseOrderRoundingProfile	Rounding Profile	RDPRF
QuickViewCategory	null
MRPElementCategory	null

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`I_MRPPURCHASEORDER.BASEUNIT == T006.MSEHI` `I_MRPPURCHASEORDER.MANDT == T006.MANDT`
Sold-to Party Sold-to Party Client	`I_MRPPURCHASEORDER.CUSTOMER == KNA1.KUNNR` `I_MRPPURCHASEORDER.MANDT == KNA1.MANDT`
Special Stock Indicator Special Stock Indicator Client	`I_MRPPURCHASEORDER.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ` `I_MRPPURCHASEORDER.MANDT == T148.MANDT`
Material Number Material Number Material Number Client	`I_MRPPURCHASEORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `I_MRPPURCHASEORDER.MATERIAL == MARA.MATNR` `I_MRPPURCHASEORDER.MANDT == MARA.MANDT`
Item category in purchasing document Item category in purchasing document Client	`I_MRPPURCHASEORDER.MATERIALPROCUREMENTCATEGORY == T163.PSTYP` `I_MRPPURCHASEORDER.MANDT == T163.MANDT`
Rounding Profile ? ? Client Rounding Profile	`I_MRPPURCHASEORDER.[column in domain "RDZAE"] == RDPR.RDZAE` `I_MRPPURCHASEORDER.[column in domain "WERKS_D"] == RDPR.WERKS` `I_MRPPURCHASEORDER.MANDT == RDPR.MANDT` `I_MRPPURCHASEORDER.MATERIALROUNDINGPROFILE == RDPR.RDPRF`
MRP controller MRP Controller Client ?	`I_MRPPURCHASEORDER.MRPCONTROLLER == T024D.DISPO` `I_MRPPURCHASEORDER.MANDT == T024D.MANDT` `I_MRPPURCHASEORDER.[column in domain "WERKS_D"] == T024D.WERKS`
Project Project (internal) Client	`I_MRPPURCHASEORDER.PROJECTINTERNALID == PROJ.PSPNR` `I_MRPPURCHASEORDER.MANDT == PROJ.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_MRPPURCHASEORDER.PURCHASEORDERITEMQUANTITYUNIT == T006.MSEHI` `I_MRPPURCHASEORDER.MANDT == T006.MANDT`
Purchasing Document Type Purchasing Document Type Purchasing Document Category Client	`I_MRPPURCHASEORDER.PURCHASINGDOCUMENTTYPE == T161.BSART` `I_MRPPURCHASEORDER.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `I_MRPPURCHASEORDER.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`I_MRPPURCHASEORDER.PURCHASINGGROUP == T024.EKGRP` `I_MRPPURCHASEORDER.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`I_MRPPURCHASEORDER.PURCHASINGINFORECORD == EINA.INFNR` `I_MRPPURCHASEORDER.MANDT == EINA.MANDT`
Purchasing organization Purchasing organization Client	`I_MRPPURCHASEORDER.PURCHASINGORGANIZATION == T024E.EKORG` `I_MRPPURCHASEORDER.MANDT == T024E.MANDT`
Project manager personnel number Responsible Person Number (Project Manager) Client	`I_MRPPURCHASEORDER.RESPONSIBLEPERSON == TCJ04.VERNR` `I_MRPPURCHASEORDER.MANDT == TCJ04.MANDT`
Order type in order header Sales Order Type Client	`I_MRPPURCHASEORDER.SALESDOCUMENTTYPE == TVAK.AUART` `I_MRPPURCHASEORDER.MANDT == TVAK.MANDT`
Material: order item Material Number Material Number Client	`I_MRPPURCHASEORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `I_MRPPURCHASEORDER.MATERIAL == MARA.MATNR` `I_MRPPURCHASEORDER.MANDT == MARA.MANDT`
Supplier Supplier Client	`I_MRPPURCHASEORDER.SUPPLIER == LFA1.LIFNR` `I_MRPPURCHASEORDER.MANDT == LFA1.MANDT`