cancel
Showing results for 
Search instead for 
Did you mean: 

FMS

Former Member
0 Kudos

Dear experts,

I want to create an FMS query for business partner master data. In "Addresses" tab when I select the state the city should display the cities of that state.How can I link those with FMS query..

Thanks & Regards,

KV

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI John,

It is displaying the following error

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'UDt_city'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement '' (SWEI) (s) could not be prepared.

Thanks& Regards,

KV

KennedyT21
Active Contributor
0 Kudos

Hi KV..

try this

SELECT CITY_NAME FROM [DBO]. [@UDT_CITY] WHERE STATE_CODE=$[CRD1.STATE]


Regards

Kennedy

Former Member
0 Kudos

Hi KV,

Using UDT in FMS or Query the format should be [@UDT_CITY]

Regards,
Lean

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi John,

I have created UDT for cities

Regards,

KV

Former Member
0 Kudos

Hi KV,

Try this SELECT CITY_NAME FROM UDT_CITY WHERE STATE_CODE=$[CRD1.STATE]

Of course in your UDT you have the same code of state between OCST table

Hope it helps you

Regards,

Lean

Former Member
0 Kudos

Hi KV,

How you will manage the cities per state? do you have a UDT for it?

Regards,

Lean