C_ProdnPlngPurReqnQuickView

Purchase Requisition Details | view: CPURREQQV | Extraction: Not supported | Component: Replenishment Planning & Execution

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, MARM, PROJ, PROJ, CNLDST_SHORTTX, T161T, T024, EINA, T163, T163Y, EINE, RDTX, LFA1, T001K, PRPS, CNLDST_SHORTTX, ADR2, ADR6, ADRP, T024D, USR02, USR21, MARC, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

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

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
MinimumPurchaseOrderQuantity	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
ReleaseDate	Purchase Requisition Release Date
DeliveryDate	Item delivery date

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
PurchaseRequisitionIsFixed	Purchase requisition is fixed	Show values

Column Name	Description	Domain name
MaterialName	Material Description	TEXT40
MRPPlant	Supplying (issuing) plant in case of stock transport order	WERKS
MaterialProcurementCatName	Text for Item Category	TEXT20
SupplyingPlant	Plant	WERKS
SupplyingPlantName	Plant Name	TEXT30
MRPControllerName	Name of MRP controller	TEXT18
InternalContactPersonName	Full Name of Person	TEXT80
MRPControllerPhoneNumber	null
ContactPersonEmailAddress	E-Mail Address	AD_SMTPADR
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
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
PartnerWBSElement	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
MaterialRoundingProfileName	Text, 40 Characters Long	TEXT40
Supplier	Desired Vendor	LIFNR
SupplierName	Name of Supplier	TEXT80
SupplierFullName	Supplier Full Name	TEXT220
SupplierPhoneNumber	First telephone number	TEXT16
EmailAddress	E-Mail Address	AD_SMTPADR
SupplierIsFixed	null
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingGroupPhoneNumber	Telephone number of purchasing group (buyer group)	CHAR12
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion to Base Units of Measure	UMBSZ
OrderItemQtyToBaseQtyDnmntr	Denominator for conversion to base units of measure	UMBSN
MRPElementCategory	null

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