I_Material

Material | view: IMATERIAL | ATTR | Extraction: Not supported | Component: Material Master
Tables used: MARA
Column Name Description
Material Material Number
Column Name Description
Column Name Description
📏 Weight Unit (MaterialWeightUnit):
MaterialGrossWeight Gross weight
MaterialNetWeight Net weight
Column Name Description
Column Name Description
IsBatchManagementRequired Batch Management Requirement Indicator Show values
ProductCategory Material Category Show values
Column Name Description Domain name
MaterialManufacturerPartNumber Manufacturer Part Number CHAR40
AuthorizationGroup Authorization Group BEGRU
ProductCharacteristic1 Characteristic Value for Colors of Variants WRF_ATWRT
ProductCharacteristic2 Characteristic Value for Main Sizes of Variants WRF_ATWRT
ProductCharacteristic3 Characteristic Value for Second Size for Variants WRF_ATWRT
ProdCharc1InternalNumber Internal Charactieristic Number for Color Characteristics ATINN
ProdCharc2InternalNumber Internal Char. Number for Characteristics for Main Sizes ATINN
ProdCharc3InternalNumber Internal Char. Number for Characteristics for Second Sizes ATINN
Master Data Relations Join Conditions
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_MATERIAL.MANDT == MARA.MANDT
  • I_MATERIAL.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MATERIAL.MANDT == T006.MANDT
  • I_MATERIAL.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • I_MATERIAL.MANDT == T023.MANDT
  • I_MATERIAL.MATERIALGROUP == T023.MATKL
Manufacturer Number
  • Client
  • Manufacturer number
  • I_MATERIAL.MANDT == LFA1.MANDT
  • I_MATERIAL.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Material type
  • Client
  • Material type
  • I_MATERIAL.MANDT == T134.MANDT
  • I_MATERIAL.MATERIALTYPE == T134.MTART
Unit of Weight
  • Client
  • Weight Unit
  • I_MATERIAL.MANDT == T006.MANDT
  • I_MATERIAL.MATERIALWEIGHTUNIT == T006.MSEHI