How to implement For each clause

[wsidihida]

Hello everyone. Please I need your help on this.

I have this 6 columns input and I want to create the column "auto-liquidation" that has a yes if Flag TVA = yes and ACHAT/VENTE = "Achat" and for each BELNR if there are two HKONT lignes "4456" and "4457" and 4456=-4457 then it's a yes else it's a no.

My issue is that I don't know how to implement the for each BELNR clause.

Can you please help me with this. It's urgent.

Thank you in advance.

[wsidihida]

Thank you for your help I appreciate it!