SAP MDG · VALIDATION DERIVATION
How do I create a DQM rule to check product classification dimension assignment in SAP MDG?
Use a configuration-only DQM approach in SAP MDG on SAP S/4HANA 2020 and higher: create test class `ZZMDG_BIKES`, characteristic `ZZ_MDG_COLOR`, a dummy rule on `MARA_AUSP` to populate `MARA_AUSP_PRC`, then the real rule on `MARA_KSSK` with a scope for `ZZMDG_BIKES` and a database lookup against `MARA_AUSP_PRC` for `SOURCE_ATINN = ZZ_MDG_COLOR`.
Use a configuration-only DQM approach in SAP MDG on SAP S/4HANA 2020 and higher: create test class `ZZMDG_BIKES`, characteristic `ZZ_MDG_COLOR`, a dummy rule on `MARA_AUSP` to populate `MARA_AUSP_PRC`, then the real rule on `MARA_KSSK` with a scope for `ZZMDG_BIKES` and a database lookup against `MARA_AUSP_PRC` for `SOURCE_ATINN = ZZ_MDG_COLOR`.
Create a DQM rule in the Products app by first preparing test classification data, then defining a dummy rule and the actual rule. The dummy rule ensures `MARA_AUSP_PRC` is populated at runtime; the actual rule checks that products assigned to class `ZZMDG_BIKES` also have the required characteristic `ZZ_MDG_COLOR` through a BRF+ database lookup.
Process flow
- Create class `ZZMDG_BIKES` in transaction `CL01`.
- Maintain characteristic `ZZ_MDG_COLOR` for the class.
- Set characteristic type to `CHAR(10)`, select Multiple Values, and do not select Entry Required.
- Maintain values `BLUE`, `RED`, and `BLACK`.
- Create two test products in `MM01`.
- Assign both products to `ZZMDG_BIKES`.
- Give only one product a value for `ZZ_MDG_COLOR`.
- Open Fiori app `Data Quality Rules - Products`.','Create the dummy rule with base table `MARA_AUSP` and usage `DQM`.','Set the dummy scope expression to `false eq false`.','Set the dummy condition expression with the same always-true setup.
CL01Classification > Class
Create the test class `ZZMDG_BIKES`.
MM01Material Master > Classification view
Create test products and assign class/characteristic values.
Fiori app
Create and maintain the dummy and actual DQM rules.
Referenced tables
| Object | Purpose |
|---|---|
MARA | Simple field-based product checks when data is stored directly on the material base table. |
MARA_AUSP | Dummy DQM rule base table used to populate `MARA_AUSP_PRC` during runtime. |
MARA_KSSK | Actual DQM rule base table for class assignment checks; checked field is Class Type. |
MARA_AUSP_PRC | Runtime process table queried by BRF+ database lookup for the required classification characteristic. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- What is this guide about?
- How do I create a DQM rule for product classification?
- Which releases support this procedure?
Possible questions
- How can DQM check whether a product has a classification characteristic?
- Why is this rule more complex than checking MARA fields?
- What are the main steps?
- Give me the complete DQM classification rule flow.
- What should I prepare before creating the DQM rule?
- Do I need test classification data?
- Which transaction creates the example class?
- What class name is used?
- How do I add the characteristic to ZZMDG_BIKES?