topic Re: Where condition in Application Development and Automation Discussions

Where condition

radhushankar — Mon, 14 Jan 2008 08:49:00 GMT

Hi all

i am working in a object tat is smartform.

In that i have to retrieve the Drawing number based upon the description.

In the table the Description stored like this.

DKTXT = GA W MATERIAL DRAWING.

My problem is i have to compare the first three letters of the description. For example 'GAW'.

SELECT SINGLE DOKNR

FROM DRAT

INTO ZDOKNR

WHERE DKTXT = 'GAW' ( MY PROBLEM IS HOW TO COMAPRE THE FIRST THREE LETTERS AND RETRIEVE THE DATA.

Thanks in advance,

arun.j.

Re: Where condition

Former Member — Mon, 14 Jan 2008 08:53:39 GMT

Shankar

SELECT SINGLE DOKNR

FROM DRAT

INTO ZDOKNR

WHERE DKTXT = 'GAW'

first u do like this

data:

w_char(4) type c.

concatenate 'GAW' ' * ' into w_char.

then write u r select statement..

SELECT SINGLE DOKNR

FROM DRAT

INTO ZDOKNR

WHERE DKTXT like w_char.

plzz reward if it usefull...

plzz dont forget to reward...

Re: Where condition

Former Member — Mon, 14 Jan 2008 08:59:55 GMT

Hi Radhu,

Try this.

SELECT SINGLE DOKNR

FROM DRAT

INTO ZDOKNR

WHERE DKTXT LIKE 'GAW%'

Regards,

Mohaiyuddin

Re: Where condition

Former Member — Mon, 14 Jan 2008 09:02:56 GMT

Hi Radhu,

The select querry that you have writen is fine.The only change that you need to do is in the WHERE condition.

Here in the where condition DKTXT is checking for all those values which start with GAW.

If the % is given in this way,then the select querry will retrieve all the DOKNR for the values of DKTXT starting with GAW.

SELECT SINGLE DOKNR

FROM DRAT

INTO ZDOKNR

WHERE DKTXT like 'GAW%'

Plese revert for any querries.

Reward points if helpfull.

Regards,

Srikanth Tulasi

Re: Where condition

radhushankar — Mon, 14 Jan 2008 09:06:21 GMT

concatenate 'GA'' * ' into ZGDRAWING.

SELECT SINGLE DOKNR

FROM DRAD

INTO ZDES

WHERE OBJKY = WA_VBAP-MATNR AND

DOKAR = 'GAD' AND

DOKVR = '00'.

SELECT SINGLE DKTXT

FROM DRAT

INTO ZDES1

WHERE DOKNR = ZDES AND

DOKAR = 'GAD' AND

DOKVR = '00' AND

DKTXT IN ZGDRAWING.

Hi i did like this but i am getting a error like this unable to interpret GA*.

Can u plz help me out in this??

Re: Where condition

Former Member — Mon, 14 Jan 2008 15:25:07 GMT

Hi Radhu,

concatenate 'GA' ' * ' into ZGDRAWING.

There has to be space between the two inverted comas.Because GA is one string and * is another one.

Please check with that once again.

That is the reason why your getting an error.

Rest of the code is fine.

Revert for any other querries.

Regards,

Kaushik

Re: Where condition

radhushankar — Thu, 17 Jan 2008 07:43:44 GMT

Thanks for ur answers.