topic Re: Where condition problem in select statement. in Application Development and Automation Discussions

Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:10:33 GMT

Hi,

I am trying to write select statement as below

SELECT objectclas objectid FROM cdhdr INTO CORRESPONDING FIELDS OF TABLE ltab_chgdocu

WHERE objectclas IN ('STUE' , 'STUE_V')

AND ( TCODE eq 'CS01u2019 or tcode eq u2019CS02u2019 or tcode eq 'C201' or tcode eq 'C202' ) .

But I am getting the error like "literals that takes up more than one line or not permitted"

Please let me know whats wrong and correct me .

Thanks,

Vinay.

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:17:25 GMT

HI,

Problem is


 'CS01u2019  " Check the qoutes

Try this it will work.



SELECT objectclas objectid FROM cdhdr INTO CORRESPONDING FIELDS OF TABLE ltab_chgdocu
WHERE objectclas IN ('STUE' , 'STUE_V')
AND  TCODE eq 'CS01' 
  or tcode eq 'CS02' 
  or tcode eq 'C201' 
  or tcode eq 'C202' .

Regards and Best wishes.

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:20:43 GMT

Hi,

The single quote given in your code were wrong.. try to type again that all.. I have done that and working fine.. Retype all the single quotes.. Like after and before CS01 and all..

SELECT objectclas objectid FROM cdhdr INTO CORRESPONDING FIELDS OF TABLE ltab_chgdocu
WHERE objectclas IN ('STUE' , 'STUE_V')
AND ( TCODE eq 'CS01' 
 or tcode eq 'CS02' 
  or  tcode eq 'C201' 
  or tcode eq 'C202' ).

Edited by: Lokesh Tarey on Apr 30, 2010 7:23 AM

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:41:06 GMT

Still getting same error .....

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:47:58 GMT

Hi,

Copy and paste the below coding.

DATA : LTAB_CHGDOCU TYPE TABLE OF CDHDR.

SELECT OBJECTCLAS OBJECTID FROM CDHDR INTO CORRESPONDING FIELDS OF TABLE LTAB_CHGDOCU

WHERE OBJECTCLAS IN ('STUE' , 'STUE_V')

AND ( TCODE EQ 'CS01'

OR TCODE EQ 'CS02'

OR TCODE EQ 'C201'

OR TCODE EQ 'C202' ) .

With Regards,

Sumodh.P

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:50:32 GMT

Copy Paste and check.

tables : cdhdr.

types : begin of ltab_chgdocu,
        objectclas type cdhdr-objectclas,
        objectid   type cdhdr-objectid,
        end of ltab_chgdocu.
DATA : it_tab TYPE STANDARD TABLE OF ltab_chgdocu,
       wa_tab TYPE ltab_chgdocu.

SELECT objectclas objectid FROM cdhdr INTO CORRESPONDING FIELDS OF TABLE it_tab
WHERE objectclas IN ('STUE' , 'STUE_V')
AND ( TCODE eq 'CS01'
 or tcode eq 'CS02'
  or  tcode eq 'C201'
  or tcode eq 'C202' )

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 05:56:30 GMT

Dear,

Your putting just wrong quotes. Please try to type whole code manually. Pls don't try to just copy and paste..

Like 'CS01'.. here try to type by your own this single quotes..

Regs,

Lokesh.

Re: Where condition problem in select statement.

BH2408 — Fri, 30 Apr 2010 06:10:22 GMT

HI ,

Use the ranges....

Regards,

Bharani

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 06:11:13 GMT

But I am getting the error like "literals that takes up more than one line or not permitted

We generally face this error if the literals i.e the quotes don't end up the same for the starting and ending value.

Re: Where condition problem in select statement.

Mohamed_Mukhtar — Fri, 30 Apr 2010 06:16:03 GMT

Hi Vinay,

Declare constants

constants : c_stue type CDOBJECTCL value 'STUE',
             c_stue_v type CDOBJECTCL value 'STUE_V',
             c_cs01 type sy-tcode value 'CS01',
             c_cs02 type sy-tcode value 'CS02',
             c_C201 type sy-tcode value 'C201',
             c_C202 type sy-tcode value 'C202'.

And replace your hardcoded values with these constants in your select query.

SELECT objectclas objectid FROM cdhdr INTO CORRESPONDING FIELDS OF TABLE it_tab
                                    WHERE objectclas IN (c_STUE , c_STUE_V)
                                                 AND ( TCODE eq c_CS01
                                                 or tcode eq c_CS02
                                                 or  tcode eq c_C201
                                                  or tcode eq c_C202 ).

Thanks & Regards

- Always Leaner

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 07:18:02 GMT

Hi Vinay,

It's working for me.



TYPES : BEGIN OF ty_chgdocu,
       objectclass TYPE cdobjectcl,
       objectid    TYPE cdobjectv,
       END OF ty_chgdocu.

DATA : ltab_chgdocu TYPE TABLE OF ty_chgdocu,
       wa_chgdocu LIKE LINE OF ltab_chgdocu .

SELECT objectclas objectid
                FROM cdhdr
                INTO TABLE ltab_chgdocu
                WHERE objectclas IN ('STUE' , 'STUE_V') AND
                     tcode IN ('CS01' , 'CS02', 'CS03' ).

Cheers

Re: Where condition problem in select statement.

Former Member — Fri, 30 Apr 2010 07:20:11 GMT

Yes...Are u talking about the code i had given?

i had executed the code . It's Working