topic Re: SQL- Statement: for all entries, where in Application Development and Automation Discussions

SQL- Statement: for all entries, where

Former Member — Thu, 17 Dec 2009 14:15:43 GMT

Hi all, I have a Statement


         SELECT * FROM ltak 
           INTO TABLE lt_help for all entries in gt_tree 
           WHERE bdatu = gt_tree-node_key.

It doesnt want to compile, because the field bdatu is not of the same type like my field node_key.

How can I process this statement, or how can I convert it ?

Thanks,

Regards,

HProkoph

Edited by: Rob Burbank on Dec 17, 2009 9:26 AM

Re: SQL- Statement: for all entries, where

jayanthi_jayaraman — Thu, 17 Dec 2009 14:22:17 GMT

Hi,

Just declare one additional field of same length of BDATU as in gt_tree.

Before passing it in for all entries, change the field ias required inside the loop and modify the table.

Then use the new modified field further in for all entries.

Re: SQL- Statement: for all entries, where

Former Member — Thu, 17 Dec 2009 14:29:00 GMT

SOrry, but if I loop over the table gt_tree and then do the "select for all entries in" inside the loop,

I have a very bad performance.

Or do I misunderstand you?

Regards,

HProkoph

Re: SQL- Statement: for all entries, where

former_member209217 — Thu, 17 Dec 2009 14:29:36 GMT

What is the data type of variable node_key?

BDATU is of type DATS 8.

It won' be possible in your select statement with different data type .Declare it as like SY-DATUM

Re: SQL- Statement: for all entries, where

Former Member — Thu, 17 Dec 2009 14:35:33 GMT

Hello,

This is what you were suggested before



"Add a extra field in the internal table gt_tree

data: begin of gt_tree occurs 0,
           ,,,,,,,
           ,,,,,,,
         bdatu1 like ltak-bdatu,
        end of gt_tree.

"before the select statement

loop at gt_tree.
gt_tree-bdatu1 = gt_tree-node_key.
modify gt_tree.
endloop.

SELECT * FROM ltak 
           INTO TABLE lt_help for all entries in gt_tree 
           WHERE bdatu = gt_tree-bdatu1.

Vikranth

Re: SQL- Statement: for all entries, where

Former Member — Thu, 17 Dec 2009 14:35:38 GMT

Sorry, Jayanthi,

I think I misunderstand your help.

How do I cange the table inside some loop?

That is my question.

The data type of node_key is char(12)

Thanks,

Regards,

Hprokoph

Re: SQL- Statement: for all entries, where

Former Member — Thu, 17 Dec 2009 14:37:44 GMT

Thank you for replying me, now I understand, what to do.

Thanks,

Regards,

HProkoph