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