Skip to Content

How to use the semicolon in abap

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 07, 2015 at 03:38 AM

    So what exactly is your question?


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 03:42 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 05:16 AM

    Hi Hasan

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

    Thanks

    Vamsi

    Add comment
    10|10000 characters needed characters exceeded