Select statment using subset......

Former Member — Thu, 23 Sep 2010 07:06:27 GMT

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.

Re: Select statment using subset......

alex_cook — Thu, 23 Sep 2010 07:18:05 GMT



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

Re: Select statment using subset......

Former Member — Thu, 23 Sep 2010 07:26:13 GMT

Hi Alex,

Thank u very much.

Thanks,

Sudha.

topic Re: Select statment using subset...... in Application Development and Automation Discussions

Select statment using subset......

Re: Select statment using subset......

Re: Select statment using subset......