Select Where condition proble

[Former Member]

Hi Experts....

Iam doing a report , where i need to fetch data from

PA30 and display in ALV format,

with basic conditions like

Emp no within select option

and Start Date and End Date from the parameters .

My problem is if i comment the begda and endda in select option

its fetching data

but if i dont its not populating any values

ie. its not satisfying my begda and endda criteria ...y is it so

my SELECT STATEMENT

========================

Select pernr begda endda rtamt from pa0581

into corresponding fields of table it_pa0581

where pernr in so_pernr and

begda = pr_begda and

endda = pr_endda .

Thankx in advance

Regards

Rachel Arun

[Former Member]

Hi,

try this.

Select pernr begda endda rtamt from pa0581

into corresponding fields of table it_pa0581

where pernr in so_pernr and

begda in pr_begda and

endda in pr_endda .

if you declare parameters in selection screen and if its value is space

then your sy-subrc will fail for select statement.

[JozsefSzikszai]

you have to modify the conditions:

...begda >= pr_begda and
endda <= pr_endda .

[Former Member]

Hi Eric

Thank u so much for your timely help by responding ....

Regards

Rachel

[GauthamV]

Hi,

try this.

Select pernr begda endda rtamt from pa0581

into corresponding fields of table it_pa0581

where pernr in so_pernr and

begda in pr_begda and

endda in pr_endda .

if you declare parameters in selection screen and if its value is space

then your sy-subrc will fail for select statement.

[Former Member]

HI,

I cannot find anything wrong with ur select statement.Try ou these

1.Check for the selection criteria ur entering values are there ion the infotype

2.Check whether ur table begda,endda fields and the field in the parameter are of same type.