on 2022 Oct 25 9:21 AM
Hi all,
I am SAP's customer. I am now using SAP Agent Performance Management (APM) to manage Agent information. We have many requirements that need to have dependencies between dropdown lists to ensure that valid combinations of these values. This is a simple example. In the form to input agent address:
- The dropdown list 1 is City/Province
- The dropdown list 2 is District
- The dropdown list 3 is Ward
=> When user select City/Province then the dropdown list 2 has only districts belong to selected City/Province.
=> When user select District then the dropdown list 3 has only Ward belong to selected District.
I see in the SAP document there is a solution using "Field Dependency" to define relationships between specific fields. But this approach is suitable for static list. How can we handle a dynamic situation that dropdown list 2 or 3 is queried from database base on the selection of dropdown list 1?
In general, how to trigger the event of server side for any dropdown list/field and get the relevant data back?
Please give me a solution. Thank you.
Hi Duc,
You can create field dependencies as described through the match rules on the Field Dependency as described in the link your referenced. However, if you have 50 cities, you will have to create 50 match rules for the field dependency. It will be a manual process but it will give you the functionality that you are asking for.
Alternatively, you can load all of the possible City, District, Ward combinations in an Extended Cross Reference table and use the Entity Edit functionality to provide field validations.
I hope this helps.
Phillip
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Phillip Butts,
Thanks for your answer. I have not yet check this community for a long time.
You are correct. Field Dependency can solve my requirement but I will face the problem of manual process to maintain the dependency in the future. Is there any way like upload an excel to maintain these dependency?
Thanks regards,
Duc DINH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.