Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

concatenate fields

Former Member
0 Kudos

i have to make a selection on a table based on a concatenation of 2 fields

i.e objkey in table /eu000/wftlg shd match table vbseg-bukrs and vbseg-belnr(these 2 fields are concatenated)

hw to do that

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

You can do it.

Use the Pattern option available in ABAP SELECT query( LIKE %abc% 0.)

Example:

select bukrs

belnr

into table itab

from vbseg

where bukrs like '%/concatenated value%'

and belnr like '%/concatenated value%'.

Hope this leads to you the solution.

Regards,

Rama .

5 REPLIES 5

Former Member
0 Kudos

Oh......My......God

GauthamV
Active Contributor
0 Kudos

hi,

define 1 variable and concatenate the two fields data into that field.

now select data from other table by using this variable .

Former Member
0 Kudos

Hi,

First fetch those two values into an internal table.

loop at this internal table. Concatenate these fields and store it in a separate internal table. Finally fetch values from objkey in table /eu000/wftlg matching values with this internal table.

Use of concatenate command:

CONCATENATE STRING1 STRING2 INTO STRING3.

Regards,

Ramya

former_member184657
Active Contributor
0 Kudos

wow!!!

Former Member
0 Kudos

Hi,

You can do it.

Use the Pattern option available in ABAP SELECT query( LIKE %abc% 0.)

Example:

select bukrs

belnr

into table itab

from vbseg

where bukrs like '%/concatenated value%'

and belnr like '%/concatenated value%'.

Hope this leads to you the solution.

Regards,

Rama .