problem with select...endselect using for all entries and work area

[Former Member]

Hi guys,

Is it possible to have this kind of code? how does it behave? will it read the table gt_pos_posted one by one? we're having problem with this since it takes a lot of time. we got a time_out error. Thanks!

SELECT * FROM bseg INTO wa_bseg FOR ALL ENTRIES IN gt_pos_posted

WHERE bukrs = gt_pos_posted-bukrs

AND belnr = gt_pos_posted-belnr

AND gjahr = gt_pos_posted-gjahr

AND buzei = gt_pos_posted-buzei.

IF wa_bseg-shkzg = 'H'.

wa_bseg-menge = wa_bseg-menge * ( -1 ).

ENDIF.

ENDSELECT.

[Former Member]

Hi guys,

Is it possible to have this kind of code? how does it behave? will it read the table gt_pos_posted one by one? we're having problem with this since it takes a lot of time. we got a time_out error. Thanks!

SELECT * FROM bseg INTO wa_bseg FOR ALL ENTRIES IN gt_pos_posted

WHERE bukrs = gt_pos_posted-bukrs

AND belnr = gt_pos_posted-belnr

AND gjahr = gt_pos_posted-gjahr

AND buzei = gt_pos_posted-buzei.

IF wa_bseg-shkzg = 'H'.

wa_bseg-menge = wa_bseg-menge * ( -1 ).

ENDIF.

ENDSELECT.

[Former Member]

yes, it will read entries one by one, and then you have select.. end select too.

better use select ....into table <...> to do an array fetch into the internal table

[Former Member]

Thanks a lot for that quick response!

would you know if there is any sap notes to get rid of this error since this a sap standard program for transaction FBL3N?

Thanks again!