topic Help sql substring column in Application Development and Automation Discussions

Help sql substring column

Former Member — Mon, 22 Mar 2010 15:48:26 GMT

Hi All,

I'm tying to execute this query

selecy matnr (sonum,1,10) as zsonum1 (sonum,11,16) as zsinum2 gesme

INTO CORRESPONDING FIELDS OF TABLE wt_stabr

from linv.

In other words I wish to split the sql field sonum (16) into two fields of my internal table (zsonum1 (10) and zsonum2 (6).

I can't execute the query because I have a sintax error about the comma.

Any help will be well appreciated.

Thanks in advance for your kind support.

Luigi

Re: Help sql substring column

Former Member — Tue, 23 Mar 2010 09:01:59 GMT

Hi All,

I wish to launch this query

SELECT substr(sonum,1,10) as ZSONUM1 substr(sonum,11,16) as ZSONUM2

FROM linv.

Is it possible?

Any help will be well appreciated.

Thanks.

Luigi

Re: Help sql substring column

Former Member — Tue, 23 Mar 2010 09:59:55 GMT

Hello,

I dont think there is any such provision in ABAP to split the column value directly in the select query. The only option is to select the fields as they are and do the spliting and manipulations manually after the select query.

Vikranth

Re: Help sql substring column

OttoGold — Tue, 23 Mar 2010 10:17:14 GMT

hello, what would be the benefit of doing that in the SELECT statement? You can do that easily in the following ABAP code. I would never ask this question, because I know that I cannot do any complex mathematical operations with ABAP which would be much easier to implement and nobody has ever done that:)) I am sorry to tell you, this is 99,5% not possible and will not be possible in the future of SAP:)))

Regards Otto

Re: Help sql substring column

Former Member — Fri, 04 Jun 2010 03:37:40 GMT

This message was moderated.