Item attribute values by revisions
Hello,
we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item.
This means that we want to extract data with the following structure item_number, revision, attribute_value. We expect one row for each revision of the single item_number.
We have tried different solutions but without any valid result. We do not fully understand the connections between ego_versions_b, ego_item_eff_b and egp_item_revisions_b.
Do you have a query to achieve this requirement?
Thank you
0