topic Re: Help required in code in select statement in Application Development and Automation Discussions

Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:45:18 GMT

Hello All,

I want to select all the entries from table dd02l where 'ZCUST*'

Can any one tell me how to write this code.


  CONCATENATE  'tabname =' '''ZVHF_CUST*'''
    INTO where_clause SEPARATED BY space.

i tried in the above manner but didn't succeeded.

Regards,

Lisa

Edited by: Lisa Roy on Apr 2, 2008 11:45 AM

Re: Help required in code in select statement

Sm1tje — Wed, 02 Apr 2008 15:47:42 GMT

data: gt_dd02l type table of dd02l.

select * from dd02l into table gt_dd02l where TABNAME LIKE 'ZCUST%'.

Edited by: Micky Oestreich on Apr 2, 2008 5:48 PM

Edited by: Micky Oestreich on Apr 2, 2008 5:49 PM

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:51:51 GMT

Hi Lisa,

try with like operator..

select * from dd02l into table it_dd02l where TABNAME LIKE 'ZCUST%'.

pls check the % operator where to put it exactly..

Regards

Syed A

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:52:19 GMT

hi,

do this way..


select single * from dd02l  where tabnam like 'ZCUST%'.

Re: Help required in code in select statement

former_member194669 — Wed, 02 Apr 2008 15:52:53 GMT

Try this way


  data : v_like(7) type c.
  concatenate 'ZCUST%' space into v_like.
  select * from dd02l into table i_dd02l
    where tabname like v_like.

a®

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:53:51 GMT

Hi,

Try like this:

select * from dd02l into table it_dd02l

where tabname LIKE 'zvhf_cust%'.

Regards,

Bhaskar

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:54:25 GMT

Hello Micky,

I am getting a systax error field = is unknown.

Regards,

Lisa

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:54:59 GMT

TYPES T_DD02L TYPE DD02L.

DATA : IT_DD02L TYPE STANDARD TABLE OF T_DD02L.

SELECT * FROM DD02L INTO TABLE IT_DD02L

WHERE TABNAME LIKE 'Z%'.

Re: Help required in code in select statement

Former Member — Wed, 02 Apr 2008 15:56:48 GMT

Post your query, if that is the error, probably you have a '=' that shouldn't be there

Re: Help required in code in select statement

Sm1tje — Wed, 02 Apr 2008 16:05:37 GMT

Sorry, i was a bit sloppy in writing the code. The correct code was edited the last time. Now it should be ok, but you have probably solved this problem using all the other answers.