Filtering BKPF based on business area [GSBER]

Hi,

I’m filtering BSEG basing on the field [GSBER] which contains the business area. I can remove approx. 80% of the rows of BSEG via filtering the business areas which I don’t need.

BKPF does not contain the [GSBER] field. So far I was doing a join of the two tables while keeping all rows from the filtered BSEG and only the matching from BKPF.

So far so good, the issue is that I have entries in BKPF which do not have any items in BSEG, so I miss them when joining on only matching rows of BSEG.

Is there any way to filter BKPF based on the business area?

Thanks in advance