C_ShpdAsPlndDelivItemsQry

Delivery Items Shipped as Planned | view: CSHPPLNDQRY | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: SCAL_TT_DATE, LIKP, LIPS, VBPA, VBPA, MARA, CVI_CUST_CT_LINK, BUT000, KNA1, TKUKL, TKUKT, CVI_CUST_LINK, TVLK, TVLKT, TPRIO, TPRIT, T001W, MARA, T023T, T023, MAKT, TVSB, TVSBT, TVST, TVSTT, LFA1, CVI_VEND_LINK, TTGR, TTGRT, T300, T300T, TVBST
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
GoodsMovementStatus Goods Movement Status (Item) Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
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
ForwardingAgent Account Number of Supplier LIFNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HundredInPercent null
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
DeliveryDocumentTypeName Description TEXT20
SupplierName Name of Supplier TEXT80
ReceivingPlantName Plant Name TEXT30
PlantName Plant Name TEXT30
SDDocumentCategoryName SD Document Category Description DDTEXT
ShippingConditionName Shipping Conditions Description TEXT20
ShippingPointName Description TEXT30
ShipToPartyName Name of Customer TEXT80
SoldToPartyName Name of Customer TEXT80
ProductName Product Description TEXT40
WarehouseName Warehouse Number Description TEXT25
GoodsMovementStatusDesc Status Description TEXT20
TransportationGroupName Description TEXT20
DeliveryPriorityDesc Description TEXT20
ProductGroupName Product Group Description TEXT20
CustomerClassificationDesc Customer Classification Description TEXT20
Master Data Relations Join Conditions
Customer Classification
  • Customer Classification
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TKUKL.MANDT
Delivery Type
  • Delivery Type
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TPRIO.MANDT
Plant
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.PLANT == T001W.WERKS
  • C_SHPDASPLNDDELIVITEMSQRY.RECEIVINGPLANT == T001W.WERKS
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.PRODUCT == MARA.MATNR
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.PRODUCTGROUP == T023.MATKL
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == T023.MANDT
Route
  • Client
  • Route
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TVRO.MANDT
  • C_SHPDASPLNDDELIVITEMSQRY.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
Receiving Plant for Deliveries
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.PLANT == T001W.WERKS
  • C_SHPDASPLNDDELIVITEMSQRY.RECEIVINGPLANT == T001W.WERKS
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == T001W.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.SHIPPINGCONDITION == TVSB.VSBED
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.SHIPPINGPOINT == TVST.VSTEL
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TVST.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.SHIPTOPARTY == KNA1.KUNNR
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.SOLDTOPARTY == KNA1.KUNNR
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == KNA1.MANDT
Transportation Group
  • Client
  • Transportation Group
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == TTGR.MANDT
  • C_SHPDASPLNDDELIVITEMSQRY.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_SHPDASPLNDDELIVITEMSQRY.WAREHOUSE == T300.LGNUM
  • C_SHPDASPLNDDELIVITEMSQRY.MANDT == T300.MANDT