topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 18 Oct 2007 07:34:05 GMT

sir

i correct my query but it is not give correct answer.

ables: bkpf, bseg.

select-options: budat for bkpf-budat.

select * from bkpf into bkpf where budat between '20070820' and '20071020'.

select * from bseg.

write:/, bkpf-budat,20 bkpf-blart,30 bseg-bschl,40 bseg-hkont.

endselect.

ritu

Re: report

Former Member — Thu, 18 Oct 2007 07:42:38 GMT

Hi,

I got a list. Try to optimize your selection.

tables: bkpf, bseg.

select-options: budat for bkpf-budat.

select * from bkpf where budat in budat.

select * from bseg where belnr eq bfkp-belnr.

write:/, bkpf-budat,20 bkpf-blart,30 bseg-bschl,40 bseg-hkont.

endselect.

Regards

Nicole

Re: report

varma_narayana — Thu, 18 Oct 2007 07:44:33 GMT

Hi Reetu..

Why are u using the Nested SELECT statments.. It will give worst performance .

Better convert these queries using FOR ALL ENTRIES

Sample code:

select-options: budat for bkpf-budat.

select * from bkpf into TABLE IT_bkpf where budat between '20070820' and '20071020'.

If it_bkpf IS not initial.

select * from bseg into table IT_BSEG

FOR ALL ENTRIES IN IT_BKPF

WHERE <CONDITION OF COMMON FIELDS>.

Endif.

Reward if Helpful.

Re: report

Former Member — Thu, 18 Oct 2007 07:44:39 GMT

Hi ritu,

try it like this:

tables: bkpf, bseg.

select-options: budat for bkpf-budat.

select * from bkpf where budat between '20070820' and '20071020'.

select * from bseg where belnr = bkpf-belnr.

write:/ bkpf-belnr, bkpf-budat,20 bkpf-blart,30 bseg-bschl,40 bseg-hkont.

endselect.

Regards, Dieter

Re: report

Former Member — Thu, 18 Oct 2007 07:49:28 GMT

Hi Ritu,

Try this.

select-options: budat for bkpf-budat.

select * from bkpf into TABLE IT_bkpf where budat between '20070820' and '20071020'.

If not it_bkpf IS initial.

select * from bseg into table IT_BSEG

FOR ALL ENTRIES IN IT_BKPF

WHERE <CONDITION >.

Endif.

Incase if u want to include these '20070820' and '20071020' dates also in the check then between will not work.

use this :

select * from bkpf into TABLE IT_bkpf where budat GE '20070820' and budat LE '20071020'.

Reward if Useful.

Regards,

Chitra