topic Re: GEO code required for custom report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/geo-code-required-for-custom-report/m-p/11800926#M1954064 <HTML><HEAD></HEAD><BODY><P>Hi Simon,</P><P>i'm not so expert in HR world so I do not know if there is any table for Geo Names.</P><P>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 <A href="http://www.geonames.org/export/web-services.html" title="http://www.geonames.org/export/web-services.html">GeoNames Web Service Documentation</A></P><P>Once you retrieve them, you store in internal table and use as per your needs.</P></BODY></HTML> Thu, 28 Jul 2016 09:49:01 GMT SimoneMilesi 2016-07-28T09:49:01Z GEO code required for custom report https://community.sap.com/t5/application-development-and-automation-discussions/geo-code-required-for-custom-report/m-p/11800925#M1954063 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>we are currently developing a custom report for employee extraction in HCM.</P><P>The output file of this report requires the country code of the employee.</P><P>The country code (ISO) can be derived of infotype 0006 addresses.</P><P>The problem is that in the output not the ISO country code is required but the GEO code.</P><P>For example: Germany is DE in ISO but GM in GEO.</P><P>I don´t think there is a table where this GEO code is stored in SAP standard.</P><P></P><P>Is there a table or another possibility do get this code somehow without creating a custom mapping table?</P></BODY></HTML> Thu, 28 Jul 2016 09:32:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/geo-code-required-for-custom-report/m-p/11800925#M1954063 Simon_Resch 2016-07-28T09:32:39Z Re: GEO code required for custom report https://community.sap.com/t5/application-development-and-automation-discussions/geo-code-required-for-custom-report/m-p/11800926#M1954064 <HTML><HEAD></HEAD><BODY><P>Hi Simon,</P><P>i'm not so expert in HR world so I do not know if there is any table for Geo Names.</P><P>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 <A href="http://www.geonames.org/export/web-services.html" title="http://www.geonames.org/export/web-services.html">GeoNames Web Service Documentation</A></P><P>Once you retrieve them, you store in internal table and use as per your needs.</P></BODY></HTML> Thu, 28 Jul 2016 09:49:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/geo-code-required-for-custom-report/m-p/11800926#M1954064 SimoneMilesi 2016-07-28T09:49:01Z