topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Tue, 17 Jul 2007 12:26:08 GMT

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

Re: Report

Former Member — Tue, 17 Jul 2007 12:28:18 GMT

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

s_dte is ur slection screen date field.

regards

ravish

plz reward if useful

Re: Report

Former Member — Tue, 17 Jul 2007 12:29:39 GMT

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

Re: Report

Former Member — Tue, 17 Jul 2007 12:30:52 GMT

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

where vdatu ne p_data.

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

Thanks

Seshu

Re: Report

Former Member — Tue, 17 Jul 2007 12:30:53 GMT

select-options:

s_date for ztable-date.

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

Regards,

Pavan.

Re: Report

Former Member — Tue, 17 Jul 2007 12:31:27 GMT

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.

Re: Report

Former Member — Tue, 17 Jul 2007 12:40:08 GMT

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

Re: Report

Former Member — Tue, 17 Jul 2007 12:51:01 GMT

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 -> then select not equal

reward points if use ful

regards

suman