topic Selection screen critia. in Application Development and Automation Discussions

Selection screen critia.

Former Member — Wed, 19 Mar 2008 05:56:48 GMT

Hi all,

select-options: s1 for zuser-userid.

parameters: s2 like zuser-team.

parameters: s3 like zuser-role.

select zuser_{username zuser}password zuser_{userid enam zuser}team zuser~role report

into corresponding fields of table itab1 from zuser inner join zempmas on zuser_{userid = zempmas}emid

where zuser_{userid in s1 or zuser}team = s2 or zuser~role = s3.

its not display the output..

please check it...

thx,

s.suresh

Re: Selection screen critia.

Former Member — Wed, 19 Mar 2008 06:02:26 GMT

Hi,

1.put the break point at selection statement and check whether

data is existed for particular conditions OR not.

2.select zuser_{username zuser}password zuser_{userid enam zuser}team zuser~role report

into corresponding fields of table itab1 from zuser inner join zempmas on zuser_{userid = zempmas}emid

where zuser~userid in s1 or

zuser~team = s2 or

zuser~role = s2.

Is enam is from zuse? if yes write zuser~enam in select statement.

Re: Selection screen critia.

Former Member — Wed, 19 Mar 2008 06:03:36 GMT

Hi,

Try the Following query,

select zuser~username zuser~password zuser~userid enam zuser~team zuser~role report
into corresponding fields of table itab1 from zuser inner join zempmas on zuser~userid = zempmas~emid
where zuser~userid in s1 and
          ( zuser~team = s2 or zuser~role = s3 ).

Regards,

Balakumar.G.

Reward Points if helpful.

Re: Selection screen critia.

Former Member — Wed, 19 Mar 2008 06:05:27 GMT

hi,

try the following

select Z~username

Z~password

Z~userid

E~enam

Z~team

Z~role report

into corresponding fields of table itab1 from zuser as Z inner join zempmas as E on Z_{userid = E}emid

where Z_{userid in s1 or Z}team = s2 or Z~role = s3.

Re: Selection screen critia.

ak_upadhyay — Wed, 19 Mar 2008 06:06:32 GMT

Hi,

Try This....

select zuser~username

zuser~password

zuser~userid

zuser_{enam zuser}team

zuser_{role zuse}report

into corresponding fields of table itab1 from zuser inner join zempmas on zuser_{userid = zempmas}emid

where zuser~userid in s1

or zuser~team = s2

or zuser~role = s3.

Reward points if helpful...

Regards

Re: Selection screen critia.

vinod_vemuru2 — Wed, 19 Mar 2008 06:08:51 GMT

Hi Suresh,

First check the tables whether u have any data exist for ur selection criteria.

Few things u can change.

1. Avoid in to corrosponding fields.

2. JOINS are very slow. So go for for all entries.

Check below code.

SELECT all key fields and emid

INTO TABLE itab1

FROM zempmas

WHERE emid IN s1.

CHECK NOT itab1 IS INITIAL.

SORT itab1 BY emid.

select username password userid team role

into table itab2

from zuser

FOR ALL ENTRIES IN itab1

WHERE userid = itab1-emid

AND ( team = s2 or role = s3 ).

I dont understand the bold ones below in ur select.

select zuser_{username zuser}password zuser~userid

enam zuser_{team zuser}role report

Thanks,

Vinod.

Re: Selection screen critia.

Former Member — Wed, 19 Mar 2008 06:14:23 GMT

Hi,

Since userid is primary key for ur table, i guess that should be mandatory in where condition.

So, use AND for that.

Reward if helpful.

Regards,

ramya

Re: Selection screen critia.

Former Member — Wed, 19 Mar 2008 06:25:55 GMT

Hi,

Change the format as below.


select-options: s1 for zuser-userid.
select-options: s2 for zuser-team no intervals no extension. "Change
select-options: s3 for zuser-role no intervals no extension. "change

select zuser~username zuser~password zuser~userid enam zuser~team zuser~role report
into corresponding fields of table itab1 from zuser inner join zempmas on zuser~userid = zempmas~emid
where zuser~userid in s1 
and zuser~team in s2  "change
and zuser~role in s3. "change