topic Re: ragarding select-options in Application Development and Automation Discussions

ragarding select-options

Former Member — Thu, 24 Jul 2008 05:00:53 GMT

hai friends,

i have designed a selection-screen with the date range, bcz user wants to select the data pertaining to the given dates. so for this plz refer my code as follows.

SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME TITLE text-000.

SELECT-OPTIONS : s_date FOR ztbukxxin003-z_manufdate.

SELECTION-SCREEN END OF BLOCK blk1.

CLEAR : tab_ztbukxxin003.

SELECT z_manufdate z_thonum z_ndsnum z_digicard

FROM ztbukxxin003

INTO TABLE tab_ztbukxxin003.

WHERE z_manufdate IN s_date.

IF syst-subrc = 0.

SORT tab_ztbukxxin003 BY z_manufdate z_thonum z_ndsnum.

ENDIF.

so in this the issue is when i am not using where clause in my select query i am getting the records but not according to the given dates(i.e.i am getting the records beyond the dates even).and when i write the select query with where clause i am not getting the records into the internal table itself.of-course i have the records pertaining to the date range in my database table.

can anybody give the solution for this.

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 05:06:38 GMT

SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME TITLE text-000.

SELECT-OPTIONS : s_date FOR ztbukxxin003-z_manufdate.

SELECTION-SCREEN END OF BLOCK blk1.

CLEAR : tab_ztbukxxin003.

SELECT z_manufdate z_thonum z_ndsnum z_digicard
FROM ztbukxxin003
INTO TABLE tab_ztbukxxin003
WHERE z_manufdate IN s_date.

IF syst-subrc = 0.
SORT tab_ztbukxxin003 BY z_manufdate z_thonum z_ndsnum.
ENDIF.

u r table z_manufdate z_thonum z_ndsnum z_digicard has only those four fields if so it will work for sure

Re: ragarding select-options

former_member195383 — Thu, 24 Jul 2008 05:09:15 GMT

SELECT z_manufdate z_thonum z_ndsnum z_digicard

FROM ztbukxxin003

INTO TABLE tab_ztbukxxin003.

WHERE z_manufdate GE s_date-low

and z_manufdate LE s_date-high.

try the above query..

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 05:13:02 GMT

Hi Mahesh,

check the date format in debug mode... i guess it is not the same format as in the database.

regards

padma

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 06:03:09 GMT

hi sunil,

no my table has 24 fields.in that i have taken only four fields as per the technical specification. so in this case what i have to do.should i use into corresponding fields in select quert or anything else.

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 06:04:47 GMT

hi padma,

that is not the reason.bcz if i comment the where clause then i am getting the records.

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 06:19:53 GMT

Hi,

Try this...

SELECT z_manufdate z_thonum z_ndsnum z_digicard

FROM ztbukxxin003

INTO CORRESPONDING FIELDS OF TABLE tab_ztbukxxin003

WHERE z_manufdate IN s_date.

Regards,

Sathish.

Re: ragarding select-options

Former Member — Thu, 24 Jul 2008 12:50:18 GMT

Hi,

If you comment the where clause you will definitely get all the values from database.

What i want you to check is the internal date format into which the system is converting may be different... so i wanted you to check in debug mode at the time of comparision of dates.

regards

padma