I_PurchaseOrderQuickView

Purchase Order Data | view: IPOQV | Extraction: Not supported | Component: Replenishment Planning & Execution
Tables used: VBAPEKKOEKPOEKKNEKETVBKDVEDAVBAKVBAKVBAPVBKDVEDAPRTEMARAADCPADRCADR6TKA01KNA1MARAMAKTT001WMARAT001T001KT001WPROJPROJCNLDST_SHORTTXT161TT024EINERDTXT000LFA1PRPSCNLDST_SHORTTXADR2ADR6ADRPT024DUSR02USR21MARC
Column Name Description
PurchasingDocument Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
ScheduleLine Delivery Schedule Line Counter
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderItemQuantityUnit):
OrderQuantity Purchase Order Quantity
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
ScheduleLineOpenQuantity null
MRPRelevantQuantity Quantity Reduced (MRP)
StockInTransitQuantity Quantity received or quantity required
MRPElementOpenQuantity Quantity received or quantity required
ScheduleLineIssuedQuantity Issued Quantity
StockTransferDeliveredQuantity Quantity Delivered (Stock Transfer)
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
Column Name Description
DeliveryDate Item delivery date
ProductAvailabilityDate Material Staging/Availability Date
ScheduleLineOrderDate Order date of schedule line
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level (Stock Transfer) Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
SupplierMaterialNumber Material Number Used by Supplier IDNEX
MRPPlant Plant WERKS
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
SupplyingPlantName Plant Name TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingGroupPhoneNumber null
PurchasingGroupEmailAddress E-Mail Address AD_SMTPADR
PlannedDeliveryDurationInDays Planned Delivery Time in Days DEC3
GoodsReceiptDurationInDays Goods receipt processing time in days DEC3
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
MRPControllerName Name of MRP controller TEXT18
InternalContactPersonName Full Name of Person TEXT80
MRPControllerPhoneNumber null
ContactPersonEmailAddress E-Mail Address AD_SMTPADR
SupplierName Name of Supplier TEXT80
SupplierFullName Supplier Full Name TEXT220
SupplierPhoneNumber First telephone number TEXT16
InternalContactEmailAddress E-Mail Address AD_SMTPADR
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
MaterialStagingTime Staging Time in Days WRF_PSCD_MST
MaterialRoundingProfileName Text, 40 Characters Long TEXT40
MRPElementCategory null
Master Data Relations Join Conditions
Sold-to Party
  • Client
  • Sold-to Party
  • I_PURCHASEORDERQUICKVIEW.MANDT == KNA1.MANDT
  • I_PURCHASEORDERQUICKVIEW.CUSTOMER == KNA1.KUNNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_PURCHASEORDERQUICKVIEW.MANDT == T148.MANDT
  • I_PURCHASEORDERQUICKVIEW.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Client
  • Material Number
  • Material Number
  • I_PURCHASEORDERQUICKVIEW.MANDT == MARA.MANDT
  • I_PURCHASEORDERQUICKVIEW.MATERIAL == MARA.MATNR
  • I_PURCHASEORDERQUICKVIEW.SALESORDERITEMMATERIAL == MARA.MATNR
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_PURCHASEORDERQUICKVIEW.MANDT == T163.MANDT
  • I_PURCHASEORDERQUICKVIEW.MATERIALPROCUREMENTCATEGORY == T163.PSTYP
Rounding Profile
  • Client
  • Rounding Profile
  • ?
  • ?
  • I_PURCHASEORDERQUICKVIEW.MANDT == RDPR.MANDT
  • I_PURCHASEORDERQUICKVIEW.MATERIALROUNDINGPROFILE == RDPR.RDPRF
  • I_PURCHASEORDERQUICKVIEW.[column in domain "RDZAE"] == RDPR.RDZAE
  • I_PURCHASEORDERQUICKVIEW.[column in domain "WERKS_D"] == RDPR.WERKS
MRP controller
  • Client
  • MRP Controller
  • ?
  • I_PURCHASEORDERQUICKVIEW.MANDT == T024D.MANDT
  • I_PURCHASEORDERQUICKVIEW.MRPCONTROLLER == T024D.DISPO
  • I_PURCHASEORDERQUICKVIEW.[column in domain "WERKS_D"] == T024D.WERKS
Project
  • Client
  • Project (internal)
  • I_PURCHASEORDERQUICKVIEW.MANDT == PROJ.MANDT
  • I_PURCHASEORDERQUICKVIEW.PROJECTINTERNALID == PROJ.PSPNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_PURCHASEORDERQUICKVIEW.MANDT == T006.MANDT
  • I_PURCHASEORDERQUICKVIEW.PURCHASEORDERITEMQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • I_PURCHASEORDERQUICKVIEW.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_PURCHASEORDERQUICKVIEW.MANDT == T161.MANDT
  • I_PURCHASEORDERQUICKVIEW.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_PURCHASEORDERQUICKVIEW.MANDT == T024.MANDT
  • I_PURCHASEORDERQUICKVIEW.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_PURCHASEORDERQUICKVIEW.MANDT == EINA.MANDT
  • I_PURCHASEORDERQUICKVIEW.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • I_PURCHASEORDERQUICKVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURCHASEORDERQUICKVIEW.MANDT == T024E.MANDT
Project manager personnel number
  • Client
  • Responsible Person Number (Project Manager)
  • I_PURCHASEORDERQUICKVIEW.MANDT == TCJ04.MANDT
  • I_PURCHASEORDERQUICKVIEW.RESPONSIBLEPERSON == TCJ04.VERNR
Order type in order header
  • Client
  • Sales Order Type
  • I_PURCHASEORDERQUICKVIEW.MANDT == TVAK.MANDT
  • I_PURCHASEORDERQUICKVIEW.SALESDOCUMENTTYPE == TVAK.AUART
Material: order item
  • Client
  • Material Number
  • Material Number
  • I_PURCHASEORDERQUICKVIEW.MANDT == MARA.MANDT
  • I_PURCHASEORDERQUICKVIEW.MATERIAL == MARA.MATNR
  • I_PURCHASEORDERQUICKVIEW.SALESORDERITEMMATERIAL == MARA.MATNR
Supplier
  • Supplier
  • Client
  • I_PURCHASEORDERQUICKVIEW.SUPPLIER == LFA1.LIFNR
  • I_PURCHASEORDERQUICKVIEW.MANDT == LFA1.MANDT