I_ProductSalesDeliveryPOS

Product Sales Delivery POS core entity | view: IPRDSALESDELVPOS | Extraction: Not supported | Component: Material Master
Tables used: WLK2
Column Name Description
Product FK Material Number
ProductSalesOrg FK Sales organization in distribution chain, IS-R
ProductDistributionChnl FK Distribution channel in distribution chain, IS-R
Plant FK Retail plant
Column Name Description
Column Name Description
Column Name Description
StoreSaleStartDate Date from which sold in the store
StoreSaleEndDate Date to which sold in the store
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
Column Name Description
IsPointOfSalesDiscountAllowed Discount allowed Show values
ProdSlsDelivPOSIsPriceRequired Price required Show values
ProdSlsDelivRepeatKey No repeat key Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Retail plant
  • Client
  • Retail plant
  • I_PRODUCTSALESDELIVERYPOS.MANDT == T001W.MANDT
  • I_PRODUCTSALESDELIVERYPOS.PLANT == T001W.WERKS
Material Number
  • Material Number
  • Client
  • I_PRODUCTSALESDELIVERYPOS.PRODUCT == MARA.MATNR
  • I_PRODUCTSALESDELIVERYPOS.MANDT == MARA.MANDT
Distribution channel in distribution chain, IS-R
  • Distribution channel in distribution chain, IS-R
  • Client
  • I_PRODUCTSALESDELIVERYPOS.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
  • I_PRODUCTSALESDELIVERYPOS.MANDT == TVTW.MANDT
Sales organization in distribution chain, IS-R
  • Client
  • Sales organization in distribution chain, IS-R
  • I_PRODUCTSALESDELIVERYPOS.MANDT == TVKO.MANDT
  • I_PRODUCTSALESDELIVERYPOS.PRODUCTSALESORG == TVKO.VKORG
Distribution-chain-specific material status
  • Distribution-chain-specific material status
  • Client
  • I_PRODUCTSALESDELIVERYPOS.PRODUCTSALESSTATUS == TVMS.VMSTA
  • I_PRODUCTSALESDELIVERYPOS.MANDT == TVMS.MANDT
Foreign key for scales group
  • Scales group
  • Client
  • I_PRODUCTSALESDELIVERYPOS.SCALESGROUP == TWWAG.SCAGR
  • I_PRODUCTSALESDELIVERYPOS.MANDT == TWWAG.MANDT