We have a oralce as source system. A table material group with mat group id, version id and some other columns needs to be extracted to BW. For every material group, 4 version id's are maintained and for each version id a validity period and version number is mainatained in another table.
To design this in BW, The infoobject material group was created with attribute Version id. This did not work as the mat group is not unique without version id. If versionid is defined as compounding infoobject, every version will be available in the report for eachmat group. The requirement is that the mat group in the report should show the current version being used with the quantities consumed/procured.
Any ideas how to design this in BW.
Thanks and Regards,
Edited by: Srinivas on Mar 18, 2011 6:47 AM