How to add dependencies between dropdown lists in SAP Agent Performance Management (APM)

[dinhtienduc]

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?

https://help.sap.com/docs/APM_Producer_Manager/76ba1a2d59c74318b880a1f6e140eb29/c254c0ade6804b59bfdc...

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.

[dinhtienduc]

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