Accepted Solutions (0)
Answers (3)
Your question is not really clear and I have to make some assumptions.
Characteristics are usually only assigned to Merchandise Categories in the case of informational characteristics (not in the case of variant creating characteristics). What's more, I assume that this question is ECC 6.0 and not for S/4HANA, where variant creating characteristics are not assigned to merchandise categories at all.
In ECC 6.0 and for informational characteristics assigned to merchandise categories, the relevant tables and relationships are as follows:
If you clarify the specific use case of the characteristics and whether the question relates to ECC 6.0 or S/4HANA then the answer changes accordingly.
Hi Paul,
Thanks for your detailed explanation..
I managed to find this by the following way..
We cannot directly get characteristics value assignments and Merchandise category from a single table.
W have to merge and lookup following tables
1.WRF_HIER_NODES – (Application ID should be ‘02’ - Characteristic Value Group)
2.WRF_HIER_NODEBOX
3.WRF_HIER_OBJ
For Example;
Characteristics Size is having two MC’s in the mentioned node (NT) and following characteristics values are assigned to it (3XL,4XL etc..)
In table WRF_HIER_NODES give application ID as 02 and you can see the nodes attached to it.
You can get the MC’s assigned to the node from WRF_HIER_NODEBOX
Assigned values are stored in table - WRF_HIER_OBJ.
Since this cannot be directly fetched from the table some excel works need to be done by merging Nodes which are identical in three tables.
| User | Count |
|---|---|
| 101 | |
| 14 | |
| 10 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.