topic Re: Dependent fields in search help in Application Development and Automation Discussions

Dependent fields in search help

illya_konakov — Mon, 09 Dec 2013 14:19:45 GMT

Hi,

I need to develop a search help where one field depends on another one.

There is a customer table with a list of partners. The table consists of four fields:

CAT - partner category

SUBCAT - partner sub-category

PARTNER - code of the partner

DESCR - partner's name

The values for the field CAT are kept as a list of fixed values in the correspondent data domain.

The values for the field SUBCAT are kept in the customer table Z_SUBCAT with the structure:

CAT

SUBCAT

An elementary search help Z_SH_SUBCAT exist for the subcategory and it's based on the table Z_SUBCAT.

So, in the new search help I need to have three fields: CAT, SUBCAT and PARTNER. The field PARTNER is returned as a resulted.

Here is the question. If user selects a specific category and proceeds to a sub-category selection then a values list for SUBCAT should be restricted with that selected category. How I can pass a selected category to the search help of the sub-category?

Another possible case is when user does not select a category. But he goes directly with the selection of sub-category. In this case the sub-category's search help should return to the partner's search help both fields: CAT and SUBCAT. Can it be done?

Thanks in advance!

Regards,

Illya

Re: Dependent fields in search help

Former Member — Mon, 09 Dec 2013 14:32:43 GMT

Hi Illya,

in my opinion it should work, if your Z_SH_SUBCAT has an importparameter CAT and is defined as Searchhelp in your table-, or structure-Definition. In the second case CAT should be import- and export-parameter of your Z_SH_SUBCAT. I didn't try it, but i guess it should work.

regards

Jan Martin

Re: Dependent fields in search help

illya_konakov — Mon, 09 Dec 2013 15:18:37 GMT

Hi Jan Martin,

My thoughts were the same. But it does not work. Unless I'm doing something wrong.

I tried different combinations of Import/Export setup. But neither PARTNER search help passes Category to Z_SH_SUBCAT, nor Z_SH_SUBCAT returns Category to PARNTER search help.

Regards,

Illya

Re: Dependent fields in search help

former_member219762 — Mon, 09 Dec 2013 17:11:46 GMT

Hi,

Try with search help exit.

Regards,

Sreenivas.

Re: Dependent fields in search help

Former Member — Tue, 10 Dec 2013 08:30:47 GMT

Hi Illya,

it has to work...

maybe you can post picture of your table definition? In the screen-painter you have to get your fields from the dictionary.

regards

Jan Martin

Re: Dependent fields in search help

illya_konakov — Tue, 10 Dec 2013 14:04:14 GMT

Hi Jan Martin,

Here are the tables and the search helps.

And yes, in the screen painter the input field for PARTNER is marked as "From dict."

Regards,

Illya

Re: Dependent fields in search help

Former Member — Wed, 11 Dec 2013 09:58:19 GMT

Hi Illya,

this all looks fine to me...

Does it work in SE11 when you test it? Is it a problem with the Transport of data in field category?

If the answer is yes, you can try to use a searchhelp-exit FM and try to get data of the category field via FM DYNP_VALUES_READ.

I hope you find a better solution!

Regards

Jan Martin