I_SupDmndAllDocOpenDelivC

Cube View for Open Delivery Details | view: ISUPDMNDADODLVC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATELIKPLIPSSCAL_TT_WEEKKNA1VBBEMARAMARCT001KT001W
Column Name Description
RequirementDocumentNumber Sales Document
RequirementDocumentItem Sales Document Item
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType null
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
DeliveredQuantity Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarMonthName Short Text for Fixed Values
CalendarWeek null
CalendarDay Calendar Day
ARunDelivDateTmeHrznCode null
ARunPlndGIDteTmeHrznCode null
ARunSupDlyHrznInWeeks null
SalesOrganization null
DistributionChannel null
Division null
SalesDistrict null
Customer null
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T006.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T001.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_SUPDMNDALLDOCOPENDELIVC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == MARA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == TCURC.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • I_SUPDMNDALLDOCOPENDELIVC.MATERIAL == MARA.MATNR
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T023.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.MATERIALGROUP == T023.MATKL
Material type
  • Material type
  • Client
  • I_SUPDMNDALLDOCOPENDELIVC.MATERIALTYPE == T134.MTART
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T134.MANDT
Plant
  • Client
  • Plant
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.PLANT == T001W.WERKS
Shipping Type
  • Client
  • Shipping Type
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T173.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.SHIPPINGTYPE == T173.VSART
Storage location
  • Storage location
  • Client
  • Plant
  • I_SUPDMNDALLDOCOPENDELIVC.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDALLDOCOPENDELIVC.MANDT == T001L.MANDT
  • I_SUPDMNDALLDOCOPENDELIVC.PLANT == T001L.WERKS