04-16-2007 4:48 PM
We are interested in tracking a business process by the UN Statistical macro geographical regions found at the following website: http://unstats.un.org/unsd/methods/m49/m49regin.htm
Has anyone done this and have any guidance?
Our current thought is that we'd create our own new table that is keyed on the 2-character country codes standard in SAP. We'd like to use the "Alternate Country Key" to represent the 3-digit ISO codes; but, it appears that SAP has prepopulated the field with non-ISO values.
The current table layout would be something like:
2-char ISO code (key)
3-digit alt.country key (delivered with SAP)
3-digit ISO code
3-digit geographical region
3-digit geographical subregion.
The entry for Belgium would look like this:
BE 017 056 155 (Western Europe) 150 (Europe)
06-06-2007 4:43 PM
Hi Loren,
Please, verify in web site some information regarding ISO CODE:
"http://help.sap.com/saphelp_erp2005vp/helpdata/en/99/49cd70bb4611d2b4ca006094b92d29/frameset.htm"
Regards,
Paulo
06-06-2007 4:48 PM
Sorry, I am looking for a standard solution for assigning countries to larger geographic regions. The web link provided is information on languages and characters used for program code.