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
