C_DelivPerfAnlytsCardQry

Delivery Performance Query for OVP Card | view: CDLVPERFPOVPQRY | Extraction: Not supported | Component: Delivery Document Analytical Apps
Column Name Description
OrderDocument FK Sales Order
OrderDocumentItem Order Item
OrderDocumentItemInternalID null
SalesOrder FK Sales Order
StockTransportOrder Stock Transport Order / Purchase Order
Column Name Description
Column Name Description
Column Name Description
EarliestReqdDelivDate Requested Delivery Date of Earliest Scheduled Delivery
EarliestPlndGIDate Planned Goods Issue Date of Earliest Scheduled Delivery
Column Name Description
Column Name Description Domain name
PurchasingGroup Purchasing Group EKGRP
PurchasingOrganization Purchasing organization EKORG
SalesOffice Sales office VKBUR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Plant Plant WERKS
ReceivingPlant Receiving Plant for Deliveries WERKS
ReqdDelivDateYear Calendar Year NUM4
ReqdDelivDateYearQuarter Year Quarter NUM5
ReqdDelivDateYearMonth Year Month NUM6
ReqdDelivDateCalendarMonth Calendar Month NUM2
ReqdDelivDateYearWeek Year Week NUM6
PlndGIDateYear Year of Planned Goods Issue Date NUM4
PlndGIDateYearQuarter Quarter of Planned Goods Issue Date NUM5
PlndGIDateYearWeek Week of Planned Goods Issue Date NUM6
NmbrOfDlvrdAsReqdOrderItems Number of Sales Order Items Delivered as Requested
NumberOfIncomingOrderItems Number of Incoming Sales Order Items
OrderItemsDlvrdAsReqdRatio Ratio of order items delivered as requested
DlvrdAsReqdRatioCurYear Ratio of order items delivered as requested (current year)
DlvrdAsReqdRatioCurQuarter Ratio of order items delivered as requested (cur quarter)
DlvrdAsReqdRatioCurMonth Ratio of order items delivered as requested (current month)
DlvrdAsReqdRatioCurWeek Ratio of order items delivered as requested (current Week)
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • C_DELIVPERFANLYTSCARDQRY.MANDT == TSPA.MANDT
  • C_DELIVPERFANLYTSCARDQRY.DIVISION == TSPA.SPART
Material: order item
  • Client
  • Material Number
  • C_DELIVPERFANLYTSCARDQRY.MANDT == MARA.MANDT
  • C_DELIVPERFANLYTSCARDQRY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_DELIVPERFANLYTSCARDQRY.MANDT == T023.MANDT
  • C_DELIVPERFANLYTSCARDQRY.MATERIALGROUP == T023.MATKL
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_DELIVPERFANLYTSCARDQRY.MANDT == TVST.MANDT
  • C_DELIVPERFANLYTSCARDQRY.SHIPPINGPOINT == TVST.VSTEL
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • C_DELIVPERFANLYTSCARDQRY.MANDT == T300.MANDT
  • C_DELIVPERFANLYTSCARDQRY.WAREHOUSENUMBER == T300.LGNUM