Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQ02 infoset - filter table records BEFORE join

dajan
Discoverer
0 Kudos
1,145

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

1 ACCEPTED SOLUTION

Jelena_Perfiljeva
Active Contributor
0 Kudos
676

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.

2 REPLIES 2

Sandra_Rossi
Active Contributor
676

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)

Jelena_Perfiljeva
Active Contributor
0 Kudos
677

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.