I_MRPPurchaseRequisition

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

Tables used: VBAP, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EBKN, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, MARA, ADCP, ADRC, ADR6, FM01, MARA, MAKT, T001W, MARA, T001, T001K, T001W, PROJ, PROJ, CNLDST_SHORTTX, T024, EINA, T163, T163Y, EINE, LFA1, T001K, PRPS, CNLDST_SHORTTX, MARC, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts
∑ Quantities (10)
📅 Dates (2)
☰ Categorical (2)
Other (29)
🔗 Relations (21)

Column Name	Description
PurchaseRequisition	Purchase requisition number
PurchaseRequisitionItem	Item number of purchase requisition

Column Name	Description

Column Name	Description
📏 Purchase requisition unit of measure (PurchaseRequisitionUnit):
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
TotalQuantity	Purchase requisition quantity
OrderedQuantity	Quantity ordered against this purchase requisition
OpenQuantity	null

Column Name	Description
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
DeliveryDate	Item delivery date

Column Name	Description
PurchaseRequisitionIsFixed	Purchase requisition is fixed	Show values
ExternalApprovalStatus	External Processing Status	Show values

Column Name	Description	Domain name
MaterialName	Material Description	TEXT40
MaterialProcurementCatName	Text for Item Category	TEXT20
MRPPlant	Supplying (issuing) plant in case of stock transport order	WERKS
SupplyingPlant	Plant	WERKS
Supplier	Fixed Vendor	LIFNR
SupplierIsFixed	null
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialGoodsReceiptDuration	Goods receipt processing time in days	DEC3
SalesDocument	Sales and Distribution Document Number	VBELN
SalesDocumentItem	Sales Document Item	POSNR
SalesOrderItemMaterialName	Material Description	TEXT40
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
MaterialStagingTime	Staging Time in Days	WRF_PSCD_MST
PurchaseOrderRoundingProfile	Rounding Profile	RDPRF
SupplierName	Name of Supplier	TEXT80
SupplierFullName	Supplier Full Name	TEXT220
PhoneNumber1	First telephone number	TEXT16
EmailAddress	E-Mail Address	AD_SMTPADR
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
PurchasingGroupPhoneNumber	Telephone number of purchasing group (buyer group)	CHAR12
QuickViewCategory	null
MRPElementCategory	null

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