multiple choices in d input

[Former Member]

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...

[Former Member]

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

[dani_mn]

HI,

use 'SELECT-OPTONS'.

<b>

SELECT-OPTIONS: S_VBELN FOR VBAP-VBELN.

SELECT-OPTIONS: S_POSNR FOR VBAP-POSNR.</b>

[Former Member]

Hi Priya ,

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

declared them like this

<b>parameters p_werks like vbap-werks.

select-options : s_vbeln for vbak-vbeln,

s_posnr for vbap-posnr.</b>

Now your query will work fine.

[Former Member]

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

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

just try this query with corresponding fields addition.

regards

shiba dutta

[rahulkavuri]

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

[Former Member]

hi

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...

[Former Member]

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

[Former Member]

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.....

[Former Member]

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

[Former Member]

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.

[Former Member]

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???

[Former Member]

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??

[Former Member]

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