topic Re: Regarding Select Quirey in Application Development and Automation Discussions

Regarding Select Quirey

Former Member — Tue, 17 Jul 2007 06:18:08 GMT

Hi all,

I am having one issue,

In one table I am having the Orders Numbers along the date of creation.

In selection screen I have From and TO date.

1.I want to retrive the Order Numbers in Between From and to Date.

2.And another requirement is I want to retrive the order numbers prior to from

date,

I am not getting how to write the select quirey for these requirements.

Regards,

sarath

Re: Regarding Select Quirey

Former Member — Tue, 17 Jul 2007 06:21:02 GMT

1.I want to retrive the Order Numbers in Between From and to Date.

select VBELN ERDAT AUDAT from VBAK into table Itab where AEDAT in S_DATE.

2.And another requirement is I want to retrive the order numbers prior to from

date.

select VBELN ERDAT AUDAT from VBAK into table Itab

where AEDAT < S_DATE-low.

Try this and see

Reward points for useful Answers

Regards

Anji

Re: Regarding Select Quirey

Former Member — Tue, 17 Jul 2007 06:21:04 GMT

hi,

Select-options:s_date for vbak-erdat

select vbeln

from vbak

into table it_vbak

where vbeln in s_date.

Here i have taken sales order number as an example.

Re: Regarding Select Quirey

Former Member — Tue, 17 Jul 2007 06:22:25 GMT

1)select Order Numbers from <ztable>

into itab

where ztable-date in s_range.

s_range is type date in selecy options

2)select Order Numbers from <ztable>

into itab

where ztable-date < (from date)

regards

ravish

reward if useful

Re: Regarding Select Quirey

Former Member — Tue, 17 Jul 2007 06:29:32 GMT

Hi,

use like this.

tables:mara.

SELECT-OPTIONS:s_date for mara-ersda.

data:BEGIN OF itab OCCURS 0,

matnr type mara-matnr,

ersda type mara-ersda,

END OF itab.

SELECT matnr ersda from mara into CORRESPONDING FIELDS OF TABLE itab where ersda in s_date.

sort itab by ersda.

loop at itab.

write:/ itab-matnr,itab-ersda.

endloop.

reward if helpful

rgds,

bharat.