I_ARunAnlytsOpenDelivCube

Open Deliveries - Cube | view: IARNALYSOPDLV | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: LIKP, LIPS, MARA, MARC, VBBE
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
DeliveredQuantityInBaseUnit null
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
Column Name Description Domain name
RequirementType null
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • Plant
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == MCHA.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.PRODUCT == MCHA.MATNR
  • I_ARUNANLYTSOPENDELIVCUBE.BATCH == MCHA.CHARG
  • I_ARUNANLYTSOPENDELIVCUBE.PLANT == MCHA.WERKS
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVLS.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Type
  • Client
  • Delivery Type
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVLK.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
Delivery Priority
  • Delivery Priority
  • Client
  • I_ARUNANLYTSOPENDELIVCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TPRIO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVTW.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TSPA.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.DIVISION == TSPA.SPART
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVFS.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Plant
  • Client
  • Plant
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == T001W.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == MARA.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == T023.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.PRODUCTGROUP == T023.MATKL
Sales District
  • Client
  • Sales District
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == T171.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SALESDISTRICT == T171.BZIRK
Sales office
  • Client
  • Sales office
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVBUR.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVKO.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == TVST.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Client
  • Ship-to Party
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == KNA1.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == KNA1.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Client
  • Storage location
  • Plant
  • I_ARUNANLYTSOPENDELIVCUBE.MANDT == T001L.MANDT
  • I_ARUNANLYTSOPENDELIVCUBE.STORAGELOCATION == T001L.LGORT
  • I_ARUNANLYTSOPENDELIVCUBE.PLANT == T001L.WERKS