topic Select-options: Select materials depending on different inputs in Application Development and Automation Discussions

Select-options: Select materials depending on different inputs

Former Member — Thu, 22 Jun 2006 09:13:06 GMT

Hello,

I need a solution for the following problem:

I have defined a structure zep_search like this:

Field | Data Element | Check Table | Search Help

VKORG | VKORG | TVKO

VTWEG | VTWEG | TVKOV

MATNR | MATNR | MVKE | MAT1S

This structure is used in a selection-screen to restrict the selectable materials to only those which exist in the selected sales organisation and distribution channel.

Now I want to add two more fields to this structure:

Material type and plant.

I. e. that by input help only those materials are shown, which exist in the selected sales organisation, distributoin channel, plant and are of the selected material type.

Which check table and search help do I need to use?

Thank you in advance for your replies!

Re: Select-options: Select materials depending on different inputs

Former Member — Thu, 22 Jun 2006 09:20:07 GMT

Hi,

For plant you can use the check table T001W and the search help is H_T134.

For material type you can use the check table T134 and the search help is H_T134.

Lakshminarayanan.

P.S.Mark all helpful answers for points.

Re: Select-options: Select materials depending on different inputs

Former Member — Thu, 22 Jun 2006 13:29:31 GMT

I implemented the suggestions you made. But the problem still persists:

Let's assume I choose the following values

sales organisation - 1000

distribution channel - 10

plant - 1000

material type - HALB

The next step would be to choose the range of materials by using the input help. But the problem is that materials that are not of type HALB or not in plant 1000 are shown in the input help, too. The only limitation to the shown materials are the sales organisation and the distribution channel.

Any idea how it could be realised that only those materials are shown in the input help that meet the above limitations? I assume that another check table or search help should solve the problem, but which one?