I need to fill CITY_CODE field in ADRC table for Business Partners.
table with dictionary for city_code is ADRCITY, but for some cities there are few records in ADRCITY.
so how to choose best? select first I think wont be the best solution.
Do you know any FM to choose it?