I_DelivItmPerfAnlytsCube

Cube for Dlv Perf - Shipped as Planned | view: IDLVSHAPCUBE | TRAN | 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
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
Column Name Description Domain name
HundredInPercent Hundred In Percent DEC3
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
YearWeek Year Week NUM6
NumberOfDeliveryItems Number of Delivery Items
NmbrOfShpdAsPlndDelivItems Number of Delivery Items Shipped as Planned
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
MaxGIToPlndGIDelayInDays Max. Delay of GI Compared to the Planned GI Date (Days)
Master Data Relations Join Conditions
Customer Classification
  • Customer Classification
  • Client
  • I_DELIVITMPERFANLYTSCUBE.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TKUKL.MANDT
Delivery Type
  • Client
  • Delivery Type
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TVLK.MANDT
  • I_DELIVITMPERFANLYTSCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
Delivery Priority
  • Delivery Priority
  • Client
  • I_DELIVITMPERFANLYTSCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TPRIO.MANDT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • I_DELIVITMPERFANLYTSCUBE.FORWARDINGAGENT == LFA1.LIFNR
  • I_DELIVITMPERFANLYTSCUBE.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • Product Number
  • I_DELIVITMPERFANLYTSCUBE.MANDT == MARA.MANDT
  • I_DELIVITMPERFANLYTSCUBE.MATERIAL == MARA.MATNR
  • I_DELIVITMPERFANLYTSCUBE.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Product Group
  • I_DELIVITMPERFANLYTSCUBE.MANDT == T023.MANDT
  • I_DELIVITMPERFANLYTSCUBE.MATERIALGROUP == T023.MATKL
  • I_DELIVITMPERFANLYTSCUBE.PRODUCTGROUP == T023.MATKL
Plant
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • I_DELIVITMPERFANLYTSCUBE.PLANT == T001W.WERKS
  • I_DELIVITMPERFANLYTSCUBE.RECEIVINGPLANT == T001W.WERKS
  • I_DELIVITMPERFANLYTSCUBE.MANDT == T001W.MANDT
Product Number
  • Client
  • Material Number
  • Product Number
  • I_DELIVITMPERFANLYTSCUBE.MANDT == MARA.MANDT
  • I_DELIVITMPERFANLYTSCUBE.MATERIAL == MARA.MATNR
  • I_DELIVITMPERFANLYTSCUBE.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • I_DELIVITMPERFANLYTSCUBE.MANDT == T023.MANDT
  • I_DELIVITMPERFANLYTSCUBE.MATERIALGROUP == T023.MATKL
  • I_DELIVITMPERFANLYTSCUBE.PRODUCTGROUP == T023.MATKL
Route
  • Route
  • Client
  • I_DELIVITMPERFANLYTSCUBE.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TVRO.MANDT
Receiving Plant for Deliveries
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • I_DELIVITMPERFANLYTSCUBE.PLANT == T001W.WERKS
  • I_DELIVITMPERFANLYTSCUBE.RECEIVINGPLANT == T001W.WERKS
  • I_DELIVITMPERFANLYTSCUBE.MANDT == T001W.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TVSB.MANDT
  • I_DELIVITMPERFANLYTSCUBE.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TVST.MANDT
  • I_DELIVITMPERFANLYTSCUBE.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Client
  • Ship-to Party
  • I_DELIVITMPERFANLYTSCUBE.MANDT == KNA1.MANDT
  • I_DELIVITMPERFANLYTSCUBE.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Sold-to Party
  • Client
  • I_DELIVITMPERFANLYTSCUBE.SOLDTOPARTY == KNA1.KUNNR
  • I_DELIVITMPERFANLYTSCUBE.MANDT == KNA1.MANDT
Transportation Group
  • Transportation Group
  • Client
  • I_DELIVITMPERFANLYTSCUBE.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_DELIVITMPERFANLYTSCUBE.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • I_DELIVITMPERFANLYTSCUBE.MANDT == T300.MANDT
  • I_DELIVITMPERFANLYTSCUBE.WAREHOUSE == T300.LGNUM