I_SupDmndAllDocOpenDeliveries

View for Open Deliveries | view: ISUPDMNDADODLV | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: LIKP, LIPS, KNA1, VBBE, MARA, MARC
Column Name Description
Column Name Description
NetPriceAmount Net Price
Column Name Description
📏 Base Unit of Measure (BaseUnit):
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
SDDocumentCategory SD Document Category Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
RequirementDocumentNumber Sales Document VBELN
RequirementDocumentItem Sales Document Item POSNR
RequirementType null
DeliveryTimeInDays null
NumberOfDays null
RequirementSegment Requirement Segment SGT_SRCA
Batch Batch Number CHARG
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
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
  • Base Unit of Measure
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.BASEUNIT == T006.MSEHI
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == MARA.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == TVLK.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == TSPA.MANDT
  • I_SUPDMNDALLDOCOPENDELIVERIES.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == TCURC.MANDT
  • I_SUPDMNDALLDOCOPENDELIVERIES.DOCUMENTCURRENCY == TCURC.WAERS
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T148.MANDT
  • I_SUPDMNDALLDOCOPENDELIVERIES.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Material Number
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.MATERIAL == MARA.MATNR
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.MATERIALTYPE == T134.MTART
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T134.MANDT
Plant
  • Plant
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.PLANT == T001W.WERKS
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.SALESDISTRICT == T171.BZIRK
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.SALESORGANIZATION == TVKO.VKORG
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == TVKO.MANDT
Shipping Type
  • Shipping Type
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.SHIPPINGTYPE == T173.VSART
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T173.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.SOLDTOPARTY == KNA1.KUNNR
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == KNA1.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_SUPDMNDALLDOCOPENDELIVERIES.PLANT == T001L.WERKS
  • I_SUPDMNDALLDOCOPENDELIVERIES.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDALLDOCOPENDELIVERIES.MANDT == T001L.MANDT