C_MRPPurchaseOrder

MRP Purchase Order | view: CMRPPURCHORDER | 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, RDTX, T000, LFA1, T006, T006A, PRPS, CNLDST_SHORTTX, MARC

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

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):
ScheduleLineOpenQuantity	null
GoodsReceiptQuantity	Quantity of goods received
ScheduleLineOrderQuantity	Scheduled Quantity

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

Column Name	Description
MRPRequestStatus	Status of the Change Request	Show values

Column Name	Description	Domain name
MRPPlant	Plant	WERKS
MRPElementCategory	null
SupplierName	Name of Supplier	TEXT80
SupplierFullName	Supplier Full Name	TEXT220
SupplierPhoneNumber	First telephone number	TEXT16
EmailAddress	E-Mail Address	AD_SMTPADR
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingGroupPhoneNumber	null
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
MaterialProcurementCatName	Text for Item Category	TEXT20
MaterialGoodsReceiptDuration	Goods receipt processing time in days	DEC3
MaterialRoundingProfileName	Text, 40 Characters Long	TEXT40
CustomerName	Name of Customer	TEXT80
CustomerFullName	Customer Full Name	TEXT220
PhoneNumber	First telephone no.: dialling code+number	CHAR30
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
SalesDocument	Sales and Distribution Document Number	VBELN
SalesOrderItemMaterialName	Material Description	TEXT40

Master Data Relations	Join Conditions
Sold-to Party Sold-to Party Client	`C_MRPPURCHASEORDER.CUSTOMER == KNA1.KUNNR` `C_MRPPURCHASEORDER.MANDT == KNA1.MANDT`
Item category in purchasing document Item category in purchasing document Client	`C_MRPPURCHASEORDER.MATERIALPROCUREMENTCATEGORY == T163.PSTYP` `C_MRPPURCHASEORDER.MANDT == T163.MANDT`
Rounding Profile Rounding Profile ? ? Client	`C_MRPPURCHASEORDER.MATERIALROUNDINGPROFILE == RDPR.RDPRF` `C_MRPPURCHASEORDER.[column in domain "RDZAE"] == RDPR.RDZAE` `C_MRPPURCHASEORDER.[column in domain "WERKS_D"] == RDPR.WERKS` `C_MRPPURCHASEORDER.MANDT == RDPR.MANDT`
MRP controller ? MRP Controller Client	`C_MRPPURCHASEORDER.[column in domain "WERKS_D"] == T024D.WERKS` `C_MRPPURCHASEORDER.MRPCONTROLLER == T024D.DISPO` `C_MRPPURCHASEORDER.MANDT == T024D.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_MRPPURCHASEORDER.PURCHASEORDERITEMQUANTITYUNIT == T006.MSEHI` `C_MRPPURCHASEORDER.MANDT == T006.MANDT`
Purchasing Group Purchasing Group Client	`C_MRPPURCHASEORDER.PURCHASINGGROUP == T024.EKGRP` `C_MRPPURCHASEORDER.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_MRPPURCHASEORDER.PURCHASINGORGANIZATION == T024E.EKORG` `C_MRPPURCHASEORDER.MANDT == T024E.MANDT`
Project manager personnel number Client Responsible Person Number (Project Manager)	`C_MRPPURCHASEORDER.MANDT == TCJ04.MANDT` `C_MRPPURCHASEORDER.RESPONSIBLEPERSON == TCJ04.VERNR`
Material: order item Material Number Client	`C_MRPPURCHASEORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `C_MRPPURCHASEORDER.MANDT == MARA.MANDT`
Supplier Supplier Client	`C_MRPPURCHASEORDER.SUPPLIER == LFA1.LIFNR` `C_MRPPURCHASEORDER.MANDT == LFA1.MANDT`