topic Re: Select field substring in Application Development and Automation Discussions

Select field substring

Former Member — Thu, 10 Jun 2010 09:57:11 GMT

Hi,

how can i select a substring of a field ang group by the result in SAP?:

SELECT left(zbnky, 4) as bank, sum ( rbetr) as sumrbetr INTO TABLE gt_data

FROM Reguh

GROUP BY bank.

Thanks

SuhaSaha — Thu, 10 Jun 2010 09:59:29 GMT

I don't think this SELECT construct is possible in Open SQL.

You have to select data into internal table & process the records ...

Edited by: Suhas Saha on Jun 10, 2010 3:31 PM

Former Member — Thu, 10 Jun 2010 10:04:37 GMT

Hi xavi,

just define BANK as C, length 4 in gt_data.

reagrds

rea

Edited by: Ramy El-Arnaouty on Jun 10, 2010 4:43 PM

Former Member — Thu, 10 Jun 2010 10:08:45 GMT

This is something very wierd kind of question.This kind of select query I guess wont work for any Languages.

Please follow the correct syntax for select statement and if you want to sum it up do the same by taking prpoer LOOP statements.

Sany..

Former Member — Thu, 10 Jun 2010 16:38:15 GMT

xavi dont make it such a wired code..

just select required fields from reguh to your internal table.. then do the calculations...

Former Member — Fri, 09 Jul 2010 07:21:53 GMT

There are no weird questions, only weird people .

Of course, these kind of select is possible in other SQL languages, like PL-SQL or Transact-SQL, for example.

That's the reason why i asked this question.