topic Re: Problem with Select statement. in Application Development and Automation Discussions

Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:24:39 GMT

DATA: wa_usr05 TYPE usr05.

The select statement always gives sy-subrc = 0

even if there is no entry with parid = 'ZRD'.

On successful it fills the structure wa_usr05 as

MANDT C 3 ACC

BNAME C 12 SCL

PARID C 20 X

PARVA C 18

but mandt is 310.

USR05 is a pool table and has mandt field.

SELECT SINGLE bname

parid

parva

FROM usr05

INTO wa_usr05

WHERE bname = sy-uname AND

parid = 'ZRD' AND

parva = 'x' OR parva = 'X'.

Let me know the reason and solution to the problem.

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:30:22 GMT

SELECT SINGLE * FROM usr05
INTO wa_usr05
WHERE bname = sy-uname AND
parid = 'ZRD' AND
parva = <b>'X'</b> .

Use single * as u have defined the wa+usr05 as usr05.

Else.

DATA: i_usr05 TYPE STANDARD TABLE of usr05.
SELECT * FROM USR05
         INTO TABLE usr05
         WHERE bname = sy-uname AND
         parid = 'ZRD' AND
        parva = <b>'X'</b> .

Then loop at itab and write data.

Hope this solves ur query.

Reward points if this helps.

Message was edited by:

Judith Jessie Selvi

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:35:29 GMT

Hi Jessi,

Can you tell me what is the use of and ? and why the select was always successful.

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:35:40 GMT

SELECT SINGLE * FROM usr05

INTO wa_usr05

WHERE bname = sy-uname AND

parid = 'ZRD' AND

( parva = 'x' OR parva = 'X' ). "in brackets.

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:40:19 GMT

what is the user of parva = 'X' ?

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:43:18 GMT

Hi jessi,

if you see your first reply there it is mentioned

and what is this ?

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:44:28 GMT

Hi,

Just tried to show it as bold thats y.

U can specify as 'X' that is enough no need for 'x'.

U can also specify with OR no problem with OR

U can simply specify that as

SELECT SINGLE * FROM usr05

INTO wa_usr05

WHERE bname = sy-uname AND

parid = 'ZRD' AND

parva IN ( 'X', 'x' ) .

The problem u had in ur query is with SINGLE fields and u were passing that to a work area with more number of fields, in taht case u should use INTO CORRESPONDING.

Hope u r clear now.

Reard poinst and close the thread if ur problem got solved.

Message was edited by:

Judith Jessie Selvi

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:47:56 GMT

The problem is solved ....

The need for 'x' is required as the part of the requirement

because user may type small x.

I was also thinking to convert to single * but want to know why the select run successfully.....May be bcoz some SAP constraints ...

Thanks Jessi..

Re: Problem with Select statement.

Former Member — Fri, 09 Feb 2007 05:51:09 GMT

Hi,

SELECT SINGLE * FROM usr05

INTO wa_usr05

WHERE bname = sy-uname AND

parid = 'ZRD' AND

parva IN ( 'X', 'x' ) .

The problem u had in ur query is with SINGLE fields and u were passing that to a work area with more number of fields, in taht case u should use INTO CORRESPONDING FIELDS OF.

U can reward points, u have closed the thread by your self without rewarding points. U can say thansk by rewarding points.

Click on the star against the reply which u want to reward points.

Also close the thread.

Whenever u r opening a thread reward points and close the thread. It will encourage those who are replying.