Select field substring

[Former Member]

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]

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]

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]

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]

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.

[Former Member]

xavi dont make it such a wired code..

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