topic Re: Regarding passing selection screen values into internal table in Application Development and Automation Discussions

Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:36:17 GMT

Hi,

I have created one selection screen with fields

POSNR LIKE VBAP-POSNR

SELECT-OPTIONS: s_posnr FOR vbap-posnr.

I had created one internal table as:

DATA: BEGIN OF i_item OCCURS 0,

posnr LIKE vbap-posnr,

END OF i_item.

Now what i want is to pass what ever entries available in s_posnr into i_item internal table.

If user gives 10 in select-screen i_item should have 10,

If user gives 10 to 30 in select-screen i_item should have 10,20,30 entries.

If user gives nothing in s_posnr of selection screen

then i_item should have all the valid item no's[POSNR's]

from respective sales order.

Can anybody tell me how can i solve this issue!

Thanks in advance.

Thanks & Regards,

Prasad.

Re: Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:39:03 GMT

Hi Prasad,

I guess somewhere on your selection screen there is also a parameter for sales order (eg. pa_vbeln)?

Then:

SELECT posnr

FROM vbap

INTO TABLE i_item

WHERE vbeln EQ pa_vbeln

AND posnr IN s_posnr.

Will get all position numbers in your internal table.

Regards,

John.

Re: Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:39:26 GMT

select posnr

from vbap

into table i_item

where posnr in S_posnr.

Regards

navneeth

Re: Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:41:39 GMT

Prasad,

You cannot directly get as you don't know the interval of the orders.

So, best thing is to get the values from the VBAK / VBAP table.

SELECT * from VBAP into ITAB where posnr = s_posnr.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:41:41 GMT

hi,

select posnr

from vbap

into table itab

where posnr in S_POSNR.

Reward Points if it helps

regards

Gunjan

Re: Regarding passing selection screen values into internal table

Former Member — Wed, 21 Jun 2006 06:42:21 GMT

select posnr from vbap

into table i_item

where posnr in S_posnr.

Re: Regarding passing selection screen values into internal table

former_member186741 — Wed, 21 Jun 2006 06:43:15 GMT

select vbap~posnr from vbap

into table i_item

where vbap where vbeln = p_vbeln

and vbap~posnr in s_posnr.

Re: Regarding passing selection screen values into internal table

venkat_o — Wed, 21 Jun 2006 06:52:53 GMT

Hi Prasad,

1.

Write SELECT query like this.

SELECT POSNR

FROM VBAP

into table i_item

where posnr in s_posnr.

2.

Moreover u should also pass VBELN in WHERE condition.

Thanks,

Venkat.O

Thanks,

Venkat.O