to find country description from check table

[Former Member]

Hi friends,

i have field HERKL ( Country of origin of the material ) from MARC table.

now based on that field i need the country full name ie : GERMAN , CHINA

CN = CHINA

DE =GERMAN.

from which table i can get that.

Regards

Priyanka.

[Former Member · Accepted solution]

As vijay said the table is T005t.

equate HERKL to LAND1 and get the country name in LANDX.

кu03B1ятu03B9к

[Former Member]

U can get it from T005T table.

select LANDX or LANDX50 field from T005T comparing ur field with country key field LAND1

[Former Member]

This message was moderated.

[Former Member]

Hi,

Please refer T005T (Country Names) and T005U(Taxes: Region Key: Texts) tabels.

Hope this works for you.

Thanks.....

[Former Member]

Hi

You can get the country full name from table T005

Regards,

Rajani

[Former Member]

Hi, You can get these details from T005 table.

Regards,

jaya

[Former Member]

Table: T005T