I_Product

Product | view: IPRODUCT | ATTR | Extraction: Full or Incremental | Component: Material Master
Tables used: MARA, MARA
Column Name Description
Product Product Number
Column Name Description
Column Name Description
📏 Weight Unit (WeightUnit):
GrossWeight Gross weight
NetWeight Net weight
📏 Volume unit (VolumeUnit):
MaterialVolume Volume
📏 Time Unit for Quarantine Period (TimeUnitForQuarantinePeriod):
QuarantinePeriod Quarantine Period
📏 Unit of Measure for Maximum Packing Length/Width/Height (UnitForMaxPackagingDimensions):
MaximumPackagingLength Maximum Packing Length of Packaging Material
MaximumPackagingWidth Maximum Packing Width of Packaging Material
MaximumPackagingHeight Maximum Packing Height of Packaging Material
📏 Unit of Dimension for Length/Width/Height (ProductMeasurementUnit):
BaseUnitSpecificProductLength Length
BaseUnitSpecificProductWidth Width
BaseUnitSpecificProductHeight Height
📏 Content unit (ContentUnit):
NetContent Net contents
GrossContent Gross contents
Column Name Description
CreationDate Created On
CreationTime Time of Creation
LastChangeDate Date of Last Change
CrossPlantStatusValidityDate Date from which the cross-plant material status is valid
SalesStatusValidityDate Date from which the X-distr.-chain material status is valid
ValidityStartDate Valid-From Date
ProductValidStartDate Valid-From Date
ProductValidEndDate Deletion date
LastChangeTime Time of Last Change
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
VarblPurOrdUnitIsActive Variable Purchase Order Unit Active Show values
ProductCategory Product Category Show values
ProductIsConfigurable Product is Configurable Show values
IsBatchManagementRequired Batch Management Requirement Indicator Show values
HasEmptiesBOM Empties Bill of Material Show values
SerialNoExplicitnessLevel Level of Explicitness for Serial Number Show values
QltyMgmtInProcmtIsActive QM in Procurement Is Active Show values
IsApprovedBatchRecordReqd Approved Batch Record Required Show values
IsPilferable Pilferable Show values
IsRelevantForHzdsSubstances Relevant for Hazardous Substances Show values
HasVariableTareWeight Variable Tare Weight Show values
ArticleCategory Product Category Show values
HasTextilePartsWthAnimalOrigin Indicator: Contains Non-Textile Parts of Animal Origin Show values
ProductSeasonUsageCategory Indicator: Use of Season Show values
IsActiveEntity Draft - Indicator - Is active document Show values
DocumentIsCreatedByCAD CAD Indicator Show values
ProductIsHighlyViscous Indicator: Highly Viscous Show values
TransportIsInBulk Indicator: In Bulk/Liquid Show values
ProdEffctyParamValsAreAssigned Assign effectivity parameter values/ override change numbers Show values
ProdIsEnvironmentallyRelevant Environmentally Relevant Show values
ProductIsLocked Material Is Locked Show values
DiscountInKindEligibility Material qualifies for discount in kind Show values
IsChemicalComplianceRelevant Chemical Compliance Relevance Indicator Show values
LogisticalProductCategory Category of a Logistical Material Show values
DfsMatlConditionMgmt Material Condition Management Show values
Column Name Description Domain name
ProductExternalID External Representation of Material Number CHAR40
CreationDateTime Product Created On TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ProductOldID Old Product Number BISMT
AuthorizationGroup Authorization Group BEGRU
LowLevelCode Low-Level Code DISST
SizeOrDimensionText Size/dimensions CHAR32
IndustryStandardName Industry Standard Description (such as ANSI or ISO) NORMT
ProductStandardID Global Trade Item Number (EAN/UPC/GTIN) EAN11
ProductManufacturerNumber Manufacturer Part Number CHAR40
MaximumCapacity Maximum Allowed Capacity of Packaging Material DECV15_3
OvercapacityTolerance Overcapacity Tolerance of the Handling Unit DEC2_1
ComparisonPriceQuantity Comparison price unit PACK3
AssortmentListType Assortment List Type BBTYP
ChangeNumber Change Number AENNR
MaterialRevisionLevel Revision Level REVLV
LastChangeDateTime Change Time Stamp TZNTSTMPL
ProductUUID Internal Key for Product SYSUUID
ProdSupChnMgmtUUID22 Internal Number (UID) for Product /SAPAPO/MATID
ProductDocumentChangeNumber Document change number (without document management system) AENUM
ProductDocumentPageCount Number of sheets (without Document Management system) NUM3
ProductDocumentPageNumber Page number of document (without Document Management system) BLATT
ProductionOrInspectionMemoTxt Production/inspection memo FERTH
ProductionMemoPageFormat Page Format of Production Memo DINFO
GlobalTradeItemNumberVariant Global Trade Item Number Variant GTIN_VARIANT
ProductDocumentNumber Document number (without document management system) CHAR22
ProductDocumentVersion Document version (without Document Management system) VERSI
ProductDocumentType Document type (without Document Management system) ZEIAR
ProductDocumentPageFormat Page format of document (without Document Management system) DINFO
ProductConfiguration Internal object number CUOBJ
SegmentationIsRelevant Segmentation Relevant CHAR1
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
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
DfsAmmunitionGroupCode Interchangeability Code for Ammunition DFS_ICFA
DfsRICIdentifier Reportable Item Code - Numerical ID /ISDFPS/RIC_ID
DfsProductSensitivity Sensitivity for Characteristics DFS_SENSITIVITY_KEY
DfsManufacturerPartLongNumber Long Manufacturer Part Number DFS_MFRP2
DfsNationalItemIdnNumber NATO Stock Number DFPS_NSNID
Master Data Relations Join Conditions
Adjustment Profile
  • Client
  • Adjustment Profile
ANP Code
  • Client
  • ANP Code
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.BASEUNIT == T006.MSEHI
Basic Material
  • Client
  • Basic Material
  • I_PRODUCT.MANDT == TWSPR.MANDT
  • I_PRODUCT.BASICMATERIAL == TWSPR.WRKST
Brand
  • Client
  • Brand
Content unit
  • Client
  • Content unit
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.CONTENTUNIT == T006.MSEHI
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • I_PRODUCT.MANDT == T005.MANDT
  • I_PRODUCT.COUNTRYOFORIGIN == T005.LAND1
Cross-Plant Configurable Product
  • Client
  • Cross-Plant Configurable Product
  • I_PRODUCT.MANDT == MARA.MANDT
  • I_PRODUCT.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Cross-Plant Product Status
  • Client
  • Cross-Plant Product Status
  • I_PRODUCT.MANDT == T141.MANDT
  • I_PRODUCT.CROSSPLANTSTATUS == T141.MMSTA
Dangerous Goods Profile
  • Client
  • Dangerous Goods Indicator Profile
  • I_PRODUCT.MANDT == TDG41.MANDT
  • I_PRODUCT.DANGEROUSGOODSINDPROFILE == TDG41.PROFL
Division
  • Client
  • Division
  • I_PRODUCT.MANDT == TSPA.MANDT
  • I_PRODUCT.DIVISION == TSPA.SPART
External Product Group
  • External Product Group
  • Client
  • I_PRODUCT.EXTERNALPRODUCTGROUP == TWEW.EXTWG
  • I_PRODUCT.MANDT == TWEW.MANDT
Handling Indicator
  • Client
  • Handling Indicator
  • I_PRODUCT.MANDT == THNDLCD.MANDT
  • I_PRODUCT.HANDLINGINDICATOR == THNDLCD.HNDLCODE
Handling Unit Type
  • Client
  • Handling Unit Type
  • I_PRODUCT.MANDT == THUTYP.MANDT
  • I_PRODUCT.HANDLINGUNITTYPE == THUTYP.HUTYP
Industry Sector
  • Client
  • Industry Sector
  • I_PRODUCT.MANDT == T137.MANDT
  • I_PRODUCT.INDUSTRYSECTOR == T137.MBRSH
Category of International Article Number (EAN)
  • Client
  • Category of International Article Number (EAN)
  • I_PRODUCT.MANDT == TNTP.MANDT
  • I_PRODUCT.INTERNATIONALARTICLENUMBERCAT == TNTP.NUMTP
General item category group
  • Client
  • General item category group
  • I_PRODUCT.MANDT == TPTM.MANDT
  • I_PRODUCT.ITEMCATEGORYGROUP == TPTM.MTPOS
Laboratory
  • Client
  • Laboratory/design office
  • I_PRODUCT.MANDT == T024L.MANDT
  • I_PRODUCT.LABORATORYORDESIGNOFFICE == T024L.LABOR
Manufacturer Number
  • Client
  • Manufacturer number
  • I_PRODUCT.MANDT == LFA1.MANDT
  • I_PRODUCT.MANUFACTURERNUMBER == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Client
  • Mfr part profile
  • I_PRODUCT.MANDT == TMPPF.MANDT
  • I_PRODUCT.MANUFACTURERPARTPROFILE == TMPPF.MPROF
Number of Internal Material Master Record
  • Number of firm's own (internal) inventory-managed material
  • Client
  • I_PRODUCT.OWNINVENTORYMANAGEDPRODUCT == MARA.MATNR
  • I_PRODUCT.MANDT == MARA.MANDT
Material Group: Packaging Materials
  • Material Group: Packaging Materials
  • Client
  • I_PRODUCT.PACKAGINGMATERIALGROUP == TVEGR.MAGRV
  • I_PRODUCT.MANDT == TVEGR.MANDT
Reference Material Check Packing Instruction
  • Client
  • Reference material for materials packed in same way
  • I_PRODUCT.MANDT == MARA.MANDT
  • I_PRODUCT.PACKINGREFERENCEPRODUCT == MARA.MATNR
Preferred Alternative UoM for Warehouse Operations
  • Client
  • Preferred Alternative UoM for Warehouse Operations
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.PREFERREDUNITOFMEASURE == T006.MSEHI
Procurement rule
  • Procurement rule
  • Client
  • I_PRODUCT.PROCUREMENTRULE == T6WP1.BWVOR
  • I_PRODUCT.MANDT == T6WP1.MANDT
Product Allocation Determination Procedure
  • Product allocation determination procedure
  • Client
  • I_PRODUCT.PRODALLOCDETNPROCEDURE == T190S.KOSCH
  • I_PRODUCT.MANDT == T190S.MANDT
Material Number of the Generic Material in Prepack Materials
  • Client
  • Material Number of the Generic Material in Prepack Materials
  • I_PRODUCT.MANDT == MARA.MANDT
  • I_PRODUCT.PRODNOINGENPRODINPREPACKPROD == MARA.MATNR
Material Group
  • Client
  • Product Group
  • I_PRODUCT.MANDT == T023.MANDT
  • I_PRODUCT.PRODUCTGROUP == T023.MATKL
Product Hierarchy
  • Client
  • Product hierarchy
  • I_PRODUCT.MANDT == T179.MANDT
  • I_PRODUCT.PRODUCTHIERARCHY == T179.PRODH
Unit of Measure for Length/Breadth/Height
  • Client
  • Unit of Dimension for Length/Width/Height
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.PRODUCTMEASUREMENTUNIT == T006.MSEHI
Product Type
  • Client
  • Product Type
  • I_PRODUCT.MANDT == T134.MANDT
  • I_PRODUCT.PRODUCTTYPE == T134.MTART
Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Quality Inspection Group
  • Client
  • Quality Inspection Group
  • I_PRODUCT.MANDT == TQGRP.MANDT
  • I_PRODUCT.QUALITYINSPECTIONGROUP == TQGRP.QGRP
Material Number of a Sales Material
  • Client
  • Material Number of a Sales Material
  • I_PRODUCT.MANDT == MARA.MANDT
  • I_PRODUCT.SALESPRODUCT == MARA.MATNR
Cross-distribution-chain material status
  • Client
  • Cross-distribution-chain material status
  • I_PRODUCT.MANDT == TVMS.MANDT
  • I_PRODUCT.SALESSTATUS == TVMS.VMSTA
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
Serial Number Profile
  • Client
  • Serial Number Profile
  • Serial Number Profile
  • I_PRODUCT.MANDT == TSERIAL.MANDT
  • I_PRODUCT.SERIALNUMBERPROFILE == TSERIAL.SERIAL
  • I_PRODUCT.SERIALIDENTIFIERASSGMTPROFILE == TSERIAL.SERIAL
Serial Number Profile
  • Client
  • Serial Number Profile
  • Serial Number Profile
  • I_PRODUCT.MANDT == TSERIAL.MANDT
  • I_PRODUCT.SERIALNUMBERPROFILE == TSERIAL.SERIAL
  • I_PRODUCT.SERIALIDENTIFIERASSGMTPROFILE == TSERIAL.SERIAL
Source of Supply
  • Client
  • Source of Supply
  • I_PRODUCT.MANDT == TMBW1.MANDT
  • I_PRODUCT.SOURCEOFSUPPLY == TMBW1.BWSCL
Standard HU Type
  • Standard HU Type
  • Client
  • I_PRODUCT.STANDARDHANDLINGUNITTYPE == THUTYP.HUTYP
  • I_PRODUCT.MANDT == THUTYP.MANDT
Time Unit for Quarantine Period
  • Client
  • Time Unit for Quarantine Period
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.TIMEUNITFORQUARANTINEPERIOD == T006.MSEHI
Carr. Group
  • Client
  • Transportation Group
  • I_PRODUCT.MANDT == TTGR.MANDT
  • I_PRODUCT.TRANSPORTATIONGROUP == TTGR.TRAGR
Unit of Measure for Maximum Packing Length/Width/Height
  • Client
  • Unit of Measure for Maximum Packing Length/Width/Height
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.UNITFORMAXPACKAGINGDIMENSIONS == T006.MSEHI
Volume Unit
  • Client
  • Volume unit
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.VOLUMEUNIT == T006.MSEHI
Warehouse Material Group
  • Client
  • Warehouse Material Group
  • I_PRODUCT.MANDT == TWHMATGR.MANDT
  • I_PRODUCT.WAREHOUSEPRODUCTGROUP == TWHMATGR.WHMATGR
Warehouse Storage Condition
  • Client
  • Warehouse Storage Condition
  • I_PRODUCT.MANDT == TWHSTC.MANDT
  • I_PRODUCT.WAREHOUSESTORAGECONDITION == TWHSTC.WHSTC
Unit of Weight
  • Client
  • Weight Unit
  • I_PRODUCT.MANDT == T006.MANDT
  • I_PRODUCT.WEIGHTUNIT == T006.MSEHI