Skip to Content
0
Former Member
Dec 03, 2008 at 08:03 PM

COEP Access

46 Views

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