C_SupDmndAllDocGdsIssdDelivQ

Query View for Goods Issued Delivery | view: CSUPDMNDADGIDLVQ | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATELIKPLIPSSCAL_TT_WEEKKNA1MARAMARCT001KT001W
Column Name Description
RequirementDocumentNumber FK Delivery
RequirementDocumentItem Delivery Item
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType null
Column Name Description
Column Name Description
DeliveredQuantity Original Quantity of Delivery Item
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
PlannedGoodsIssueDate Planned Goods Movement Date
ActualGoodsMovementDate Actual Goods Movement Date
Column Name Description
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
ARunGIDelayTmeHrznCode null
SalesOrganization null
DistributionChannel null
Division null
SalesDistrict null
Customer null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T006.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T001.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.PLANT == T001W.WERKS
Shipping Type
  • Client
  • Shipping Type
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T173.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.SHIPPINGTYPE == T173.VSART
Storage location
  • Client
  • Plant
  • Storage location
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.MANDT == T001L.MANDT
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.PLANT == T001L.WERKS
  • C_SUPDMNDALLDOCGDSISSDDELIVQ.STORAGELOCATION == T001L.LGORT