Other way instead of for all entries.

[former_member478603]

I am fetching maintenance items from table MPOS and then using for all entries i am fetching WARPL from MPLA.

I can also use inner join instead of for all entries.

What can i handle this using new abap syntax rather than for all entries.

Select * from MPOS.

SElect * from MPLA for all entries in MPLA where warpl = mpla-warpl.

[FredericGirod]

Your code will not compile, could you correct it before asking for optimisation ?