P_ProductWD

union | view: PPRODUCTWD | Extraction: Not supported | Component: Material Master
Tables used: SDRAFT_ADMIN, MARA, USR21, MARA, MAW1, PRD_ROOT
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct Product Number
Column Name Description
Column Name Description
📏 Weight Unit (WeightUnit):
GrossWeight Gross weight
NetWeight Net weight
📏 Volume unit (VolumeUnit):
MaterialVolume Volume
📏 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
CrossPlantStatusValidityDate Date from which the cross-plant material status is valid
CreationDate Created On
LastChangeDate Date of Last Change
ValidityStartDate Valid-From Date
ProductValidStartDate Valid-From Date
ProductValidEndDate Deletion date
StoreListingStartDate Date from which listed in the store
StoreListingEndDate Date to which listed in the store
DistrCntrListingStartDate Date from which listed in the distribution center
DistrCntrListingEndDate Date to which listed in the central warehouse/distr. center
StoreSaleStartDate Date from which sold in the store
StoreSaleEndDate Date to which sold in the store
DistrCntrSaleStartDate Date from which sold in the distribution center
DistrCntrSaleEndDate Date to which sold in the distribution center
Column Name Description
IsMarkedForDeletion Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
ProductIsConfigurable Product is Configurable Show values
IsBatchManagementRequired Batch Management Requirement Indicator Show values
SerialNoExplicitnessLevel Level of Explicitness for Serial Number 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 Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasDraftEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
Product Product Number MATNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ProductOldID Old Product Number BISMT
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
ComparisonPriceQuantity Comparison price unit PACK3
AssortmentListType Assortment List Type BBTYP
ValuationMargin Valuation margin PRZ32V
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
ANP Code
  • ANP Code
  • Client
Assortment grade
  • Client
  • Assortment grade
  • P_PRODUCTWD.MANDT == TWSS.MANDT
  • P_PRODUCTWD.ASSORTMENTGRADE == TWSS.SSTUF
Unit of Measure
  • Base Unit of Measure
  • Client
  • P_PRODUCTWD.BASEUNIT == T006.MSEHI
  • P_PRODUCTWD.MANDT == T006.MANDT
Brand
  • Brand
  • Client
Unit of measure for commodity code (foreign trade)
  • Client
  • Unit of measure for commodity code (foreign trade)
  • P_PRODUCTWD.MANDT == T006.MANDT
  • P_PRODUCTWD.COMMODITIYCODENUMBERUNIT == T006.MSEHI
Commodity Code
  • ?
  • Client
  • Commodity Code
  • P_PRODUCTWD.[column in domain "LAND1"] == T604.LAND1
  • P_PRODUCTWD.MANDT == T604.MANDT
  • P_PRODUCTWD.COMMODITYCODE == T604.STAWN
Value Table for ABC Indicator
  • Client
  • ABC Indicator
  • P_PRODUCTWD.MANDT == TMABC.MANDT
  • P_PRODUCTWD.CONSUMPTIONVALUECATEGORY == TMABC.MAABC
Content unit
  • Client
  • Content unit
  • P_PRODUCTWD.MANDT == T006.MANDT
  • P_PRODUCTWD.CONTENTUNIT == T006.MSEHI
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • P_PRODUCTWD.COUNTRYOFORIGIN == T005.LAND1
  • P_PRODUCTWD.MANDT == T005.MANDT
Cross-Plant Configurable Product
  • Client
  • Cross-Plant Configurable Product
  • P_PRODUCTWD.MANDT == MARA.MANDT
  • P_PRODUCTWD.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Cross-Plant Product Status
  • Cross-Plant Product Status
  • Client
  • P_PRODUCTWD.CROSSPLANTSTATUS == T141.MMSTA
  • P_PRODUCTWD.MANDT == T141.MANDT
Listing procedure for the distribution center
  • Listing procedure for distr. center assortment categories
  • Client
  • P_PRODUCTWD.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL
  • P_PRODUCTWD.MANDT == TWLV.MANDT
Division
  • Division
  • Client
  • P_PRODUCTWD.DIVISION == TSPA.SPART
  • P_PRODUCTWD.MANDT == TSPA.MANDT
External Product Group
  • Client
  • External Product Group
  • P_PRODUCTWD.MANDT == TWEW.MANDT
  • P_PRODUCTWD.EXTERNALPRODUCTGROUP == TWEW.EXTWG
Unit of issue
  • Unit of issue
  • Client
  • P_PRODUCTWD.GOODSISSUEUNIT == T006.MSEHI
  • P_PRODUCTWD.MANDT == T006.MANDT
Category of International Article Number (EAN)
  • Category of International Article Number (EAN)
  • Client
  • P_PRODUCTWD.INTERNATIONALARTICLENUMBERCAT == TNTP.NUMTP
  • P_PRODUCTWD.MANDT == TNTP.MANDT
General item category group
  • General item category group
  • Client
  • P_PRODUCTWD.ITEMCATEGORYGROUP == TPTM.MTPOS
  • P_PRODUCTWD.MANDT == TPTM.MANDT
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • P_PRODUCTWD.MANUFACTURERPARTPROFILE == TMPPF.MPROF
  • P_PRODUCTWD.MANDT == TMPPF.MANDT
Material Number of the Generic Material in Prepack Materials
  • Material Number of the Generic Material in Prepack Materials
  • Client
  • P_PRODUCTWD.PRODNOINGENPRODINPREPACKPROD == MARA.MATNR
  • P_PRODUCTWD.MANDT == MARA.MANDT
Material Group
  • Product Group
  • Client
  • P_PRODUCTWD.PRODUCTGROUP == T023.MATKL
  • P_PRODUCTWD.MANDT == T023.MANDT
Product Hierarchy
  • Client
  • Product hierarchy
  • P_PRODUCTWD.MANDT == T179.MANDT
  • P_PRODUCTWD.PRODUCTHIERARCHY == T179.PRODH
Unit of Measure for Length/Breadth/Height
  • Client
  • Unit of Dimension for Length/Width/Height
  • P_PRODUCTWD.MANDT == T006.MANDT
  • P_PRODUCTWD.PRODUCTMEASUREMENTUNIT == T006.MSEHI
Product Type
  • Client
  • Product Type
  • P_PRODUCTWD.MANDT == T134.MANDT
  • P_PRODUCTWD.PRODUCTTYPE == T134.MTART
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRODUCTWD.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRODUCTWD.MANDT == T006.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • ?
  • P_PRODUCTWD.REGIONOFORIGIN == T005S.BLAND
  • P_PRODUCTWD.MANDT == T005S.MANDT
  • P_PRODUCTWD.[column in domain "LAND1"] == T005S.LAND1
Serial Number Profile
  • Serial Number Profile
  • Client
  • P_PRODUCTWD.SERIALIDENTIFIERASSGMTPROFILE == TSERIAL.SERIAL
  • P_PRODUCTWD.MANDT == TSERIAL.MANDT
Service agreement for a retail material
  • Client
  • Service agreement for a retail material
  • P_PRODUCTWD.MANDT == TWSV.MANDT
  • P_PRODUCTWD.SERVICEAGREEMENT == TWSV.SERVV
Listing procedure for the store
  • Listing procedure for store or other assortment categories
  • Client
  • P_PRODUCTWD.STORELISTINGPROCEDURE == TWLV.LSTFL
  • P_PRODUCTWD.MANDT == TWLV.MANDT
Valuation Class
  • Client
  • Valuation Class
  • P_PRODUCTWD.MANDT == T025.MANDT
  • P_PRODUCTWD.VALUATIONCLASS == T025.BKLAS
Volume Unit
  • Volume unit
  • Client
  • P_PRODUCTWD.VOLUMEUNIT == T006.MSEHI
  • P_PRODUCTWD.MANDT == T006.MANDT
Unit of Weight
  • Client
  • Weight Unit
  • P_PRODUCTWD.MANDT == T006.MANDT
  • P_PRODUCTWD.WEIGHTUNIT == T006.MSEHI