How to use the semicolon in abap

[former_member216218]

Hi Expert.

Kindly need your help to solve this SQL Question,

Doing 2 sql, first sql is getting the total amount and total profit for year 2013; where the first sql has to be ended by ";" symbol.

2nd sql is getting the total amount and profit for each region in year 2013,

Customer Sales Table name: csales

  sdate date,

  matno char(10),

  custcode char(10),

  qty decimal(12,4),

  price decimal(12,2),

  cost decimal(12,2)

Customer Master Table name: ccust

  custcode char(10) not null ,

  custname char(35),

region char(15)

Thanks and Regards

Liyana

[paul_bakker2]

So what exactly is your question?

[Former Member]

Hi Liyana,

You are using native sql in abap? No ':' here any more, not same with in SQL editor.

Anyway, please using open sql. refer this link,http://help.sap.com/saphelp_470/helpdata/en/fc/eb3969358411d1829f0000e829fbfe/content.htm?frameset=/...

regards

Archer

[Former Member]

Hi Hasan

Concatenate 1st sql o/p and 2nd sql o/p into string separated by ',' and display it.

Thanks

Vamsi