topic Re: multiple choices in d input in Application Development and Automation Discussions

multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:17:38 GMT

in d "sales order status" report

selection screen parameters r plant : P_WERKS(VBAP-WERKS),sales doc : S_VBELN(VBAP-VBELN) & sales doc item : S_POSNR(VBAP-POSNR).

rite now im using d query :

select VBELV LFIMG from LIPS into table ITAB where VBELV in S_VBELN and POSNV in S_POSNR.

now this query is not workin if we give multiple choices in d input.

so wat modifications it requires.....

pls help...

Re: multiple choices in d input

dani_mn — Mon, 22 Jan 2007 05:21:09 GMT

HI,

use 'SELECT-OPTONS'.

SELECT-OPTIONS: S_VBELN FOR VBAP-VBELN.

SELECT-OPTIONS: S_POSNR FOR VBAP-POSNR.

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:24:03 GMT

Hi Priya ,

Tell me if s_vbeln and s_posnr are declared as paramters then only one value can work .

declared them like this

parameters p_werks like vbap-werks.

select-options : s_vbeln for vbak-vbeln,

s_posnr for vbap-posnr.

Now your query will work fine.

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:24:08 GMT

your query is looking ok. i dont know why it is not working ?

select VBELV LFIMG from LIPS into corresponding fields of table ITAB where VBELV in S_VBELN and POSNV in S_POSNR.

just try this query with corresponding fields addition.

regards

shiba dutta

Re: multiple choices in d input

rahulkavuri — Mon, 22 Jan 2007 05:25:01 GMT

hi if u have given the correct declaration like

parameters :P_WERKS(VBAP-WERKS),

select-options: S_VBELN for VBAP-VBELN, S_POSNR for VBAP-POSNR.

then it should be working, otherwise it means that the values arent existing in the database for ur defined selection...

check it... award points if found helpful

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:34:12 GMT

i have already used SELECT-OPTIONS only for S_VBELN & S_POSNR.

code i've used :

parameters: p_werks like vbap-werks.

SELECT-OPTIONS: s_vbeln FOR vbap-vbeln,

s_posnr for vbap-posnr.

but still it is not comin.....

pls tell some other alternative...

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:39:35 GMT

if you have done corresponding field addition also then pls check the table whether as per your selection criteria data is there or not..

regards

shiba dutta

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 05:48:23 GMT

hi....

data is present. i dont know wat is goin wrong.......

now wen u give POSNR as from 100 to 200 then it is showing output for POSNR = 100 but for POSNR = 200 d values r comin wrong. and also values of POSNR = 100 r gettin carry forward......

wat modifications r needed.....

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 06:08:50 GMT

can you check in debug mode for S_POSNR.

this table contains

S_POSNR-sign = I.

S_POSNR-option = BT

S_POSNR-low = 100

and

S_POSNR-high = 200

or not.

just give these values and check. if it is not let me know.

regards

shiba dutta

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 06:15:29 GMT

Hi Priya ,

I have coded your example and it works fine for me

Please have see at the code.

tables : lips,vbak,vbap.

data : begin of itab occurs 0 ,

vbelv like lips-vbelv,

lfimg like lips-lfimg,

end of itab.

PARAMETER: p_werks like vbap-werks.

select-options : s_vbeln for vbak-vbeln,

s_posnr for vbap-posnr.

select VBELV LFIMG from LIPS into corresponding fields of table ITAB where VBELV in S_VBELN and POSNV in S_POSNR.

I had entered value for s_vbeln 31 from 331

and s_posnr 10 20 and it gave me correct entries coz for order number 331 there were two entries in lips so multiple entries worked.

Please check the code with my code.

Please reward if useful.

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 06:21:23 GMT

hi.....

yes they are comin :

s_posnr-sign = I.

s_posnr-option = BT.

s_posnr-low = 000100.

s_posnr-high = 000200.

now how should i proceed??

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 06:31:05 GMT

i think you have declared like

SELECT-OPTIONS : S_POSNR FOR VBAP-POSNR.

NOW CHECK IN LIPS WHETHER POSNV IS 100 OR 00100. IF NOT

DO LIKE THIS

SHIFT S_POSNR-LOW LEFT DELETING LEADING '0'.

OR USE CONVERSION_EXIT_ALPHA_OUTPUT FM .

JUST CHECK WHETHER LEADING 0 ARE MAKING THE PROBLEM OR NOT?

REGARDS

SHIBA DUTTA

Re: multiple choices in d input

Former Member — Mon, 22 Jan 2007 06:33:31 GMT

hi.........

i've used d same code but still it is not comin....& also values of eg.

posnr = 100 r gettin carry forward to d values of posnr = 200.

how shuold i proceed now???