N_Product

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