09-04-2008 12:52 PM
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
09-04-2008 1: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 .
09-04-2008 12:53 PM
09-04-2008 12:55 PM
hi,
define 1 variable and concatenate the two fields data into that field.
now select data from other table by using this variable .
09-04-2008 12:57 PM
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
09-04-2008 1:18 PM
09-04-2008 1: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 .