topic Re: Data selection from selection screen in Application Development and Automation Discussions

Data selection from selection screen

Former Member — Tue, 01 Aug 2006 04:45:56 GMT

Hi,

This is my code.

SELECT pernr usrid FROM pa0105 INTO TABLE t_pa0105

FOR ALL ENTRIES IN t_bseg

WHERE pernr = t_bseg-pernr AND

subty = c_9int AND

usrty = c_9int AND

begda <= p_endda AND

endda >= p_begda.

Iam unable to get the values , for the specified dates?

Example: if i want to display data only from 01/08/2006 to 08/08/2006. It's not displaying. Its showing all the related data from all dates. I want data for the selected dates only.

Can you help me friends.

Re: Data selection from selection screen

Former Member — Tue, 01 Aug 2006 04:49:39 GMT

Hi Manju,

If you are getting your date in using Select Options then use <b>IN</b> in your select query, than using <= or >=.

Hope thuis might help you.

Regards,

Prashanth

Re: Data selection from selection screen

dani_mn — Tue, 01 Aug 2006 04:54:33 GMT

HI,

Check the date format in the p_begda and p_endda.

is this the same format for which you are querying or not.

and try this query.

<b>SELECT pernr usrid FROM pa0105 INTO TABLE t_pa0105
FOR ALL ENTRIES IN t_bseg
WHERE pernr = t_bseg-pernr AND
subty = c_9int AND
usrty = c_9int AND
begda >= p_begda AND
endda <= p_endda.</b>

Regards,

Wasim Ahmed

Re: Data selection from selection screen

Former Member — Tue, 01 Aug 2006 05:22:21 GMT

Hi Manju

You have to modify the Code as follow:-

SELECT pernr usrid FROM pa0105 INTO TABLE t_pa0105

FOR ALL ENTRIES IN t_bseg

WHERE pernr = t_bseg-pernr AND

subty = c_9int AND

usrty = c_9int AND

begda ge p_endda AND

endda le p_begda.