I_PurchaseOrderItemPurgIssue

SOFM Purchase Order Item Purchasing Issue | view: IPURORDITMSU01 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, EKKO, EKPO, EKKN, EKET, EKES, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, VBFA, EKKO, EKPO, TKA01, T001W, T000
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
PurchasingDocumentOrderQty Purchase Order Quantity
Column Name Description
DueDate null
DeliveryDate null
Column Name Description
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
DueDays null
SalesOrderItem Sales Order Item POSNR
PurchasingDocumentItemText Short Text TEXT40
PlantName Plant Name TEXT30
SuplrConfIsPending null
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.SALESORGANIZATION == TVKOV.VKORG
  • I_PURCHASEORDERITEMPURGISSUE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TVKOV.MANDT
Material Number
  • Material Number
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.MATERIAL == MARA.MATNR
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == MARA.MANDT
Sales unit
  • Sales unit
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.ORDERQUANTITYUNIT == T006.MSEHI
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == T006.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.SALESORGANIZATION == TVTA.VKORG
  • I_PURCHASEORDERITEMPURGISSUE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_PURCHASEORDERITEMPURGISSUE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TVTA.MANDT
Plant
  • Client
  • Plant
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == T001W.MANDT
  • I_PURCHASEORDERITEMPURGISSUE.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == T006.MANDT
Sales document item category
  • Client
  • Sales document item category
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TVPT.MANDT
  • I_PURCHASEORDERITEMPURGISSUE.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Document Type
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.SALESORDERTYPE == TVAK.AUART
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_PURCHASEORDERITEMPURGISSUE.SALESORGANIZATION == TVKO.VKORG
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TVKO.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_PURCHASEORDERITEMPURGISSUE.MANDT == TCURC.MANDT
  • I_PURCHASEORDERITEMPURGISSUE.TRANSACTIONCURRENCY == TCURC.WAERS