C_DelivItmPerfAnlytsQry

Query for Dlv Perf - Shipped as Planned | view: CDLVSHAPQRY | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: SCAL_TT_DATE, LIKP, LIPS, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
OutboundDelivery FK Outbound Delivery
OutboundDeliveryItem Outbound Delivery Item
Column Name Description
Column Name Description
Column Name Description
PlannedGoodsIssueDate Planned Goods Movement Date
AdjustedPlannedGoodsIssueDate Adjusted PLanned GI Date
ActualGoodsMovementDate Actual Goods Movement Date
Column Name Description
Column Name Description Domain name
GoodsMovementStatus Goods Movement Status (Item)
CalendarYear Calendar Year
CalendarQuarter Calendar Quarter
CalendarMonth Calendar Month
CalendarWeek Calendar Week
YearMonth Year Month
YearQuarter Year Quarter
YearWeek Year Week
ForwardingAgent Account Number of Supplier
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
ReferenceSDDocumentCategory Document Category of Preceding SD Document
HundredInPercent Hundred In Percent DEC3
NumberOfDeliveryItems Number of Delivery Items
AvgGIToPlndGIDelayInDays Average Goods Issue Performance as Days of Delay
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
MaxGIToPlndGIDelayInDays Max. Delay of GI Compared to the Planned GI Date (Days)
DelivItemsShpdAsPlndRatio Ratio of Delivery Items Shipped as Planned
NmbrOfShpdAsPlndDelivItems Number of Delivery Items Shipped as Planned
Master Data Relations Join Conditions
Customer Classification
  • Customer Classification
  • Client
  • C_DELIVITMPERFANLYTSQRY.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_DELIVITMPERFANLYTSQRY.MANDT == TKUKL.MANDT
Delivery Type
  • Delivery Type
  • Client
  • C_DELIVITMPERFANLYTSQRY.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_DELIVITMPERFANLYTSQRY.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_DELIVITMPERFANLYTSQRY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_DELIVITMPERFANLYTSQRY.MANDT == TPRIO.MANDT
Plant
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • C_DELIVITMPERFANLYTSQRY.PLANT == T001W.WERKS
  • C_DELIVITMPERFANLYTSQRY.RECEIVINGPLANT == T001W.WERKS
  • C_DELIVITMPERFANLYTSQRY.MANDT == T001W.MANDT
Product Number
  • Client
  • Product Number
  • C_DELIVITMPERFANLYTSQRY.MANDT == MARA.MANDT
  • C_DELIVITMPERFANLYTSQRY.PRODUCT == MARA.MATNR
Product Group
  • Product Group
  • Client
  • C_DELIVITMPERFANLYTSQRY.PRODUCTGROUP == T023.MATKL
  • C_DELIVITMPERFANLYTSQRY.MANDT == T023.MANDT
Route
  • Client
  • Route
  • C_DELIVITMPERFANLYTSQRY.MANDT == TVRO.MANDT
  • C_DELIVITMPERFANLYTSQRY.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
Receiving Plant for Deliveries
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • C_DELIVITMPERFANLYTSQRY.PLANT == T001W.WERKS
  • C_DELIVITMPERFANLYTSQRY.RECEIVINGPLANT == T001W.WERKS
  • C_DELIVITMPERFANLYTSQRY.MANDT == T001W.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_DELIVITMPERFANLYTSQRY.MANDT == TVSB.MANDT
  • C_DELIVITMPERFANLYTSQRY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_DELIVITMPERFANLYTSQRY.MANDT == TVST.MANDT
  • C_DELIVITMPERFANLYTSQRY.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Ship-to Party
  • Client
  • C_DELIVITMPERFANLYTSQRY.SHIPTOPARTY == KNA1.KUNNR
  • C_DELIVITMPERFANLYTSQRY.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_DELIVITMPERFANLYTSQRY.SOLDTOPARTY == KNA1.KUNNR
  • C_DELIVITMPERFANLYTSQRY.MANDT == KNA1.MANDT
Transportation Group
  • Transportation Group
  • Client
  • C_DELIVITMPERFANLYTSQRY.TRANSPORTATIONGROUP == TTGR.TRAGR
  • C_DELIVITMPERFANLYTSQRY.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_DELIVITMPERFANLYTSQRY.WAREHOUSE == T300.LGNUM
  • C_DELIVITMPERFANLYTSQRY.MANDT == T300.MANDT