topic Re: how do i correct this code ? in Application Development and Automation Discussions

how do i correct this code ?

Former Member — Tue, 08 Aug 2006 16:18:32 GMT

Hello all,

i used this code piece,


select * from bkpf into t_bkpf where bldat in s_bldat and blart = 'KZ'.

select * from bseg into wa_bseg where belnr = t_bkpf-belnr.

append wa_bseg into t_bseg.

endselect.

endselect.

which i changed to sumthing lyke,



select * from bkpf into t_bkpf where bldat in s_bldat and blart = 'KZ'.

select * from bseg into t_bseg for all entries in t_bkpf where belnr = t_bkpf-belnr.

endselect.

endselect.

but i get nothing ... why and what is the correct code ?

Re: how do i correct this code ?

Former Member — Tue, 08 Aug 2006 16:21:24 GMT

Select * from bkpf into table t_bkpf

where bldat in s_bldat

and blart = 'KZ'.

if sy-subrc = 0.

select * from bseg into table t_bseg

for all entries in t_bkpf

where belnr = t_bkpf-belnr.

endif.

Re: how do i correct this code ?

Former Member — Tue, 08 Aug 2006 16:22:19 GMT

hi,

declare two work areas like wa_bkpf, wa_bseg. do like this:

select * from bkpf into wa_bkpf where bldat in s_bldat and blart = 'KZ'.

append wa_bkpf to t_bkpf.

select * from bseg into wa_bseg for all entries in t_bkpf where belnr = t_bkpf-belnr.

append wa_bseg to t_bseg.

endselect.

Re: how do i correct this code ?

Former Member — Tue, 08 Aug 2006 16:22:32 GMT

Message was edited by: Michael Malvey

Re: how do i correct this code ?

Former Member — Tue, 08 Aug 2006 16:23:06 GMT

Message was edited by: Michael Malvey