using left in select

[Former Member]

i have a field which is combination of two fields.

doctype+year 123452008

12345 2008

i want 12345 only,i use same santax in sql server.but here it makes problem.tell me whats wrong with it.

select single left ( awkey , 5 ) as awkey from bkpf into zmatdoc where belnr = bkpf-belnr .

[Former Member]

Hi:

Do like this

data: wa_bkpf type bkpf.

select single * from bkpf into wa_bkpf where belnr = bkpf-belnr .

if sy-subrc eq 0.

zmatdoc = wa_bkpf-awkey+0(5).

endif.

Regards

Shashi

[Former Member]

thanks it seems good.