I_SupDmndAllDocRetDeliv

View for Return Deliveries | view: ISUPDMNDADRETDL | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: LIKPLIPSKNA1MARAMARC
Column Name Description
Column Name Description
NetPriceAmount Net Price
Column Name Description
TotalQuantity Actual quantity delivered (in sales units)
OpenSupplyQuantity null
Column Name Description
SupplyDeliveryDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
Column Name Description Domain name
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
AssignedSupplyType null
SupAssgmtSource null
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
Batch Batch Number CHARG
StorageLocation Storage location LGORT
StockSegment Stock Segment SGT_SRCA
Supplier Vendor's account number LIFNR
CompanyCode Company Code BUKRS
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDALLDOCRETDELIV.MANDT == T006.MANDT
  • I_SUPDMNDALLDOCRETDELIV.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCRETDELIV.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCRETDELIV.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Ship-to Party
  • Ship-to Party
  • Client
  • I_SUPDMNDALLDOCRETDELIV.CUSTOMER == KNA1.KUNNR
  • I_SUPDMNDALLDOCRETDELIV.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDALLDOCRETDELIV.MANDT == TCURC.MANDT
  • I_SUPDMNDALLDOCRETDELIV.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_SUPDMNDALLDOCRETDELIV.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCRETDELIV.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDALLDOCRETDELIV.MANDT == T023.MANDT
  • I_SUPDMNDALLDOCRETDELIV.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • I_SUPDMNDALLDOCRETDELIV.MANDT == T134.MANDT
  • I_SUPDMNDALLDOCRETDELIV.MATERIALTYPE == T134.MTART
Delivery Type
  • Client
  • Delivery Type
  • I_SUPDMNDALLDOCRETDELIV.MANDT == TVLK.MANDT
  • I_SUPDMNDALLDOCRETDELIV.ORDERTYPE == TVLK.LFART
Plant
  • Client
  • Plant
  • I_SUPDMNDALLDOCRETDELIV.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCRETDELIV.PLANT == T001W.WERKS
Sales District
  • Client
  • Sales District
  • I_SUPDMNDALLDOCRETDELIV.MANDT == T171.MANDT
  • I_SUPDMNDALLDOCRETDELIV.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_SUPDMNDALLDOCRETDELIV.MANDT == TVKO.MANDT
  • I_SUPDMNDALLDOCRETDELIV.SALESORGANIZATION == TVKO.VKORG