How to differentiate State, province and County from REGION field ?

[Former Member]

Hi Experts,

I have field "REGION" which i need to pass to other structure.

REGION Field (REGIO) states differently. How can i find whether data coming in that field relates to County OR Province or State ? Is there anywhere i can check that ?

Any table or structure to fetch that logic ?

Thank You,

[Former Member]

Hi,

You will have to see the logic of the program, which updates the table. Open the program and go through it, and see what value is being passed to that field.

Regards,

Shiny

[Former Member]

Hi,

u can look for any foreign key relationship for that data element and find any table dependencies on that field.

[Former Member]

if it has any check table or value table for data element you can cross check otherwise it is difficult.

[Former Member]

Hi,

Use t005u Table..this gives you full information regarding state,provience and country and full text of that state...

[Former Member]

If you need the country code use the field kna1-land1

using this the country code can be found

once this is passed to the t005t table the description(landx) for the country can be found

example :

IN will be fetched from kna1 and when it is passed along with spras to t005t we get the description

[Former Member]

Hi,

Check tables T005t, T005U and t005 tables.

Hope this works for you.

Thanks.....

[Former Member]

hi

Region is based on the country field. If the country is australia then region field becomes province and

if the country is canada then region field becomes county etc.

Regards

[Former Member]

hi

addr1_data is the structure which holds address data in that region is the field which

holds all the 3 data state, province, county based on the country field ie

if the country is australia then region field becomes province

if the country is canada then region field becomes county etc .

Meaning of the regional code in

australia province

brazil state

canada province

germany state

great britain county

italy province

japan prefecture

switzerland canton

usa state

Regards