GEO code required for custom report

[Simon_Resch]

Hello,

we are currently developing a custom report for employee extraction in HCM.

The output file of this report requires the country code of the employee.

The country code (ISO) can be derived of infotype 0006 addresses.

The problem is that in the output not the ISO country code is required but the GEO code.

For example: Germany is DE in ISO but GM in GEO.

I don´t think there is a table where this GEO code is stored in SAP standard.

Is there a table or another possibility do get this code somehow without creating a custom mapping table?

[SimoneMilesi]

Hi Simon,

i'm not so expert in HR world so I do not know if there is any table for Geo Names.

In the worst case, you can setup your report in this way: at start, retrieve from geonames site all the Geo Names using their webservices GeoNames Web Service Documentation

Once you retrieve them, you store in internal table and use as per your needs.