Selection screen critia.

[Former Member]

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

[Former Member]

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 

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[ak_upadhyay]

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

AK

[vinod_vemuru2]

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.

[Former Member]

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

[Former Member]

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