Select statment using subset......

[Former Member]

Hi Experts,

i have issues on selecting data :

But before posting this i already checked in sdn but i dint get....

my input is like: lv_fikey = CH-090901-01 (this is not fixed)

lv_bukrs = '2001'.

My table data is like below:

BUKRS - BELNR - AWKEY

2000 - 0400003519 - CH-090901-01-0000001

2001 - 0400002981 - CH-090901-01-0000002

My input lv_fikey is subset of AWKEY values. ( lv_fikey is every time different)

but i want to select AWKEY value.

if i write like below it is ok, but i cant do like this, because CH-090901-01 is not fixed, it ll be anything.

SELECT SINGLE belnr gjahr budat INTO (lv_belnr,lv_gjahr,lv_budat)

FROM bkpf

WHERE awkey LIKE 'CH-090901-01%' AND

bukrs = lv_bukrs.

Can anyone give me a right option.....

Thanks in Advance,

Sudha.

[alex_cook]

CONCATENATE lv_fikey '%' into lv_fikey.

...

SELECT SINGLE belnr gjahr budat INTO (lv_belnr,lv_gjahr,lv_budat)
FROM bkpf
WHERE awkey LIKE lv_fikey AND
bukrs = lv_bukrs.

Cheers

Alex

[Former Member]

Hi Alex,

Thank u very much.

Thanks,

Sudha.