topic Correct Select in ABAP in Application Development and Automation Discussions

Correct Select in ABAP

Former Member — Tue, 20 Jun 2017 09:16:11 GMT

Hi,

i have a problem regarding a select statement in ABAP. I need to pick all equipments from table EQUI who have an related measuring point (IMPTT. link between tables is equi-objnr and imptt-mpobj).

I thought of an inner join, but this is not the right way. There are 170 entries in equi but only the last two have measuring points. Each one has for. So mir output of itab has 8 entries.

select equi~equnr equi~objnr imptt~mpobj
  into CORRESPONDING FIELDS OF table itab
  from equi inner JOIN imptt ON  equi~objnr = imptt~mpobj.

Has anybody a suggestion for me how to pick the equipments correctly?

Thanks

Re: Correct Select in ABAP

retired_member — Tue, 20 Jun 2017 09:44:03 GMT

Use a subquery in the WHERE condition, WHERE EXISTS?

Re: Correct Select in ABAP

Former Member — Tue, 20 Jun 2017 10:31:30 GMT

Thanks a lot. Was the right hint.

My correct working select query now looks like:

select * from equi into CORRESPONDING FIELDS OF table itab
  where objnr in (
  select imptt~mpobj
  from imptt inner JOIN equi ON ( equi~objnr = imptt~mpobj )
  ).