topic Re: itab selection in Application Development and Automation Discussions

itab selection

Former Member — Mon, 24 Mar 2008 08:09:37 GMT

hi,

i have some records in gt_bseg.

i want only those records whose shkzg value = 'H'.

so coded like this.

loop at gt_bseg into wa_bseg .

read table gt_bseg into wa_bseg with key shkzg = 'H' .

if sy-subrc = 0.

move : wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endif.

endloop.

loop at gth_bseg into wah_bseg.

write:/2(5) wah_bseg-BUKRS,8(10) wah_bseg-BELNR,20(8) wah_bseg-GJAHR,

30(3) wah_bseg-BSCHL,34(2) wah_bseg-SHKZG,37(2) wah_bseg-MwSKZ,40(9)

wah_bseg-WRBTR.

endloop.

but i am not getting the values . can any one help me?

Thanks

Santosini

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:12:25 GMT

Hi,

loop at gt_bseg into wa_bseg where shkzg = 'H' .

move-corresponding wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endloop.

Reward if helpful.

Regards,

Kumar

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:12:47 GMT

Hi,

loop at gt_bseg .

read table gt_bseg into wa_bseg with key shkzg = 'H' .

if sy-subrc = 0.

move : wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endif.

endloop.

loop at wah_bseg.

write:/2(5) wah_bseg-BUKRS,8(10) wah_bseg-BELNR,20(8) wah_bseg-GJAHR,

30(3) wah_bseg-BSCHL,34(2) wah_bseg-SHKZG,37(2) wah_bseg-MwSKZ,40(9)

wah_bseg-WRBTR.

endloop.

Now it works...

Re: itab selection

former_member210123 — Mon, 24 Mar 2008 08:13:18 GMT

instead try this.

DELETE TABLE internal_tab WITH TABLE KEY field ne 'H'.

Re: itab selection

former_member210123 — Mon, 24 Mar 2008 08:15:03 GMT

This would delete the pother entries and u can loop at the same internal table and have ur write commands asusal.This is simple way of doing it.

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:15:41 GMT

Use sort statement before loop.

sort gt_bseg by shkzg.

loop at gt_bseg into wa_bseg .

read table gt_bseg into wa_bseg with key shkzg = 'H' .

if sy-subrc = 0.

move : wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endif.

endloop.

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:17:29 GMT

use like that

loop at gt_bseg into wa_bseg .

read table gt_bseg into wa_bseg with key shkzg = 'H' .

if sy-subrc = 0.

move corresonding wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endif.

endloop.

Clear:wah_bseg. "need to clear the work area before loop.

loop at gth_bseg into wah_bseg.

write:/2(5) wah_bseg-BUKRS,8(10) wah_bseg-BELNR,20(8) wah_bseg-GJAHR,

30(3) wah_bseg-BSCHL,34(2) wah_bseg-SHKZG,37(2) wah_bseg-MwSKZ,40(9)

wah_bseg-WRBTR.

endloop.

Check the above code i think it will work for u...

Thanks

vipin

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:18:34 GMT

Hi,

Put a break point and check what are the values coming in the internal table for SHKZG. There is a possibility that a conversion routine is being used.

Check in the database table is there any conversion routine used. If yes then you have to use some conversion FM.

Reward if helpful.

Regards

Sourabh Verma

Re: itab selection

Former Member — Mon, 24 Mar 2008 08:43:29 GMT

Hi,

Check this code.


*loop at gt_bseg into wa_bseg . "comment this line.
read table gt_bseg into wa_bseg with key shkzg = 'H' .

if sy-subrc = 0.
move : wa_bseg to wah_bseg.
append wah_bseg to gth_bseg.
endif.

*endloop."comment this line.

Check it now and let me know,

if you still not gettin values then give the structure of the fields which you have mentioned.

Reward if helpful.

Regards.

Re: itab selection

Former Member — Mon, 24 Mar 2008 09:00:26 GMT

hi,

i tried all whatever you suggested but not getting the data.

there are 4 records in the gt_bseg itab.

but its not going inside the loop.

its not reading the data.

thanks

Santosini

Re: itab selection

Former Member — Mon, 24 Mar 2008 09:03:53 GMT

Hi,

Have you given the loop inside the

START OF SELECTION.

event ??

Reward if helpful.

Regards.

Re: itab selection

Former Member — Mon, 24 Mar 2008 09:07:54 GMT

loop at gt_bseg into wa_bseg .

if wa_bseg-shkzg = 'H' . *<-- write this instead of read *

*read table gt_bseg into wa_bseg with key shkzg = 'H' .

move : wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

endif.

endloop.

Re: itab selection

Former Member — Mon, 24 Mar 2008 09:09:43 GMT

Hi,

You do like this.

loop at gt_bseg into wa_bseg .

if wa_bseg-shkzg = 'H' .

move : wa_bseg to wah_bseg.

append wah_bseg to gth_bseg.

else.

continue.

endif.

endloop.

loop at gth_bseg into wah_bseg.

write:/2(5) wah_bseg-BUKRS,8(10) wah_bseg-BELNR,20(8) wah_bseg-GJAHR,

30(3) wah_bseg-BSCHL,34(2) wah_bseg-SHKZG,37(2) wah_bseg-MwSKZ,40(9)

wah_bseg-WRBTR.

endloop.

Reward.