P_ProductSearch

Product anchor view for CDS search model | view: PPRODSEARCH | Extraction: Not supported | Component: Material Master
Tables used: MARAMARA
Column Name Description
Product Product Number
Column Name Description
Column Name Description
📏 Weight Unit (WeightUnit):
NetWeight Net weight
GrossWeight Gross weight
Column Name Description
Column Name Description
ProductCategory Product Category Show values
Column Name Description Domain name
LastChangedByUser Name of Person Who Changed Object USNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ProductExternalID External Representation of Material Number CHAR40
ProductOldID Old Product Number BISMT
ProductStandardID Global Trade Item Number (EAN/UPC/GTIN) EAN11
ProductManufacturerNumber Manufacturer Part Number CHAR40
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_PRODUCTSEARCH.MANDT == T006.MANDT
  • P_PRODUCTSEARCH.BASEUNIT == T006.MSEHI
Division
  • Client
  • Division
  • P_PRODUCTSEARCH.MANDT == TSPA.MANDT
  • P_PRODUCTSEARCH.DIVISION == TSPA.SPART
Manufacturer Number
  • Client
  • Manufacturer number
  • P_PRODUCTSEARCH.MANDT == LFA1.MANDT
  • P_PRODUCTSEARCH.MANUFACTURERNUMBER == LFA1.LIFNR
Material Group
  • Product Group
  • Client
  • P_PRODUCTSEARCH.PRODUCTGROUP == T023.MATKL
  • P_PRODUCTSEARCH.MANDT == T023.MANDT
Product Hierarchy
  • Product hierarchy
  • Client
  • P_PRODUCTSEARCH.PRODUCTHIERARCHY == T179.PRODH
  • P_PRODUCTSEARCH.MANDT == T179.MANDT
Product Type
  • Product Type
  • Client
  • P_PRODUCTSEARCH.PRODUCTTYPE == T134.MTART
  • P_PRODUCTSEARCH.MANDT == T134.MANDT
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRODUCTSEARCH.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRODUCTSEARCH.MANDT == T006.MANDT
Source of Supply
  • Source of Supply
  • Client
  • P_PRODUCTSEARCH.SOURCEOFSUPPLY == TMBW1.BWSCL
  • P_PRODUCTSEARCH.MANDT == TMBW1.MANDT
Unit of Weight
  • Weight Unit
  • Client
  • P_PRODUCTSEARCH.WEIGHTUNIT == T006.MSEHI
  • P_PRODUCTSEARCH.MANDT == T006.MANDT