topic Re: using left in select in Application Development and Automation Discussions

using left in select

Former Member — Tue, 17 Mar 2009 12:02:21 GMT

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 — Tue, 17 Mar 2009 12:05:04 GMT

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 — Tue, 17 Mar 2009 12:08:19 GMT

thanks it seems good.