Report

[Former Member]

hi to all viwers(URGENT)

Q1.in selection-screen i am putting one date and i want to list except selected date. how solve this this issues.

thanks and reward also.

regard : deep

[Former Member]

hi

select * from ztable into itab where ztable-date not in s_date.

s_dte is ur slection screen date field.

regards

ravish

<b>plz reward if useful</b>

[Former Member]

Hi Deep,

select all the data irrespective of the date.

then delete the data having the selected date.

Regards,

Sree.

PS: Reward points if Useful

[Former Member]

you have query like :

tables : vbak.

data i_vbak like vbak occurs 0 with header line.

parameters p_date like sy-datum.

start-of-selection.

select * from vbak into table i_vbak

<b> where vdatu ne p_data.</b>

here i am using ne,it gets all data except that date.

Thanks

Seshu

[Former Member]

select-options:

s_date for ztable-date.

select * from ztable into itab where ztable-date not in s_date.

Regards,

Pavan.

[Former Member]

u can do like

SELECT * from table into t_table

where date not in s_date.

or else u can get the list of data and can delete from the list...

delete table t_table where date in s_date

Reward if usefull.

[Former Member]

HI,

if u are using select option then try like this,

in INITIALIZATION event.

s_date-sign = 'E'.

s_date-option = 'BT'.

s_date-low = 'starting date'.

s_date-high = 'ending date'.

SELECT * FROM MARA INTO TABLE I_MARA WHERE DATE IN S_DATE.

OR try like this if u use a parameter.

parameter: p_date like sy-datum.

select * from ztable into itab where date not in p_date.

if helpful reward some points.

with regards,

Suresh.A

[Former Member]

Hi,

initialize your select option like

s_date-low = ''

s_date-high=''

s_date-sign = 'I'.

S_date-option = 'NE'

modify s_date.

and write query select * from

table

where vbeln in s_vbeln.

or click select option button <b>-></b> then select not equal

reward points if use ful

regards

suman