topic Need Suugested values at Input Fields while maintaining data in Ztable in Application Development and Automation Discussions

Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Tue, 06 Sep 2016 06:07:49 GMT

HI ,

I have created a ztable and as per requirement user wants to maintain entries. While maintaining entries user wants a suggesting inputs which should come from some other ztables. Suppose user enters 'a' then all the names start with 'a' in some specific tables should be shown.

can you please help me in this.

Regards,

Sayed Imran

Re: Need Suugested values at Input Fields while maintaining data in Ztable

SimoneMilesi — Tue, 06 Sep 2016 06:43:48 GMT

Hi Sayed,

if the user wants live update/search like in many websites, sorry, it's not possible as far as i know in ABAP.

Otherwise, as per standard works, if the user puts 'a' and press F4 to get the available list, you have 2 choices:

1-no particular logic, just external db key = sap manage it without a single line of code

2-some kind of logic to apply in order to retrieve the list values = work with Selection Screen Events in ABAP - ABAP Development - SCN Wiki

Re: Need Suugested values at Input Fields while maintaining data in Ztable

krishnaananth — Tue, 06 Sep 2016 07:00:36 GMT

Check...

Regards

Re: Need Suugested values at Input Fields while maintaining data in Ztable

RaymondGiuseppi — Tue, 06 Sep 2016 07:01:23 GMT

What's your version of SAP (HANA, at least 7.40 SP5?) you should perform some search with keywords like 'Search Help', 'Type-Ahead' and 'Fuzzy Search'.

Regards,

Raymond

Re: Need Suugested values at Input Fields while maintaining data in Ztable

SimoneMilesi — Tue, 06 Sep 2016 07:09:21 GMT

Darn! Having an older release, i never get in touch with them and give an incorrect answer!

Shame on me!

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:20:09 GMT

its okay Simone.. I appreciate that atleast you gave a try.

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:22:07 GMT

Its latest version and I tried with Search Help with 'Type-Ahead' and 'Fuzzy Search' but still not working. Is there any restrictions that it should work only in HANA Studio.

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:24:12 GMT

Thanks Krishna. I tried the same but its not working. Cant we do that in SE38 without using HANA studio????

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:27:18 GMT

Hi Sayed

For a Z Table which is being maintained by a user, this sounds like Transportable configuration. Low volume of data.

If this is correct from a practicality point of view is the effort justified to implement this.

If the input values require validation against other tables this can be provided during the save process..On Save event of something to that effect.

Regards

Arden

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:34:51 GMT

HI Arden,

Whenever user enters the data , they wants input fields to suggest some values just like we get while we google.. Exactly like this ( Spotlight on the Enhanced Search (F4 Help)) but the problem is am not able to do it in se38 nor by applying search help to the field by checking box of adavance options of search help.

Regards,

Sayed Imran

Re: Need Suugested values at Input Fields while maintaining data in Ztable

Former Member — Wed, 07 Sep 2016 04:40:58 GMT

Hi Sayed

I understand the requirement.

I'm questioning the practicality of the requirement.

How often will the user be maintaining this table? You need to balance this off the effort required to make this happen.

If they're only maintaining the table a few times a year I'd seriously question the effort required to get this in place.

From an SE38 functionality point of view I've never seem this successfully implemented. Perhaps as a UI5 or FIORI App this can be achieved with less effort.

Educate the customer as to what can and cannot be achieved.

Regards

Arden