the bollow select takes loooooooots of time to deliver a result. I know already that "join" is time consuming but is there any way to make this faster or the only way would be to gather the data in many single steps together. The other question is do you think it's a good idea to put the mara and marc in front ?
Ps: the "lc_qry" is a long string which would be built dyn.
SELECT mvkevkorg mvkevmsta marcmatnr marcwerks marccuobj marcstdpd mara~mtart
INTO CORRESPONDING FIELDS OF TABLE i_mtnr_ppl_sorg
FROM ( mvke
INNER JOIN marc
ON mvkematnr = marcmatnr
INNER JOIN mara
ON maramatnr = marcmatnr )