I_ShpdAsPlndDelivItemsCube

Delivery Items Shipped as Planned - Cube | view: ISHPPLNDCUBE | 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
CreationDate Date on which the record was created
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 null
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_SHPDASPLNDDELIVITEMSCUBE.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TKUKL.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TPRIO.MANDT
Vendor - Document Vendor
  • Client
  • Account Number of Supplier
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == LFA1.MANDT
  • I_SHPDASPLNDDELIVITEMSCUBE.FORWARDINGAGENT == LFA1.LIFNR
Plant
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.PLANT == T001W.WERKS
  • I_SHPDASPLNDDELIVITEMSCUBE.RECEIVINGPLANT == T001W.WERKS
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.PRODUCT == MARA.MATNR
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == T023.MANDT
  • I_SHPDASPLNDDELIVITEMSCUBE.PRODUCTGROUP == T023.MATKL
Route
  • Client
  • Route
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TVRO.MANDT
  • I_SHPDASPLNDDELIVITEMSCUBE.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
Receiving Plant for Deliveries
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.PLANT == T001W.WERKS
  • I_SHPDASPLNDDELIVITEMSCUBE.RECEIVINGPLANT == T001W.WERKS
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == T001W.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TVSB.MANDT
  • I_SHPDASPLNDDELIVITEMSCUBE.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TVST.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.SOLDTOPARTY == KNA1.KUNNR
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == KNA1.MANDT
Transportation Group
  • Transportation Group
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_SHPDASPLNDDELIVITEMSCUBE.WAREHOUSE == T300.LGNUM
  • I_SHPDASPLNDDELIVITEMSCUBE.MANDT == T300.MANDT