add fields in abap query

[Former Member]

Hi,

Please let me know , how to add two fields in ABAP Query. Please it showing two fields in list fileds but i want to add two into one.

thanks,

Sonar

[Former Member]

Hi ,

Use concatenate and add two fields into one field.

Thanks & Regards

G.Vendhan

[Former Member]

Hi Sonarali,

This is possible, you need to just write the logic to concatenete the two fields and display in output while making the query.

Also, you have to declare a seperate field for output.

Hope its help you.

[Former Member]

Hi,

You can use CONCATENATE Statement for join 2 fields But remember There data type should be same.

For Example.

DATA:p1(10) type c VALUE 'All',

p2(10) type c VALUE 'the',

p3(10) type c VALUE 'best',

result type string.

concatenate p1 p2 p3 into result.

Try this I hope so it will help you.

Prashant

[Former Member]

Thanks for Inf

Here I want to print total of two fields into one field, where concatenate should be there

m_{v_abrmenge, m}n_abrmenge

select e_{belnr, h}tariftyp, c_{sparte, c}vertrag, c_{vkont, m}belzart, c_{begabrpe, c}endabrpe, m_{v_abrmenge, m}n_abrmenge, e~budat

from erchc as e

join dberchz1 as m

on e_{belnr = m}belnr

join erch as c

on m_{belnr = c}belnr

join ever as r

on c_{vertrag = r}vertrag

join eanlh as h

on h_{anlage = r}anlage

where h~tariftyp in @p1@

and c~erchc_v = 'X'

and c~simulation = space

and c~tobreleasd = space

and e~budat in @p2@

and e~simulated = space

Thanks,

Sonar