C_PurchaseOrderItemPurgIssueQ

SOFM Purchase Order Item Purchasing Issue Query | view: CPURORDITMSU01Q | 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, TVAP, TVAPT, T000
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 SD Document Currency (SalesOrderTransactionCurrency):
SalesOrderItemNetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
SalesOrderItemQuantity 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
SuplrConfIsPending Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
DueDays null
SalesOrderItem Sales Order Item POSNR
SalesOrderItemCategoryName Description TEXT20
PurchasingDocumentItemText Short Text TEXT40
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_PURCHASEORDERITEMPURGISSUEQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TVKOV.MANDT
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORGANIZATION == TVKOV.VKORG
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == MARA.MANDT
  • C_PURCHASEORDERITEMPURGISSUEQ.MATERIAL == MARA.MATNR
Sales unit
  • Sales unit
  • Client
  • C_PURCHASEORDERITEMPURGISSUEQ.ORDERQUANTITYUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == T006.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • C_PURCHASEORDERITEMPURGISSUEQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_PURCHASEORDERITEMPURGISSUEQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TVTA.MANDT
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORGANIZATION == TVTA.VKORG
Plant
  • Client
  • Plant
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == T001W.MANDT
  • C_PURCHASEORDERITEMPURGISSUEQ.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PURCHASEORDERITEMPURGISSUEQ.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == T006.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TVPT.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORDERTRANSACTIONCURRENCY == TCURC.WAERS
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TCURC.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORDERTYPE == TVAK.AUART
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_PURCHASEORDERITEMPURGISSUEQ.MANDT == TVKO.MANDT
  • C_PURCHASEORDERITEMPURGISSUEQ.SALESORGANIZATION == TVKO.VKORG