topic Re: initializating in Application Development and Automation Discussions

initializating

Former Member — Wed, 23 Apr 2008 08:02:21 GMT

SELECT a_{vbeln a}vkorg a_{fkdat a}netwr a~kunag

b_{posnr b}fkimg b_{vrkme b}matnr b_{mvgr2 b}vkorg_auft b~vtweg_auft

INTO TABLE i_ship

FROM vbrk AS a

INNER JOIN vbrp AS b

ON a_{vbeln = b}vbeln

WHERE kunag = wa_cust_ctrl-kunnr

AND fkdat >= v_inv_begin_dt AND fkdat <= v_end_dt

AND vbtyp = c_m

AND ( fkart = c_f2 OR fkart = c_zbf2 OR fkart = c_znf2 OR fkart = c_zxf2 )

in the above query how to set the intiliazation values for fkart because i am using select-options and set the all default values to the select-options.

Re: initializating

Former Member — Wed, 23 Apr 2008 08:05:33 GMT

Hi,

If u want to set default values for select-options, u can use DEFAULT keyword while declaring select-options.

Generally, we initialize values in INITIALIZATION event.

Regards,

Ramya

Re: initializating

Former Member — Wed, 23 Apr 2008 08:15:14 GMT

use initialization event

fkart = x

then append fkart(because when you create using select-options then and internal table is created)

I think this should work in your requirement

Re: initializating

Former Member — Wed, 23 Apr 2008 08:18:23 GMT

If u want to set default values for select-options, u can use keyword DEFAULT

SELECT-OPTIONS: s_fkart FOR fkart DEFAULT 'your value'

Reward If Helpfull,

Naresh.

Re: initializating

Former Member — Wed, 23 Apr 2008 08:23:25 GMT

INITIALIZATION.

S_FKART-LOW = 'UR VALUE'.

S_FKART-HIGH = ' UR VALUE'.

APPEND S_FKART.

It works definitley

Regards,

ajay