Hi
i think i can post my query in more simpler way .
I want to replace all material here in same table with 20299 main materrial.
How to get main material .any object num for which kstar = 519000 in front of that is main material.
objnr kstar matnr
OR000000009726 510000 10043
OR000000009726 510000 10030
OR000000009726 510000 10025
OR000000009726 510000 10035
OR000000009726 519000 20299
OR000000009726 510000 10035
OR000000009726 519500 20299
OR000000009726 950145 20299
OR000000009726 950115 20299
Regards
Ivneet