2019 Oct 30 2:57 PM
Hello,
I have an infoset based on 2 tables join , say TABLEA left join TABLEB. Is there a way to fillter out certain records from TableB BEFORE table joining? Problem is, when I use Extras/Coding (CHECK TABLEB-FIELD <somecondition>), it removes records AFTER join being processed. That way records not meeting <somecondition> are completely removed from the result. In short: I need to include to the final set also those records from TABLEA having TABLEB-FIELD empty, even though there is match in TABLEB, but not meeting <somecondition>. Is it possible? Thanks for ideas.
Daniel
2019 Oct 30 9:27 PM
In addition to Sandra's answer, a database view might also be an option, depending on what <some conditon> is exactly. We can create views in SE11 joining multiple tables and specifying the selection conditions right there. Then we can use the view in the infoset, just like a database table. As a bonus, you won't even need to maintain JOIN in the infoset in this case - it's already handled by the view.
2019 Oct 30 3:30 PM
You may code your SELECT in ABAP by using the integrated program (or you may use an external program if you have a developer key)
2019 Oct 30 9:27 PM
In addition to Sandra's answer, a database view might also be an option, depending on what <some conditon> is exactly. We can create views in SE11 joining multiple tables and specifying the selection conditions right there. Then we can use the view in the infoset, just like a database table. As a bonus, you won't even need to maintain JOIN in the infoset in this case - it's already handled by the view.