SAP BLOG Country Classifications based on M49 Coding.

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,925
Tepki puanı
7
Puanları
6
Purpose:

The purpose of this blog is for Country Classifications based on M49 Coding for UN Agencies



Step1:

Develop a customized report on MKVZ and include country classification based on M49 coding. This classification will ensure alignment with (High-Level Committee on Management) HLCM Standardization across the UN.

In the SAP system country, wise global parameters of vendors’ country of origin are displayed by a corresponding ISO-2 alpha code (i.e., Vietnam = VN). There are currently no classification options in the SAP system to indisocio-economicnomic prosperity or geographic context.

Step2:

The implementation of the M49 Standard changing the ISO-2 alpha code to the ISO-3 alpha code (i.e., VN -> VNM) and the inclusion of the M49 country code (i.e., Vietnam = 704) which assigns countries a numeric based on their geographic location. Most importantly, it includes the SIDS (Small Island Developing States), LDCs (Least Developed Countries), and LLDCs (Land-Locked Developing Countries) categorizations for countries based on their economic development. This serves to replace other categorizations such as “developing/developed”, etc.



  1. a. Custom table to be created to include the classification of countries as per the following excel sheet with reference to standard global country parameters Transaction code from Reach (SAP) system.



  1. b. Table data will be uploaded through program initially in all clients, for suppose any changes required, it should be editable (cross-client).



  1. c. Any change the in custom table it will up the date in report as well with respective country classifications data. If any changes in further



  1. d. The change client’s client perspective will be done through a new customized transaction e.g.: (Z_countryclass) to be accessible by end users and related updates to be reflected automatically to the custom table and to the report (Z_MKVZ) accordingly.



For Example;
OY01


OY01​



Step3.

These values need to be maintained in the custom table



Legend
LDCLeast Developed Country
LLDCLand Locked Developing Country
SIDSSmall Island Developing State





Country Shortcut (from SAP)Country Name (from SAP)LDCLLDCSIDSISO3 CodeM49 Code
AFAfghanistanxxAFG4
ALAlbaniaALB8
DZAlgeriaDZA12
VIAmer.Virgin Is.xVIR850
ADAndorranAND20
AOAngolaxAGO24
AIAnguillaxAIA660
AQAntarcticaATA10
AGAntigua/BarbudaxATG28
ARArgentinaARG32
AMArmeniaxARM51
AWArubaxABW533
AUAustraliaAUS36
ATAustriaAUT40
AZAzerbaijanxAZE31
BSBahamasxBHS44
BHBahrainBHR48
BDBangladeshxBGD50
BBBarbadosxBRB52
BYBelarusBLR112
BEBelgiumBEL56
BZBelizexBLZ84
BJBeninxBEN204
BMBermudaBMU60
BTBhutanxxBTN64
BLBlue#N/A#N/A
BOBoliviaxBOL68
BABosnia-Herz.BIH70
BWBotswanaxBWA72
BVBouvet IslandsBVT74
BRBrazilBRA76
IOBrit.Ind.Oc.TerIOT86
VGBrit.Virgin Is.xVGB92
BNBrunei Daruss.BRN96
BGBulgariaBGR100
BFBurkina FasoxxBFA854
MMBurmaxMMR104
BIBurundixxBDI108
KHCambodiaxKHM116
CMCameroonCMR120
CACanadaCAN124
CVCape VerdexCPV132
CFCARxxCAF140
KYCayman IslandsCYM136
TDChadxxTCD148
CLChileCHL152
CNChinaCHN156
CXChristmas IslndCXR162
CCCoconut IslandsCCK166
COColombiaCOL170
KMComorosxxCOM174
CKCook IslandsxCOK184
CRCosta RicaCRI188
CICote d’IvoireCIV384
HRCroatiaHRV191
CUCubaxCUB192
CYCyprusCYP196
CZCzechiaCZE203
CDDem. Rep. CongoxCOD180
DKDenmarkDNK208
DJDjiboutixDJI262
DMDominicaxDMA212
DODominican Rep.xDOM214
ANDutch Antilles#N/A#N/A
TLTimor LestexxTLS626
TPEast Timor#N/A#N/A
ECEcuadorECU218
EGEgyptEGY818
SVEl SalvadorSLV222
GQEquatorial GuinGNQ226
EREritreaxERI232
EEEstoniaEST233
ETEthiopiaxxETH231
EUEuropean Union#N/A#N/A
FKFalkland IslndsFLK238
FOFaroe IslandsFRO234
FJFijixFJI242
FIFinlandFIN246
FRFranceFRA250
PFFrenc.PolynesiaxPYF258
GFFrench GuayanaGUF254
TFFrench S.TerritATF260
GAGabonGAB266
GMGambiaxGMB270
GEGeorgiaGEO268
DEGermanyDEU276
GHGhanaGHA288
GIGibraltarGIB292
GRGreeceGRC300
GLGreenlandGRL304
GDGrenadaxGRD308
GPGuadeloupeGLP312
GUGuamxGUM316
GTGuatemalaGTM320
GNGuineaxGIN324
GWGuinea-BissauxxGNB624
GYGuyanaxGUY328
HTHaitixxHTI332
HMHeard/McDon.IslHMD334
HNHondurasHND340
HKHong KongHKG344
HUHungaryHUN348
ISIcelandISL352
INIndiaIND356
IDIndonesiaIDN360
IRIranIRN364
IQIraqIRQ368
IEIrelandIRL372
ILIsraelISR376
ITItalyITA380
JMJamaicaxJAM388
JPJapanJPN392
JEJerseyJEY832
JOJordanJOR400
KZKazakhstanxKAZ398
KEKenyaKEN404
KIKiribatixxKIR296
XKKosovo#N/A#N/A
KWKuwaitKWT414
KGKyrgyzstanxKGZ417
LALaosxxLAO418
LVLatviaLVA428
LBLebanonLBN422
LSLesothoxxLSO426
LRLiberiaxLBR430
LYLibyaLBY434
LILiechtensteinLIE438
LTLithuaniaLTU440
LULuxembourgLUX442
MOMacauMAC446
MKMacedoniaMKD807
MGMadagascarxMDG450
MWMalawixxMWI454
MYMalaysiaMYS458
MVMaldivesxMDV462
MLMalixxMLI466
MTMaltaMLT470
MHMarshall IslndsxMHL584
MQMartiniqueMTQ474
MRMauritaniaxMRT478
MUMauritiusxMUS480
YTMayotteMYT175
MXMexicoMEX484
FMMicronesiaxFSM583
UMMinor Outl.Isl.UMI581
MDMoldovaxMDA498
MCMonacoMCO492
MNMongoliaxMNG496
MEMontenegroMNE499
MSMontserratxMSR500
MAMoroccoMAR504
MZMozambiquexMOZ508
MPN.Mariana IslndxMNP580
NANamibiaNAM516
NTNATO#N/A#N/A
NRNauruxNRU520
NPNepalxxNPL524
NLNetherlandsNLD528
NCNew CaledoniaxNCL540
NZNew ZealandNZL554
NINicaraguaNIC558
NENigerxxNER562
NGNigeriaNGA566
NUNiuexNIU570
NFNorfolk IslandsNFK574
KPNorth KoreaPRK408
NONorwayNOR578
OMOmanOMN512
OROrange#N/A#N/A
OTOther#N/A#N/A
PKPakistanPAK586
PWPalauxPLW585
PSPalestinePSE#N/A
PAPanamaPAN591
PGPap. New GuineaxPNG275
PYParaguayxPRY600
PEPeruPER604
PHPhilippinesPHL608
PNPitcairn IslndsPCN612
PLPolandPOL616
PTPortugalPRT620
PRPuerto RicoxPRI630
QAQatarQAT634
CGRep.of CongoCOG178
REReunionREU638
RORomaniaROU642
RURussian Fed.RUS643
RWRwandaxxRWA646
GSS. Sandwich InsSGS239
STS.Tome,PrincipexxSTP678
SHSaint HelenaSHN654
WSSamoaxWSM882
ASSamoa, AmericaxASM16
SMSan MarinoSMR674
SASaudi ArabiaSAU682
SNSenegalxSEN686
RSSerbiaSRB688
SCSeychellesxSYC690
SLSierra LeonexSLE694
SGSingaporexSGP702
SKSlovakiaSVK703
SISloveniaSVN705
SBSolomon IslandsxxSLB90
SOSomaliaxSOM706
ZASouth AfricaZAF710
KRSouth KoreaKOR408
SSSouth SudanxxSSD728
ESSpainESP724
LKSri LankaLKA144
KNSt Kitts&NevisxKNA659
LCSt. LuciaxLCA662
VCSt. VincentxVCT670
PMSt.Pier,Miquel.SPM666
SDSudanxSDN729
SRSurinamexSUR740
SJSvalbardSJM744
SZEswatinixSWZ748
SESwedenSWE752
CHSwitzerlandCHE756
SYSyriaSYR760
TWTaiwan#N/A#N/A
TJTajikistanxTJK762
TZTanzaniaxTZA834
THThailandTHA764
TGTogoxTGO768
TKTokelau IslandsTKL772
TOTongaxTON776
TTTrinidad,TobagoxTTO780
TNTunisiaTUN788
TRTurkeyTUR792
TMTurkmenistanxTKM795
TCTurks and CaicosTCA796
TVTuvaluxxTUV798
UGUgandaxxUGA800
UAUkraineUKR804
GBUnited KingdomGBR826
UNUnited Nations#N/A#N/A
UYUruguayURY858
USUSAUSA840
AEUtd.Arab Emir.ARE784
UZUzbekistanxUZB860
VUVanuatuxVUT548
VAVatican CityVAT336
VEVenezuelaVEN862
VNVietnamVNM704
WFWallis,FutunaWUF876
EHWest SaharaESH732
YEYemenxYEM887
ZMZambiaxxZMB894
ZWZimbabwexZWE716



Step4:

Same country can have more than one classification, but only one ISO 3 code and one M49 code. Customization of the standard report MKVZ and develop new Z report followed on adding the following as input parameters, output parameters and in the layout of the report:

  • Country classification to contain the three options: LDC, LLDC, SIDS
  • ISO 3 code
  • M49 code



Outcome:

We can get check the Custom report with the below-mentioned multiple scenarios.

Test IDDescriptionReq. ID testedExpected ResultNote
T01List of vendors upon searching with check box: LDC
T02List of vendors upon searching check box: LLDC
T03List of vendors upon searching check box: SIDS
T04List of vendors upon searching check box: LDC, LLDC
T05List of vendors upon searching for vendors with specific M49 code and range of M49 code
T06List of vendors upon searching for vendors with multiple values of ISO codes.



Thankyou.

Okumaya devam et...
 
Üst