List of batch header with company field

I need to get a list of all existing batches in JDE with the batch number (ICU), batch type (ICUT), and company (KCO). Since the batch header file (F0011) does not have the company field I was planning on getting this data either from multiple tables (F0411, F03B11 ...) or from the F0911 (but this table is huge).

Can anyone provide some recommendations as to how to run an SQL to get that data? I don’t want to this to have a negative impact on performance as the sql runs. Thanks in advance for your time and help.

OK, I didn't go to the 911 and the other tables (411, 3B11, 3B14, 413) return the output very fast by not usind the distinct keyword but grouping instead.