I_SupDmndOpenDelivCube

Open Deliveries Cube View | view: ISDOOVWDLVCUBE | TRAN | Extraction: Full only | Component: Order Allocation Run
Tables used: LIKP, LIPS, MARA, MARC, VBBE
Column Name Description
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
RequirementDocumentNumber Document number of the reference document VBELN
RequirementDocumentItem Item number of the reference item POSNR
RequirementType null
DeliveryDocumentItem Delivery Item POSNR
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Plant
  • Client
  • I_SUPDMNDOPENDELIVCUBE.BATCH == MCHA.CHARG
  • I_SUPDMNDOPENDELIVCUBE.MATERIAL == MCHA.MATNR
  • I_SUPDMNDOPENDELIVCUBE.PLANT == MCHA.WERKS
  • I_SUPDMNDOPENDELIVCUBE.MANDT == MCHA.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_SUPDMNDOPENDELIVCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVLS.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_SUPDMNDOPENDELIVCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_SUPDMNDOPENDELIVCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TPRIO.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_SUPDMNDOPENDELIVCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TSPA.MANDT
  • I_SUPDMNDOPENDELIVCUBE.DIVISION == TSPA.SPART
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_SUPDMNDOPENDELIVCUBE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVFS.MANDT
Material Number
  • Material Number
  • Client
  • I_SUPDMNDOPENDELIVCUBE.MATERIAL == MARA.MATNR
  • I_SUPDMNDOPENDELIVCUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SUPDMNDOPENDELIVCUBE.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDOPENDELIVCUBE.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • I_SUPDMNDOPENDELIVCUBE.PLANT == T001W.WERKS
  • I_SUPDMNDOPENDELIVCUBE.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • I_SUPDMNDOPENDELIVCUBE.SALESDISTRICT == T171.BZIRK
  • I_SUPDMNDOPENDELIVCUBE.MANDT == T171.MANDT
Sales office
  • Client
  • Sales office
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVBUR.MANDT
  • I_SUPDMNDOPENDELIVCUBE.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Sales Organization
  • Client
  • I_SUPDMNDOPENDELIVCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SUPDMNDOPENDELIVCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_SUPDMNDOPENDELIVCUBE.MANDT == TVST.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_SUPDMNDOPENDELIVCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_SUPDMNDOPENDELIVCUBE.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SUPDMNDOPENDELIVCUBE.SOLDTOPARTY == KNA1.KUNNR
  • I_SUPDMNDOPENDELIVCUBE.MANDT == KNA1.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_SUPDMNDOPENDELIVCUBE.PLANT == T001L.WERKS
  • I_SUPDMNDOPENDELIVCUBE.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDOPENDELIVCUBE.MANDT == T001L.MANDT