concatenate fields

[Former Member]

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

[Former Member]

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

[GauthamV]

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]

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 Member]

wow!!!

[Former Member]

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 .