topic Re: doubt in selection in Application Development and Automation Discussions

doubt in selection

Former Member — Thu, 15 Jun 2006 17:36:30 GMT

Hi folks,

I want to pick the data from payr table where pridt(creation date) IN sel_cpud ( selection screen field)and

voidd > sel_cpud.

I mean , i need to get checks from payer for the period of creation date and need to include voided checks whose void date is greater than creation date which we enter in selection screen.

How to write a query.

thanks in advance.

regards

Vishal

Re: doubt in selection

Former Member — Thu, 15 Jun 2006 17:39:38 GMT

If i say

select * from payr where pridt IN sel_cpud

AND voidd > sel_cpud , its not picking any data even data is avilable between this pridt period which we enter in selection screen.

Re: doubt in selection

Former Member — Thu, 15 Jun 2006 17:45:17 GMT

Hi vishal,

select f1 f2 ... from payr into table itab where

pridt in se_cpud.

loop at itab.

delete itab where voidd < sel_cpud.

endloop.

hope this helps.

reward if helpful.

regards,

keerthi.

Re: doubt in selection

RichHeilman — Thu, 15 Jun 2006 17:47:14 GMT

You will need a second parameter field on your screen for "Voided Check Date Cutoff".

parameters: p_vccd type sy-datum.

select * from payr 
   where pridt IN sel_cpud
     AND voidd > p_vccd.

Regards,

Rich Heilman

Re: doubt in selection

Former Member — Thu, 15 Jun 2006 17:47:17 GMT

You have to use OR not AND. Also, 'voidd > selcpud' will not work because selcpud is a select option. So if the user enters a range of dates, are you saying your voided date should be greater than every one of them? Think again if it makes sense. If it is a single date(parameter) entered in the selection screen, then it is ok no if it is a range.

Re: doubt in selection

abdul_hakim — Thu, 15 Jun 2006 17:47:37 GMT

hi you cannot use > if your selection screen field is a defined using SELECT-OPTIONS.

if it is defined using PARAMETERS then your code should look like

select * from payr into table int_payr where pridt eq sel_cpud and voidd gt sel_cpud.

if you have defined the SELECT-OPTIONS then your code should look like.

RANGES r_voidd FOR payr-voidd.

START-OF-SELECTION.

LOOP AT SEL_CPUD.

MOVE: SEL_CPUD-LOW TO R_VOIDD-LOW,

SEL_CPUD-HIGH TO R_VOIDD-HIGH,

'EQ' TO R_VOIDD-OPTION,

'I' TO R_VOIDD-SIGN.

APPEND R_VOIDD.

ENDLOOP.

select * from payr into table int_payr where pridt in sel_cpud and voidd in R_VOIDD.

Cheers,

Abdul Hakim