topic Re: select data where le date in Application Development and Automation Discussions

select data where le date

Former Member — Mon, 25 Dec 2006 09:03:15 GMT

Hi,

I have a select option (DTE) for date on selection screen. Now i want extract data from DB table to internal table where all dates shlod be LE from givin date in select option

my select statment is :

SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF TABLE ITAB_VBRK

WHERE KUNRG IN CUST_NO AND FKDAT IN DTE.

i m getiing data only EQ givin date. but i need all dates wich r LE from givin date.

From Jitendra

Re: select data where le date

Former Member — Mon, 25 Dec 2006 09:15:17 GMT

Actually you should be rather using a parameter instead of a selec option.

Anyway with a SELECT OPTION you code should be:

SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF TABLE ITAB_VBRK

WHERE KUNRG IN CUST_NO

AND FKDAT LT DTE-LOW.

Re: select data where le date

Former Member — Mon, 25 Dec 2006 09:16:30 GMT

hi ,

Welcome to SDN,,


SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF
 TABLE ITAB_VBRK
WHERE KUNRG IN CUST_NO AND FKDAT LE DTE-Low .

"chk this

pass the select-option value of dte into a variable and substitute this variable in the where clause .

will fetch u the records from Db for Date LE from date of ur selection screen.

LE -->

or LT--> for the date

hope this helps ,

regards,

vijay

Re: select data where le date

Former Member — Mon, 25 Dec 2006 09:18:19 GMT

Hi jitendra,

SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF TABLE ITAB_VBRK

WHERE KUNRG IN CUST_NO AND FKDAT IN DTE-LOW.

check with this code it will work.

Re: select data where le date

Former Member — Mon, 25 Dec 2006 09:27:45 GMT

tables: vbrk.
select-options : dte for vbrk-fkdat.
*                 cust_no for vbrk-kunrg.
data : begin of itab_vbrk occurs 0,
       vbeln like vbrk-vbeln,
       fkdat like vbrk-fkdat,
       kunrg like vbrk-kunrg,
       bstnk_vf like vbrk-bstnk_vf,
       end of itab_vbrk.
SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF
 TABLE ITAB_VBRK
WHERE  FKDAT LE DTE-low .

sort itab_vbrk by fkdat descending.
loop at itab_vbrk.
write:/ itab_vbrk-vbeln,
        itab_vbrk-fkdat.
endloop.

check this code ...

regards,

vijay

Re: select data where le date

Former Member — Tue, 26 Dec 2006 02:22:20 GMT

HI Jitendra

As highlighted by Sharath, do declare the date as PARAMETER instead of select options and use as below:

PARAMETERS: DTE TYPE FKDAT.

SELECT VBELN FKDAT KUNRG BSTNK_VF FROM VBRK INTO CORRESPONDING FIELDS OF TABLE ITAB_VBRK

WHERE KUNRG IN CUST_NO AND FKDAT LE DTE.

If the requirement is to use SELECT-OPTION, then ask the users to input the date in HIGH instead of LOW. In that case, your select statement will work.

Kind Regards

Eswar

Re: select data where le date

Former Member — Tue, 26 Dec 2006 04:21:57 GMT

Hi ,

An example of how this will work is as given below

Data : it_1 type table of mara.

select-options : s_matnr for mara-ersda.

data : r_matnr like line of s_matnr.
start-of-selection.

loop at s_matnr into r_matnr.
 r_matnr-option = 'LE'.
 modify s_matnr from r_matnr.

endloop.


select * into table it_1
from mara
where ersda in s_matnr.
data : wa like line of it_1.
loop at it_1 into wa .
write:/ wa-matnr.

endloop.

What this code will do is select all the materials from MARA where ERSDA is less than or equal to s_matnr-low.

Try this and if you have any queries please do revert back.

Regards

Arun