topic Re: concatenate fields in Application Development and Automation Discussions

concatenate fields

Former Member — Thu, 04 Sep 2008 11:52:49 GMT

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

Re: concatenate fields

Former Member — Thu, 04 Sep 2008 11:53:48 GMT

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

Re: concatenate fields

GauthamV — Thu, 04 Sep 2008 11:55:20 GMT

hi,

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

now select data from other table by using this variable .

Re: concatenate fields

Former Member — Thu, 04 Sep 2008 11:57:46 GMT

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

Re: concatenate fields

Former Member — Thu, 04 Sep 2008 12:18:56 GMT

wow!!!

Re: concatenate fields

Former Member — Thu, 04 Sep 2008 12:28:19 GMT

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 .