Material classification issue
I'm having difficulties finding a solution for a request at my company.
Business is asking for a material class "Marketing drives" where they can assign different drives to certain materials.
The data for these drives (key, description and validitiy period) are comming from a Z-table. Now, the class is created and I created one characteristic for the class which is linked to the key of the check table via the "other value check".
The issue I have now is that the business also wants to see the description in the material class. In normal cases, I would create a second characteristic and make a dependency but I do not know how that would work because I would need to go and make a select from the Z-table.
Can anyone give me some ideas?