C_MDQltyProductSalesResult

Product Sales Rule Results | view: CMDQLTYPRODSARES | Extraction: Not supported | Component: Analysis and Remediation of Data Quality.
Tables used: MDC_D_PRCROOT, MDC_D_PRCROOT, MDQ_RULE_DEF_D, MARA, T002, MDQ_BUSRUL_USG, MDQ_EVALDETAIL, MDQ_SCORERULERES, MDQ_RULE_MDG_INT, MDQ_RLMSG_ASSG, MDQ_DIM_R_ASSG, MDQ_RES_RECORDS, MDQ_MNDRUL_LNK, MVKE_DQ_RES, MDQ_EVALDETAIL, MDQ_SCORERULERES, MDQ_RULE_DEF, MDQ_RULE_DEF, MDQ_EVALDETAIL, MDQ_BRF_RULE_MAP, MDQ_BRF_RULE_USG, MDQ_RULEUSAGE, MDQ_RULE_DEF, MARA, MAKT, MAW1, MVKE, TVKO, USR21
Column Name Description
MasterDataChangeProcess Master Data Change Process Identifier
Product Product Number
ProductSalesOrg Sales Organization
ProductDistributionChnl Distribution Channel
MDQualityBusinessRuleUUID MDQ Rule Definition UUID
MDQltyBusRuleEvalResultCode Master Data Quality Rule Evaluation Result Type
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
📏 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
📏 Base Unit of Measure (BaseUnit):
MinimumMakeToOrderOrderQty Minimum make-to-order quantity
MaxDeliveryQtyStoreOrder Maximum delivery quantity in store order processing
Column Name Description
CrossPlantStatusValidityDate Date from which the cross-plant material status is valid
CreationDate Created On
LastChangeDate Date of Last Change
LastChangeTime Time of Last Change
ValidityStartDate Valid-From Date
ProductValidEndDate Deletion date
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
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 Deletion Indicator Show values
ProductIsConfigurable Product is Configurable Show values
IsBatchManagementRequired Batch Management Requirement Indicator Show values
SerialNoExplicitnessLevel Level of Explicitness for Serial Number 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
CashDiscountIsDeductible Cash Discount Indicator Show values
PriceFixingCategory Indicator for price fixing Show values
VariableSalesUnitIsNotAllowed Variable Sales Unit Not Allowed Show values
CompetitionPressureCategory Competition characterization of a material Show values
Column Name Description Domain name
SalesOrganization Sales Organization VKORG
MDQltyBusinessObjectTypeCode Business Object Type MDG_OBJECT_TYPE_CODE_BS
MDQltyBusRuleCheckedFieldTable Maste Data Quality Table Name of Checked Field AS4TAB
MDQltyBusRuleCheckedField Master Data Quality Fieldname of the Checked Field FDNAME
MDQltyBusRuleChkdFieldAndTable Master Data Quality Table and Field Name of Checked Field MDQ_CHKFLD_TABANDFIELDNAME
MDQltyNmbrOfBusRuleEvalResults Master Data Quality Counter Total Records
MDQualityBusinessRule Master Data Quality Rule Definition ID MDQ_RULE_DEFINITION_ID
MDQualityBusinessRuleName Master Data Quality Rule Definition Name MDQ_RULE_DEFINITION_NAME
MDQltyBusinessRuleBaseTable Master Data Quality Base Table AS4TAB
MDQltyTechnicalRuleScopeUUID Master Data Quality: UUID for BRFplus
MDQltyTechnicalRuleCndnUUID Master Data Quality: UUID for BRFplus
MDQltyMDGovBRFPlusObjectUUID Master Data Quality: UUID for BRFplus
MDChgProcessFinishDateTime Master Data Quality Evaluation Finished Date & Time TZNTSTMPL
ProductDescription Product Description TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
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
ProductManufacturerNumber Manufacturer Part Number CHAR40
ArticleCategory Product Category
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
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Adjustment Profile
  • Adjustment Profile
  • Client
ANP Code
  • ANP Code
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.ANPCODE == J_1BTANP.J_1BANP
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == J_1BTANP.MANDT
Assortment grade
  • Assortment grade
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.ASSORTMENTGRADE == TWSS.SSTUF
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWSS.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.BASEUNIT == T006.MSEHI
Brand
  • Brand
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.BRAND == WRF_BRANDS.BRAND_ID
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == WRF_BRANDS.MANDT
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.CONSUMPTIONVALUECATEGORY == TMABC.MAABC
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TMABC.MANDT
Content unit
  • Content unit
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.CONTENTUNIT == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Country/Region of Origin of Product
  • Client
  • Country/Region of Origin of Product
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T005.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.COUNTRYOFORIGIN == T005.LAND1
Cross-Plant Product Status
  • Cross-Plant Product Status
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.CROSSPLANTSTATUS == T141.MMSTA
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T141.MANDT
Listing procedure for distr. center assortment categories
  • Listing procedure for distr. center assortment categories
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWLV.MANDT
Distribution channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVTW.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
  • C_MDQLTYPRODUCTSALESRESULT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.DIVISION == TSPA.SPART
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TSPA.MANDT
External Product Group
  • External Product Group
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.EXTERNALPRODUCTGROUP == TWEW.EXTWG
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWEW.MANDT
Product Group 5
  • Client
  • Product Group 5
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVM5.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5
Product Group 1
  • Product Group 1
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVM1.MANDT
Product Group 4
  • Product Group 4
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVM4.MANDT
Unit of issue
  • Client
  • Unit of issue
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.GOODSISSUEUNIT == T006.MSEHI
Handling Indicator
  • Handling Indicator
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.HANDLINGINDICATOR == THNDLCD.HNDLCODE
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == THNDLCD.MANDT
Handling Unit Type
  • Handling Unit Type
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.HANDLINGUNITTYPE == THUTYP.HUTYP
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == THUTYP.MANDT
Category of International Article Number (EAN)
  • Client
  • Category of International Article Number (EAN)
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TNTP.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.INTERNATIONALARTICLENUMBERCAT == TNTP.NUMTP
Shipping statistics group
  • Material statistics group
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.LOGISTICSSTATISTICSGROUP == TVSM.STGMA
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVSM.MANDT
Manufacturer Number
  • Manufacturer number
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.MANUFACTURERNUMBER == LFA1.LIFNR
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == LFA1.MANDT
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.MANUFACTURERPARTPROFILE == TMPPF.MPROF
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TMPPF.MANDT
Price group
  • Pricing Reference Material
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRICINGREFERENCEPRODUCT == MARA.MATNR
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == MARA.MANDT
Material Number of the Generic Material in Prepack Materials
  • Material Number of the Generic Material in Prepack Materials
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRODNOINGENPRODINPREPACKPROD == MARA.MATNR
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == MARA.MANDT
Commission group
  • Client
  • Commission Group
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVPR.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Product Group
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTGROUP == T023.MATKL
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T023.MANDT
Product Hierarchy
  • Product hierarchy
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTHIERARCHY == T179.PRODH
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T179.MANDT
Unit of Measure for Length/Breadth/Height
  • Unit of Dimension for Length/Width/Height
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTMEASUREMENTUNIT == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Material status for sales
  • Distribution-chain-specific material status
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTSALESSTATUS == TVMS.VMSTA
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVMS.MANDT
Product Type
  • Client
  • Product Type
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T134.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTTYPE == T134.MTART
Quality Inspection Group
  • Client
  • Quality Inspection Group
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TQGRP.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.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_MDQLTYPRODUCTSALESRESULT.REGIONOFORIGIN == T005S.BLAND
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T005S.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.COUNTRYOFORIGIN == T005S.LAND1
Rounding profile
  • ?
  • Client
  • ?
  • Rounding Profile
  • C_MDQLTYPRODUCTSALESRESULT.[column in domain "RDZAE"] == RDPR.RDZAE
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == RDPR.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.[column in domain "WERKS_D"] == RDPR.WERKS
  • C_MDQLTYPRODUCTSALESRESULT.ROUNDINGPROFILE == RDPR.RDPRF
Item category group
  • Item Category Group from Material Master
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.SALESITEMCATEGORYGROUP == TPTM.MTPOS
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TPTM.MANDT
Unit of measure
  • Sales unit
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.SALESMEASUREUNIT == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Product Group 2
  • Product Group 2
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVM2.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.SERIALNUMBERPROFILE == TSERIAL.SERIAL
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TSERIAL.MANDT
Service agreement for a retail material
  • Service agreement for a retail material
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.SERVICEAGREEMENT == TWSV.SERVV
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWSV.MANDT
Standard HU Type
  • Standard HU Type
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.STANDARDHANDLINGUNITTYPE == THUTYP.HUTYP
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == THUTYP.MANDT
Listing procedure for store or other assortment categories
  • Listing procedure for store or other assortment categories
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.STORELISTINGPROCEDURE == TWLV.LSTFL
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWLV.MANDT
Product Group 3
  • Product Group 3
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVM3.MANDT
Time Unit for Quarantine Period
  • Client
  • Time Unit for Quarantine Period
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.TIMEUNITFORQUARANTINEPERIOD == T006.MSEHI
Unit of Measure for Maximum Packing Length/Width/Height
  • Unit of Measure for Maximum Packing Length/Width/Height
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.UNITFORMAXPACKAGINGDIMENSIONS == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Valuation Class
  • Client
  • Valuation Class
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T025.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.VALUATIONCLASS == T025.BKLAS
Volume rebate group
  • Volume rebate group
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.VOLUMEREBATEGROUP == TVBO.BONUS
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TVBO.MANDT
Volume Unit
  • Volume unit
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.VOLUMEUNIT == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Warehouse Material Group
  • Client
  • Warehouse Material Group
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWHMATGR.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.WAREHOUSEPRODUCTGROUP == TWHMATGR.WHMATGR
Warehouse Storage Condition
  • Client
  • Warehouse Storage Condition
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWHSTC.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.WAREHOUSESTORAGECONDITION == TWHSTC.WHSTC
Unit of Weight
  • Weight Unit
  • Client
  • C_MDQLTYPRODUCTSALESRESULT.WEIGHTUNIT == T006.MSEHI
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • ?
  • Client
  • Unit of Measure Group
  • C_MDQLTYPRODUCTSALESRESULT.[column in domain "LRMEI"] == TWMEG.MEINS
  • C_MDQLTYPRODUCTSALESRESULT.MANDT == TWMEG.MANDT
  • C_MDQLTYPRODUCTSALESRESULT.PRODUCTUNITGROUP == TWMEG.MEGRU