Skip to Content
avatar image
Former Member

how to get desciption of sountry and region code

Hi all

i have to get country and region code descriptions

is tehre any FM for that...

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 11:47 AM

    hi ,

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

    Lilach

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2008 at 12:06 PM

    Hi,

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

    cheers Carsten

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 05:14 PM

    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'.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 09:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2008 at 05:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2008 at 05:38 AM

    i got solution

    thanks for all

    Add comment
    10|10000 characters needed characters exceeded