I_OrdItmDelivPerfAnlytsCube

Order Item Delivery Performance Cube | view: ILEORDIPERFCUBE | TRAN | Extraction: Not supported | Component: Delivery Document Analytical Apps
Column Name Description
OrderDocument FK Sales Order
OrderDocumentItem Order Item
Column Name Description
💲 SD Document Currency (DocumentCurrency):
IncomingSalesOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
DlvrdAsReqdSlsDocItmNetAmt Items Delivered as Requested Value in Transaction Currency
ShpdAsPlndSlsDocItmNetAmt Items Shipped as Planned Value in Transaction Currency
💲 Display Currency (DisplayCurrency):
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders Net Value In Display Currency
DlvrdAsReqdSlsDocItmNetAmtInDC Items Delivered as Requested Value in Display Currency
ShpdAsPlndSlsDocItmNetAmtInDC Items Shipped as Planned Value in Display Currency
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
OrdDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment Show values
Column Name Description Domain name
OrderDocumentItemInternalID null
StockTransportOrder Stock Transport Order EBELN
DocumentCategory Order Document Category
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
ReceivingPlant Plant WERKS
ExchangeRateType Exchange Rate Type KURST
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SalesOffice Sales office VKBUR
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
SalesOrderType Order Document Type AUART
SalesDocumentTypeName Order Document Type Text TEXT20
PurchaseOrderType Purchasing Document Type BSART
ForwardingAgent Forwarding Agent LIFNR
NmbrOfDlvrdAsReqdSlsDocItems Number of Sales Order Items Delivered as Requested
NmbrOfShippedAsPlndSlsDocItems Number of Sales Order Items Shipped as Planned
NumberOfIncomingSlsOrderItems Number of Incoming Sales Order Items
ReqdDelivDateYear Calendar Year NUM4
ReqdDelivDateYearQuarter Year Quarter NUM5
ReqdDelivDateYearMonth Year Month NUM6
ReqdDelivDateCalendarMonth Calendar Month NUM2
ReqdDelivDateYearWeek Year Week NUM6
CalendarWeek Calendar Week NUM2
PlndGIDateYear Year of Planned Goods Issue Date NUM4
PlndGIDateYearQuarter Quarter of Planned Goods Issue Date NUM5
PlndGIDateYearMonth Month of Planned Goods Issue Date NUM6
PlndGIDateYearWeek Week of Planned Goods Issue Date NUM6
DelivToReqdDelivDelayInDays Delay of Delivery Compared to Requested Deliv. Date (Days)
MaxDelivToReqdDelivDelayInDays Max. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
TotDelivToReqdDelivDelayInDays Tot. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
MaxGIToPlndGIDelayInDays Max. Delay of GI Compared to the Planned GI Date (Days)
TotGIToPlndGIDelayInDays Tot. Delay of GI Compared to the Planned GI Date (Days)
NrOfIncgOrdItemsCurYear Number of Incoming Sales Order Items
NrOfDlvrdAsReqdItemsCurYear Number of Sales Order Items Delivered as Requested
NrOfIncgOrdItemsCurQuarter Number of Incoming Sales Order Items
NrOfDlvrdAsReqdItemsCurQuarter Number of Sales Order Items Delivered as Requested
NrOfIncgOrdItemsCurMonth Number of Incoming Sales Order Items
NrOfDlvrdAsReqdItemsCurMonth Number of Sales Order Items Delivered as Requested
NrOfIncgOrdItemsCurWeek Number of Incoming Sales Order Items
NrOfDlvrdAsReqdItemsCurWeek Number of Sales Order Items Delivered as Requested
Master Data Relations Join Conditions
Delivery Priority
  • Delivery Priority
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TPRIO.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.DELIVERYTYPE == TVLK.LFART
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TVLK.MANDT
Division
  • Division
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.DIVISION == TSPA.SPART
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TSPA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TCURC.MANDT
  • I_ORDITMDELIVPERFANLYTSCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TINC.MANDT
Material: order item
  • Client
  • Material Number
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == MARA.MANDT
  • I_ORDITMDELIVPERFANLYTSCUBE.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.MATERIALGROUP == T023.MATKL
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == T023.MANDT
Plant
  • Plant
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.PRODUCTIONPLANT == T001W.WERKS
  • I_ORDITMDELIVPERFANLYTSCUBE.SUPPLYINGPLANT == T001W.WERKS
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == T001W.MANDT
Route
  • Client
  • Route
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TVRO.MANDT
  • I_ORDITMDELIVPERFANLYTSCUBE.ROUTE == TVRO.ROUTE
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.SHIPPINGCONDITION == TVSB.VSBED
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TVST.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TKUKL.MANDT
Transportation Group
  • Transportation Group
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_ORDITMDELIVPERFANLYTSCUBE.WAREHOUSENUMBER == T300.LGNUM
  • I_ORDITMDELIVPERFANLYTSCUBE.MANDT == T300.MANDT