I_ProductRetail

Product Retail Basic Data | view: IPRDRETAIL | ATTR | Extraction: Full or Incremental | Component: Material Master
Tables used: MAW1
Column Name Description
Product FK Product Number
Column Name Description
Column Name Description
Column Name Description
StoreListingStartDate Date from which listed in the store
StoreListingEndDate Date to which listed in the store
DistrCntrListingStartDate Date from which listed in the distribution center
DistrCntrListingEndDate Date to which listed in the central warehouse/distr. center
StoreSaleStartDate Date from which sold in the store
StoreSaleEndDate Date to which sold in the store
DistrCntrSaleStartDate Date from which sold in the distribution center
DistrCntrSaleEndDate Date to which sold in the distribution center
Column Name Description
Column Name Description Domain name
ValuationMargin Valuation margin PRZ32V
Master Data Relations Join Conditions
Assortment grade
  • Client
  • Assortment grade
  • I_PRODUCTRETAIL.MANDT == TWSS.MANDT
  • I_PRODUCTRETAIL.ASSORTMENTGRADE == TWSS.SSTUF
Assortment List Type
  • Assortment List Type
  • Client
  • I_PRODUCTRETAIL.ASSORTMENTLISTTYPE == TWBB.BBTYP
  • I_PRODUCTRETAIL.MANDT == TWBB.MANDT
Unit of measure for commodity code (foreign trade)
  • Unit of measure for commodity code (foreign trade)
  • Client
  • I_PRODUCTRETAIL.COMMODITIYCODENUMBERUNIT == T006.MSEHI
  • I_PRODUCTRETAIL.MANDT == T006.MANDT
Commodity Code
  • ?
  • Commodity Code
  • Client
  • I_PRODUCTRETAIL.[column in domain "LAND1"] == T604.LAND1
  • I_PRODUCTRETAIL.COMMODITYCODE == T604.STAWN
  • I_PRODUCTRETAIL.MANDT == T604.MANDT
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • I_PRODUCTRETAIL.CONSUMPTIONVALUECATEGORY == TMABC.MAABC
  • I_PRODUCTRETAIL.MANDT == TMABC.MANDT
Country/Region of Origin of Product
  • Country/Region of Origin of Product
  • Client
  • I_PRODUCTRETAIL.COUNTRYOFORIGIN == T005.LAND1
  • I_PRODUCTRETAIL.MANDT == T005.MANDT
Listing procedure for the distribution center
  • Listing procedure for distr. center assortment categories
  • Client
  • I_PRODUCTRETAIL.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL
  • I_PRODUCTRETAIL.MANDT == TWLV.MANDT
Unit of issue
  • Unit of issue
  • Client
  • I_PRODUCTRETAIL.GOODSISSUEUNIT == T006.MSEHI
  • I_PRODUCTRETAIL.MANDT == T006.MANDT
Loading Group
  • Client
  • Loading Group
  • I_PRODUCTRETAIL.MANDT == TLGR.MANDT
  • I_PRODUCTRETAIL.LOADINGGROUP == TLGR.LADGR
External assortment priority
  • External assortment priority
  • Client
  • I_PRODUCTRETAIL.PRODEXTASSORTMENTPRIORITY == TWSP.PFLKS
  • I_PRODUCTRETAIL.MANDT == TWSP.MANDT
Product Number
  • Product Number
  • Client
  • I_PRODUCTRETAIL.PRODUCT == MARA.MATNR
  • I_PRODUCTRETAIL.MANDT == MARA.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_PRODUCTRETAIL.PURCHASINGGROUP == T024.EKGRP
  • I_PRODUCTRETAIL.MANDT == T024.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Product
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • I_PRODUCTRETAIL.COUNTRYOFORIGIN == T005S.LAND1
  • I_PRODUCTRETAIL.REGIONOFORIGIN == T005S.BLAND
  • I_PRODUCTRETAIL.MANDT == T005S.MANDT
Sales unit
  • Sales unit
  • Client
  • I_PRODUCTRETAIL.SALESUNIT == T006.MSEHI
  • I_PRODUCTRETAIL.MANDT == T006.MANDT
Service agreement for a retail material
  • Service agreement for a retail material
  • Client
  • I_PRODUCTRETAIL.SERVICEAGREEMENT == TWSV.SERVV
  • I_PRODUCTRETAIL.MANDT == TWSV.MANDT
Listing procedure for the store
  • Listing procedure for store or other assortment categories
  • Client
  • I_PRODUCTRETAIL.STORELISTINGPROCEDURE == TWLV.LSTFL
  • I_PRODUCTRETAIL.MANDT == TWLV.MANDT
Valuation Class
  • Client
  • Valuation Class
  • I_PRODUCTRETAIL.MANDT == T025.MANDT
  • I_PRODUCTRETAIL.VALUATIONCLASS == T025.BKLAS