C_Product

Product Master Basic Data | view: CPRODUCT | Extraction: Not supported | Component: Material Master
Tables used: DFS_ASSGMT, MARA, /ISDFPS/CLOGLEVT, /ISDFPS/NSN_IDT, /ISDFPS/CRETDELT, DFS_ASSGMT_CORE, DFS_ASSGMT_CORET, DFS_ASSGMT_DMGT, DFS_ASSGMT_DMGTT, DFS_ASSGMT_MATI, DFS_ASSGMT_MATIT, PA0001, PA0002, DFS_MAINT_PLTFRM, ADRP, USR02, USR21, /ISDFPS/RIC_CATL, DFS_FE_ICFA_T, DFS_FE_SENSTVT_T, USR02, DFS_FE_STRUCAUTH, T002, TPAR, TPART, MARA, MAKT, MAW1, ADRP, USR21, USR01, PRPS, /ISDFPS/FORCE, HRP1000, /ISDFPS/FORCE, HRP1000, DFS_LMPNCONF, T77UA
Column Name Description
Product Product Number
Column Name Description
Column Name Description
📏 Unit of Measurement (OvercapacityToleranceUnit):
GrossWeight Gross weight
NetWeight Net weight
MaterialVolume Volume
BaseUnitSpecificProductLength Length
BaseUnitSpecificProductWidth Width
BaseUnitSpecificProductHeight Height
NetContent Net contents
GrossContent Gross contents
MaximumPackagingLength Maximum Packing Length of Packaging Material
MaximumPackagingWidth Maximum Packing Width of Packaging Material
MaximumPackagingHeight Maximum Packing Height of Packaging Material
📏 Time Unit for Quarantine Period (TimeUnitForQuarantinePeriod):
QuarantinePeriod Quarantine Period
Column Name Description
CrossPlantStatusValidityDate Date from which the cross-plant material status is valid
CreationDate Created On
CreationTime Time of Creation
LastChangeDate Date of Last Change
LastChangeTime Time of Last Change
ValidityStartDate Valid-From Date
ProductValidEndDate Deletion date
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
ProductIsConfigurable Product is Configurable Show values
IsBatchManagementRequired Batch Management Requirement Indicator 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
IsPilferable Pilferable Show values
IsRelevantForHzdsSubstances Relevant for Hazardous Substances Show values
HasVariableTareWeight Variable Tare Weight Show values
HasEmptiesBOM Empties Bill of Material Show values
IsChemicalComplianceRelevant Chemical Compliance Relevance Indicator Show values
HasGlobalHierarchy Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
IsVariantConfigurationEnabled Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
DfsLongMfrPartNumberIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
DfsMfrPartNumberIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
ProductExternalID External Representation of Material Number CHAR40
ProductForEdit Product Number MATNR
ProductDescription Product Description TEXT40
CreationDateTime Product Created On TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime Change Time Stamp
LastChangedByUser Name of Person Who Changed Object USNAM
LastChangedByUserName User Description SUIDTECHDESC
CreatedByUserName User Description SUIDTECHDESC
ProductOldID Old Product Number BISMT
SizeOrDimensionText Size/dimensions CHAR32
IndustryStandardName Industry Standard Description (such as ANSI or ISO) NORMT
ProductStandardID Global Trade Item Number (EAN/UPC/GTIN) EAN11
SerialNoExplicitnessLevel Level of Explicitness for Serial Number
ProductManufacturerNumber Manufacturer Part Number CHAR40
ProductImageURL Image URL
ComparisonPriceQuantity Comparison price unit PACK3
AssortmentListType Assortment List Type BBTYP
ValuationMargin Valuation margin PRZ32V
ChangeNumber Change Number AENNR
MaterialRevisionLevel Revision Level REVLV
MaximumCapacity Maximum Allowed Capacity of Packaging Material DECV15_3
OvercapacityTolerance Overcapacity Tolerance of the Handling Unit DEC2_1
ClassificationSideEffect Side effect data
ConfigurationSideEffect Side effect data
AuthorizationGroup Authorization Group BEGRU
NumberOfProductVariants Number of Variants for a Product
NumberOfProcessedProdVariants null
ReferenceProduct Reference Product MATNR
ProductDocumentNumber Document number (without document management system) CHAR22
ProductDocumentVersion Document version (without Document Management system) VERSI
ProductDocumentType Document type (without Document Management system) ZEIAR
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
ProductDocumentPageFormat Page format of document (without Document Management system) DINFO
FrcElmntOrgIntchgtyForAmmoText Description of Interchangeability Code for Ammunition
DfsAmmunitionGroupCode Interchangeability Code for Ammunition DFS_ICFA
FlxMtPlObjRICDescription RIC Description
DfsRICIdentifier Reportable Item Code - Numerical ID /ISDFPS/RIC_ID
FrcElmntOrgSensitivityDesc Sensitivity Text for Characteristics
DfsProductSensitivity Sensitivity for Characteristics DFS_SENSITIVITY_KEY
DfsManufacturerPartLongNumber Long Manufacturer Part Number DFS_MFRP2
DfsProductManufacturerNumber Manufacturer Part Number CHAR40
DfsLogisticsLevelName Description of Logistics Level TXT30
DfsReturnDeliveryName Return Delivery Code Description TXT50
DfsNationalItemIdnNumberName NSN Description TEXT40
DfsNationalItemIdnNumber NATO Stock Number
DfsMatlConditionMgmtName Short Text for Fixed Values DDTEXT
DfsMatlConditionMgmt Material Condition Management
DfsIsStrucAuthznEnabled null
Master Data Relations Join Conditions
Adjustment Profile
  • Adjustment Profile
  • Client
ANP Code
  • Client
  • ANP Code
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PRODUCT.MANDT == T006.MANDT
  • C_PRODUCT.BASEUNIT == T006.MSEHI
Brand
  • Brand
  • Client
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • C_PRODUCT.CONSUMPTIONVALUECATEGORY == TMABC.MAABC
  • C_PRODUCT.MANDT == TMABC.MANDT
Content unit
  • Content unit
  • Client
  • C_PRODUCT.CONTENTUNIT == T006.MSEHI
  • C_PRODUCT.MANDT == T006.MANDT
Country/Region of Origin of Product
  • Client
  • Country/Region of Origin of Product
  • C_PRODUCT.MANDT == T005.MANDT
  • C_PRODUCT.COUNTRYOFORIGIN == T005.LAND1
Cross-Plant Configurable Product
  • Cross-Plant Configurable Product
  • Client
  • C_PRODUCT.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_PRODUCT.MANDT == MARA.MANDT
Cross-Plant Product Status
  • Client
  • Cross-Plant Product Status
  • C_PRODUCT.MANDT == T141.MANDT
  • C_PRODUCT.CROSSPLANTSTATUS == T141.MMSTA
Division
  • Division
  • Client
  • C_PRODUCT.DIVISION == TSPA.SPART
  • C_PRODUCT.MANDT == TSPA.MANDT
External Product Group
  • External Product Group
  • Client
  • C_PRODUCT.EXTERNALPRODUCTGROUP == TWEW.EXTWG
  • C_PRODUCT.MANDT == TWEW.MANDT
Unit of issue
  • Unit of issue
  • Client
  • C_PRODUCT.GOODSISSUEUNIT == T006.MSEHI
  • C_PRODUCT.MANDT == T006.MANDT
Handling Indicator
  • Client
  • Handling Indicator
  • C_PRODUCT.MANDT == THNDLCD.MANDT
  • C_PRODUCT.HANDLINGINDICATOR == THNDLCD.HNDLCODE
Handling Unit Type
  • Handling Unit Type
  • Client
  • C_PRODUCT.HANDLINGUNITTYPE == THUTYP.HUTYP
  • C_PRODUCT.MANDT == THUTYP.MANDT
Category of International Article Number (EAN)
  • Category of International Article Number (EAN)
  • Client
  • C_PRODUCT.INTERNATIONALARTICLENUMBERCAT == TNTP.NUMTP
  • C_PRODUCT.MANDT == TNTP.MANDT
General item category group
  • General item category group
  • Client
  • C_PRODUCT.ITEMCATEGORYGROUP == TPTM.MTPOS
  • C_PRODUCT.MANDT == TPTM.MANDT
Laboratory
  • Client
  • Laboratory/design office
  • C_PRODUCT.MANDT == T024L.MANDT
  • C_PRODUCT.LABORATORYORDESIGNOFFICE == T024L.LABOR
Manufacturer Number
  • Client
  • Manufacturer number
  • C_PRODUCT.MANDT == LFA1.MANDT
  • C_PRODUCT.MANUFACTURERNUMBER == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Client
  • Mfr part profile
  • C_PRODUCT.MANDT == TMPPF.MANDT
  • C_PRODUCT.MANUFACTURERPARTPROFILE == TMPPF.MPROF
Material Group: Packaging Materials
  • Material Group: Packaging Materials
  • Client
  • C_PRODUCT.PACKAGINGMATERIALGROUP == TVEGR.MAGRV
  • C_PRODUCT.MANDT == TVEGR.MANDT
Material Number of the Generic Material in Prepack Materials
  • Material Number of the Generic Material in Prepack Materials
  • Client
  • C_PRODUCT.PRODNOINGENPRODINPREPACKPROD == MARA.MATNR
  • C_PRODUCT.MANDT == MARA.MANDT
Material Group
  • Product Group
  • Client
  • C_PRODUCT.PRODUCTGROUP == T023.MATKL
  • C_PRODUCT.MANDT == T023.MANDT
Product Hierarchy
  • Client
  • Product hierarchy
  • C_PRODUCT.MANDT == T179.MANDT
  • C_PRODUCT.PRODUCTHIERARCHY == T179.PRODH
Unit of Measure for Length/Breadth/Height
  • Client
  • Unit of Dimension for Length/Width/Height
  • C_PRODUCT.MANDT == T006.MANDT
  • C_PRODUCT.PRODUCTMEASUREMENTUNIT == T006.MSEHI
Product Type
  • Product Type
  • Client
  • C_PRODUCT.PRODUCTTYPE == T134.MTART
  • C_PRODUCT.MANDT == T134.MANDT
Quality Inspection Group
  • Client
  • Quality Inspection Group
  • C_PRODUCT.MANDT == TQGRP.MANDT
  • C_PRODUCT.QUALITYINSPECTIONGROUP == TQGRP.QGRP
Region of Origin of Material (Non-Preferential Origin)
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • Country/Region of Origin of Product
  • C_PRODUCT.REGIONOFORIGIN == T005S.BLAND
  • C_PRODUCT.MANDT == T005S.MANDT
  • C_PRODUCT.COUNTRYOFORIGIN == T005S.LAND1
Sales unit
  • Client
  • Sales unit
  • C_PRODUCT.MANDT == T006.MANDT
  • C_PRODUCT.SALESUNIT == T006.MSEHI
Serial Number Profile
  • Client
  • Serial Number Profile
  • C_PRODUCT.MANDT == TSERIAL.MANDT
  • C_PRODUCT.SERIALNUMBERPROFILE == TSERIAL.SERIAL
Service agreement for a retail material
  • Client
  • Service agreement for a retail material
  • C_PRODUCT.MANDT == TWSV.MANDT
  • C_PRODUCT.SERVICEAGREEMENT == TWSV.SERVV
Standard HU Type
  • Client
  • Standard HU Type
  • C_PRODUCT.MANDT == THUTYP.MANDT
  • C_PRODUCT.STANDARDHANDLINGUNITTYPE == THUTYP.HUTYP
Time Unit for Quarantine Period
  • Time Unit for Quarantine Period
  • Client
  • C_PRODUCT.TIMEUNITFORQUARANTINEPERIOD == T006.MSEHI
  • C_PRODUCT.MANDT == T006.MANDT
Unit of Measure for Maximum Packing Length/Width/Height
  • Unit of Measure for Maximum Packing Length/Width/Height
  • Client
  • C_PRODUCT.UNITFORMAXPACKAGINGDIMENSIONS == T006.MSEHI
  • C_PRODUCT.MANDT == T006.MANDT
Valuation Class
  • Client
  • Valuation Class
  • C_PRODUCT.MANDT == T025.MANDT
  • C_PRODUCT.VALUATIONCLASS == T025.BKLAS
Volume Unit
  • Volume unit
  • Client
  • C_PRODUCT.VOLUMEUNIT == T006.MSEHI
  • C_PRODUCT.MANDT == T006.MANDT
Warehouse Material Group
  • Warehouse Material Group
  • Client
  • C_PRODUCT.WAREHOUSEPRODUCTGROUP == TWHMATGR.WHMATGR
  • C_PRODUCT.MANDT == TWHMATGR.MANDT
Warehouse Storage Condition
  • Warehouse Storage Condition
  • Client
  • C_PRODUCT.WAREHOUSESTORAGECONDITION == TWHSTC.WHSTC
  • C_PRODUCT.MANDT == TWHSTC.MANDT
Unit of Weight
  • Client
  • Weight Unit
  • C_PRODUCT.MANDT == T006.MANDT
  • C_PRODUCT.WEIGHTUNIT == T006.MSEHI