E9.2 MCU Price Comparisons F4106

[FrankCLT]

Hello,

I have been tasked to automate a process in which a user does a comparison of an Item in MCU 1 to Item in MCU 2 and updates the Item in MCU 1 from MCU 2 if prices are different.

I'm having a mental block in reading the data from the same file for different MCU's and doing the comparisons, any ideas..?

Thanks in advance,
FrankCLT

 

[AnkurSanghi]

Sounds like you need a view with 2 instances of F4106 where table1.item = table2.item and table1.mcu != table2.mcu.