Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ATC and SAP Buffered Table

sandro2022
Explorer
0 Kudos
574

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?

 

1 REPLY 1

raymond_giuseppi
Active Contributor
542

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)