You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Item attribute values by revisions

edited Sep 9, 2024 12:43PM in Reporting and Analytics for SCM 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!