C_ARunAnlytsOpenDelivQuery

Open Deliveries | view: CARNALYTSOPDLV | 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
RequirementSegment Requirement Segment
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVLS.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Type
  • Delivery Type
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TPRIO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVTW.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.DIVISION == TSPA.SPART
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TSPA.MANDT
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVFS.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Plant
  • Plant
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.PLANT == T001W.WERKS
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == MARA.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == T023.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.PRODUCTGROUP == T023.MATKL
Sales District
  • Sales District
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.SALESDISTRICT == T171.BZIRK
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == T171.MANDT
Sales office
  • Client
  • Sales office
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVBUR.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVKO.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == TVST.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Client
  • Ship-to Party
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == KNA1.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == KNA1.MANDT
  • C_ARUNANLYTSOPENDELIVQUERY.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Storage location
  • Plant
  • Client
  • C_ARUNANLYTSOPENDELIVQUERY.STORAGELOCATION == T001L.LGORT
  • C_ARUNANLYTSOPENDELIVQUERY.PLANT == T001L.WERKS
  • C_ARUNANLYTSOPENDELIVQUERY.MANDT == T001L.MANDT