topic Re: select statement not working in Application Development and Automation Discussions

select statement not working

Former Member — Thu, 08 Apr 2010 05:11:33 GMT

hi to all,

I am trying to write use inner joining . here is code

DATA:tabname LIKE dd02L-tabname,

table_disc LIKE dd02t-ddtext.

SELECT dd02l_{tabname dd02t}ddtext INTO (tabname,table_disc)

FROM dd02l INNER JOIN dd02t on dd02l_{tabname = dd02t}tabname

WHERE dd02t_{ddlanguage = 'E' AND dd02l}tabclass = 'TRANSP'

AND dd02L~tabname = 'ZANKI*'.

endselect.

write : tabname.

I also checked in tables dd02t and dd02l for the table zanki* and data available in both table . but here select statement not working .do u have any idea about this. thank you

Re: select statement not working

Former Member — Thu, 08 Apr 2010 05:15:43 GMT

Hi,

Change dd02t_{ddlanguage = 'E' to dd02t}ddlanguage = 'EN".

Regards

Vinod

Re: select statement not working

Former Member — Thu, 08 Apr 2010 05:15:50 GMT

Hello


AND dd02L~tabname LIKE 'ZANKI%'. " instead of AND dd02L~tabname = 'ZANKI*'.

Re: select statement not working

Former Member — Thu, 08 Apr 2010 05:24:42 GMT

HI Dzed Maroz ,

I used that one . but i did't get . any idea . thank you

Re: select statement not working

Former Member — Thu, 08 Apr 2010 06:09:15 GMT

Hi,

Do: dd02L~tabname LIKE 'ZANKI%'.

But your code will show you the last tabname in the database starting with ZANKI...

Sanghamitra

Re: select statement not working

Former Member — Thu, 08 Apr 2010 06:11:06 GMT

Run the following code its work


DATA:tabname LIKE dd02L-tabname,
table_disc LIKE dd02t-ddtext.

SELECT A~tabname B~ddtext INTO (tabname,table_disc)
FROM dd02l AS A INNER JOIN dd02t AS B
on A~tabname = B~tabname

WHERE
B~ddlanguage = 'EN'
AND A~tabclass = 'TRANSP'
AND A~tabname LIKE  'ZANKI%'.
endselect.


write : tabname.

Re: select statement not working

Former Member — Thu, 08 Apr 2010 06:13:05 GMT

ZANKI* can not be a table name because The name ZANKI* contains a non-alphanumeric character

, Please check your table name.

Re: select statement not working

Former Member — Thu, 08 Apr 2010 06:14:54 GMT

Hi,

I executed the ur inner join conditin by commenting 'z*' it's working fine.

I think where condition is not getting satisfied so u r not getting any data.

Please conform in where condition you need * 'AND'* or OR

I change decalration as below.


DATA:tabname    type TABNAME,
      table_disc type AS4TEXT.

SELECT dd02l~tabname
       dd02t~ddtext  INTO (tabname, table_disc)
 FROM dd02l  INNER JOIN dd02t on dd02l~tabname = dd02t~tabname
WHERE dd02t~ddlanguage = 'E' AND
      dd02l~tabclass = 'TRANSP'AND
    dd02L~tabname = 'ZANKI*'.
endselect.

write : tabname.

Regards,

Pravin

Re: select statement not working

Former Member — Thu, 08 Apr 2010 06:36:28 GMT

No tablename can have non-alphanumeric character. Check the tablename in the select query.

Regards

Vinod

Re: select statement not working

Former Member — Thu, 08 Apr 2010 07:12:27 GMT

HI to all,

my problem was solved. thanks to all

Re: select statement not working

former_member418469 — Thu, 08 Apr 2010 07:52:27 GMT

hi,

Try this

select single a_{tabname b}ddtext INTO (tabname,table_disc)

from dd02l as a

join DD02T AS b

on a_{tabname = b}tabname

where b~DDLANGUAGE = sy-langu

and a~tabclass = 'TRANSP'

AND a~TABNAME like 'A14%'.