Skip to Content
avatar image
Former Member

concatenate fields

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 12:28 PM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 11:53 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 11:55 AM

    hi,

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

    now select data from other table by using this variable .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 11:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 12:18 PM

    wow!!!

    Add comment
    10|10000 characters needed characters exceeded