C_SupDmndOpenDelivQuery

Query View for Total Demand | view: CSDODMNDDLVQRY | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: LIKPLIPSTVTWTTSPATT023TMAKTT001WT171TTVKOTMARAMARCVBBE
Column Name Description
Column Name Description
Column Name Description
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
RequirementDocumentItem Item number of the reference item
DeliveryDocumentItem Delivery Item POSNR
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
SalesOrganizationName Sales Organization Description TEXT20
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SalesDistrictName Name of the district TEXT20
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Plant
  • Client
  • Material Number
  • C_SUPDMNDOPENDELIVQUERY.BATCH == MCHA.CHARG
  • C_SUPDMNDOPENDELIVQUERY.PLANT == MCHA.WERKS
  • C_SUPDMNDOPENDELIVQUERY.MANDT == MCHA.MANDT
  • C_SUPDMNDOPENDELIVQUERY.MATERIAL == MCHA.MATNR
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SUPDMNDOPENDELIVQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVLS.MANDT
Delivery Type
  • Delivery Type
  • Client
  • C_SUPDMNDOPENDELIVQUERY.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_SUPDMNDOPENDELIVQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TPRIO.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_SUPDMNDOPENDELIVQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TSPA.MANDT
  • C_SUPDMNDOPENDELIVQUERY.DIVISION == TSPA.SPART
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SUPDMNDOPENDELIVQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVFS.MANDT
Material Number
  • Client
  • Material Number
  • C_SUPDMNDOPENDELIVQUERY.MANDT == MARA.MANDT
  • C_SUPDMNDOPENDELIVQUERY.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_SUPDMNDOPENDELIVQUERY.MATERIALGROUP == T023.MATKL
  • C_SUPDMNDOPENDELIVQUERY.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_SUPDMNDOPENDELIVQUERY.PLANT == T001W.WERKS
  • C_SUPDMNDOPENDELIVQUERY.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDOPENDELIVQUERY.MANDT == T171.MANDT
Sales office
  • Sales office
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SALESOFFICE == TVBUR.VKBUR
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVBUR.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SHIPPINGPOINT == TVST.VSTEL
  • C_SUPDMNDOPENDELIVQUERY.MANDT == TVST.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_SUPDMNDOPENDELIVQUERY.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SUPDMNDOPENDELIVQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_SUPDMNDOPENDELIVQUERY.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • C_SUPDMNDOPENDELIVQUERY.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDOPENDELIVQUERY.PLANT == T001L.WERKS
  • C_SUPDMNDOPENDELIVQUERY.MANDT == T001L.MANDT