Skip to Content
0
Former Member
Feb 23, 2009 at 06:30 AM

Problem in select query involving wild character

798 Views

Hi,

I am working on BAPI and with field gd_order as import parameter.

Data: gd_order LIKE afko-aufnr.

I have placed following code for gd_orders :

FIND '*' IN gd_order.

IF sy-subrc EQ 0.

r_aufnr-sign = 'I'.

r_aufnr-option = 'CP'.

r_aufnr-low = gd_order.

APPEND r_aufnr.

endif.

I am using following select query

SELECT a~aufnr

bvornr barbid bwerks bltxa1 bprojn bprctr

cktext ckokrs

INTO TABLE gt_orders

FROM afko AS a

INNER JOIN afvc AS b ON aaufpl = baufpl

INNER JOIN aufk AS c ON aaufnr = caufnr

*Beg changes GMARCOS

WHERE a~aufnr IN r_aufnr

AND a~pronr IN r_pronr

AND b~vornr IN r_vorn

AND b~ltxa1 IN r_ltxa1

AND b~projn IN r_wbs_element

AND b~werks IN r_werks

AND b~prctr IN r_prctr.

For an instance i am using gd_order = 1000000,it is giving me a sy-subrc =4, but if i am using 00001000000 then this query works.

Pls guide me how to remove this issue.

Thanks