2024 Apr 02 3:33 PM
Hello Experts, I recently started using ATC checks to make my application perfect. Right now one of the warnings is like:
SELECT statements that bypass the SAP table buffer
SELECT tgsb~gsber, gtext FROM tgsb JOIN tgsbt ON tgsb~gsber EQ tgsbt~gsber
INTO CORRESPONDING FIELDS OF TABLE @main->it_gsber WHERE spras EQ @SY-langu.
my code is:I need to select gsber and its name from tgsb and tgsbt do you have how can I make this select better not to bypass buffer?
2024 Apr 02 4:05 PM
From SELECT online documentation you could find that JOIN expressions currently always bypass the buffer. So you could remove the join, actually you don't need it as every field is available in the text table (exception: if some translations are missing, but you didn't use an explicit OUTER JOIN)