C_SupDmndAllDocRetDelivQ

Query View for Return Deliveries Details | view: CSUPDMNDADRETDLQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Material Number
Plant FK Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Material Staging/Availability Date
AssignedSupplyType null
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
TotalQuantity Actual quantity delivered (in sales units)
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
Column Name Description Domain name
SupAssgmtSource null
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
SalesOrganization null
SalesDistrict null
Customer null
PurchasingOrganization null
PurchasingGroup Purchasing Group EKGRP
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SUPDMNDALLDOCRETDELIVQ.BASEUNIT == T006.MSEHI
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == T006.MANDT
Company code
  • Client
  • Company Code
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == T001.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == TVTW.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == TSPA.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == TCURC.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCRETDELIVQ.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCRETDELIVQ.PLANT == T001W.WERKS