C_PurOrdAvgDelivTime

Purchase Order Average Delivery Time | view: CMMPOAVGDLVT | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
GoodsReceiptQty null
Column Name Description
Column Name Description
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
DeliveryTime null
DeliveryItem null
WeightedDeliveryTime null
WeightedReceiptQuantity null
AverageDeliveryTime null
AverageWeightedDeliveryTime null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURORDAVGDELIVTIME.MANDT == T001.MANDT
  • C_PURORDAVGDELIVTIME.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • C_PURORDAVGDELIVTIME.MANDT == MARA.MANDT
  • C_PURORDAVGDELIVTIME.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURORDAVGDELIVTIME.MANDT == T023.MANDT
  • C_PURORDAVGDELIVTIME.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURORDAVGDELIVTIME.MANDT == T001W.MANDT
  • C_PURORDAVGDELIVTIME.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURORDAVGDELIVTIME.MANDT == T006.MANDT
  • C_PURORDAVGDELIVTIME.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURORDAVGDELIVTIME.MANDT == T024.MANDT
  • C_PURORDAVGDELIVTIME.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURORDAVGDELIVTIME.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURORDAVGDELIVTIME.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_PURORDAVGDELIVTIME.MANDT == LFA1.MANDT
  • C_PURORDAVGDELIVTIME.SUPPLIER == LFA1.LIFNR
Country/Region Key
  • Client
  • Country/Region Key
  • C_PURORDAVGDELIVTIME.MANDT == T005.MANDT
  • C_PURORDAVGDELIVTIME.SUPPLIERCOUNTRY == T005.LAND1