HI All ,
With reference to below code how can i use for all entries in this case.
As i need to compare with one of the field from the table that is used for all entreis.
i.e t_atab-yycatal <> ' '. this also should be condired.
So in this case how can i use for all entries command.
*********************************************************************
LOOP AT t_atab.
IF t_atab-yycatal <> ' '.
SELECT bkbetr bkpein b~konwa INTO (t_atab-kbetr_pr00, t_atab-kpein_pr00, t_atab-konwa_pr00)
FROM a528 AS a
INNER JOIN konp AS b
ON aknumh = bknumh
WHERE a~yycatal = t_atab-yycatal
AND a~kschl = 'PR00'
AND a~datbi >= sy-datum
AND a~datab <= sy-datum
AND a~vkorg = t_atab-vkorg
AND a~vtweg = t_atab-vtweg.
ENDSELECT.
MODIFY t_atab.
endloop.
******************************************************
Any input will be helpful
Regards,
Guru