Master Data table update with Abap

Hi experts,

I have a master data table as follwing (simplified version)

Field1

Field2

Field3

A

B

Y

A

B

Y

A

E

Z

A

E

Z

A

E

Z

A

M

V

I need to update field3 of the master data as following:

-The same combination of field1 and Field2 need to have the field3 filled only one time, so what I expect at the end of treatment is the following:

Field1

Field2

Field3

A

B

Y

A

B

A

E

Z

A

E

A

E

A

M

V

To do so, I thought about creating a program with the following logic:

Sort itable by Field1 Field2.

Loop at itable into wa.

Concatenate wa-field1 wa-field2 into var1

If wa-field3 is not initial.

Concatenate wa-field1 wa-field2 into var2.

Endif.

If var1 ne var2.

Clear wa-field3.

Endif.

Endloop.

What do you think? Are they any simple ways to do it.

Thanks for your support.

Amine