how to get desciption of sountry and region code

[Former Member]

Hi all

i have to get country and region code descriptions

is tehre any FM for that...

[Former Member · Accepted solution]

hi ,

I dont know FM but you can try select from this table :T005

Lilach

[Former Member]

i got solution

thanks for all

[Former Member]

Ram Pushpala

This may sound like a stupid question, but what do you require it for?

These are standard fields available in the UI configuration tool for the ICCMP_BP_DETAIL component, view BuPaCreate:

//DEFAULTADDRESS/COUNTRY_TEXT - Country description

//DEFAULTADDRESS/REGION_TEXT - Region description

Obviously if you want them in a different view, you can extend the view and add the context node so that they are accessible.

I hope this helps?

Many thanks,

Andrew Griffin.

[Former Member]

Hi Andrew,

Thanks for your great reply,

I dont need that in any view ,i want to implement one search help based on the some values...

any how i got the solution long back...

so u no need to worry about stupid questions..

[Former Member]

Ram Pushpala

I'm glad you got this sorted.

All the best,

Andrew G.

[Former Member]

Hello Ram,

Do you have CountryText Attribute in your Context? If not then create a Model attribute. If yes then, put the following code in the method : GET_COUNTRYTEXT :

*********************************

DATA: lv_country TYPE land1.

lv_country = get_country( attribute_path = '//BUILCONTACTPERSON/COUNTRY'

iterator = iterator ).

SELECT SINGLE landx FROM t005t INTO value

WHERE spras = sy-langu

AND land1 = lv_country.

********************************

BUILCONTACTPERSON is Context Node Name.

For other methods like SET_Countrytext, GET_I_, GET_M_ , comment the code insde of these methods.

I think it will definitely work.

Thanks & regards

Madhusudan

[Former Member]

Hi,

try this

data lv_reg_text TYPE bezei20.

SELECT SINGLE bezei FROM t005u INTO (lv_reg_text)

WHERE spras = sy-langu AND land1 = country_id AND bland = region_id.

ex:

SELECT SINGLE bezei FROM t005u INTO (lv_reg_text)

WHERE spras = sy-langu AND land1 = 'DE' AND bland = '12'.

[CarstenKasper]

Hi,

you could try CL_CRM_UIU_BP_TOOLS->get_country_texts() for the country texts. For region I do not know.

cheers Carsten