topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Sat, 19 Jul 2008 05:09:51 GMT

Hi friends,

I need to display all the documents up to date(i.,e <= that date) mention on selection-screen.How can I proceed?

Thanks in advance.

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:15:50 GMT

Hi Hosmath,

Try this.

Select *

from <dbtable>

where t_date LE s_date.

s_date - from selection screen.

Hope this helps you.

Regards,

Chandra Sekhar

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:17:52 GMT

hi,

First find the Date field of your table.

then Apply the following Code.

select * from <table>

Into table <itab>

where date-field LE <sel screen field>

Regards

Sumit Agarwal

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:21:47 GMT

hi,

I have code like this.....

TABLES:zfi_way_bill.

TYPE-POOLS:slis.

TYPES:BEGIN OF ty_tab,

bill_no TYPE zfi_way_bill-bill_no,

issued_on TYPE zfi_way_bill-issued_on,

issued_to TYPE zfi_way_bill-issued_to,

vendor TYPE zfi_way_bill-vendor,

customer TYPE zfi_way_bill-customer,

bill_status TYPE zfi_way_bill-bill_status,

END OF ty_tab.

DATA:it_tab TYPE STANDARD TABLE OF ty_tab INITIAL SIZE 0 WITH HEADER LINE,

wa_tab TYPE ty_tab.

DATA: i_repid LIKE sy-repid,

i_lines LIKE sy-tabix.

DATA: i_fcat TYPE slis_t_fieldcat_alv.

DATA: wa_fieldcat TYPE slis_fieldcat_alv.

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

PARAMETERS:co_code TYPE bukrs DEFAULT '5000'.

SELECT-OPTIONS:date FOR zfi_way_bill-issued_on NO INTERVALS NO-EXTENSION.

SELECTION-SCREEN:END OF BLOCK b1.

SELECT bill_no

issued_on

issued_to

vendor

customer FROM zfi_way_bill INTO TABLE it_tab WHERE issued_on IN date AND bill_status EQ '1'.

describe table it_tab lines i_lines.

if i_lines lt 1.

write: / 'NO RECORDS FOUND'.

exit.

endif.

i want to fetch all the details up to the date my client enters on selection-screen.

Hope I'm clear with my requirement........

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:22:22 GMT

Hi,

in where condition of your select query give

date_field LE p_date as also told by others where p_date is your user input on the selection screen

With luck,

Pritam.

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:28:17 GMT

hi,

Instead of In clause use

Where <field> BETWEEN date-low AND date-high...

That will Do.

Regards

Sumit Agarwal

Re: Select Statement

Former Member — Sat, 19 Jul 2008 05:47:23 GMT

Thanks guys......