Conversion of SAP Systems to Unicode

1 SPC200 Conversion of SAPS ystems to Unicode SAP AG 2006, SAP TechEd 06 / SPC200 / 2 AgendaMichaela SeeNW Internationalization, SAP AGMartin SchmidtNW Internationalization, SAP AGIntroductionUnicode SAP System Why and HowUnicode Conversion Paths Basic ConceptHow to Convert a SystemHardware, Sizing, DowntimeAdditional InformationReferences and ContactsUnicode Conversion Paths SAP AG 2006, SAP TechEd 06 / SPC200 / 4 [ Unicode is] the encoding standard [which] provides the basis forprocessing, storage and interchange of text data in any language in allmodern software and informationtechnology protocols. see: is Unicode ? SAP AG 2006, SAP TechEd 06 / SPC200 / 5 Solution: Unicode , One Code Page for All ScriptsEnglishGermanTurkishDanishDutch,F innishFrench, ItalianNorwegianPortugueseSpanishSwedish CroatianCzechHungarianPolishRumanianSlov akianSloveneRussianUkrainianGreekHebrewT haiKoreanJapaneseChineseTaiwaneseIceland icAnd morelanguagescan besupportedeasilywithout theneed fornew codepages orother newmethods( Vietnamese,Indic Scripts) SAP AG 2006, SAP TechEd 06 / SPC200 / 6 SAP Pre- Unicode Solutions.

2 Single Code PagesTurkishCroatianCzechHungarianPolish RumanianSlovakianSloveneEnglishGermanDan ishDutch,FinnishFrench, ItalianNorwegianPortugueseSpanishSwedish RussianUkrainianGreekHebrewThaiKoreanJap aneseChineseTaiwaneseIcelandic SAP AG 2006, SAP TechEd 06 / SPC200 / 7 Disadvantages of old standard code pages Each covers only a subset of all characters used Incompatibilities between different code pages Only restricted data exchange possible Too many of themLanguages: 41 Characters: 22,378 Code Pages: 390 SAP Pre- Unicode Solutions: Single Code PagesCanonKYOCERAAPPLEIS0-9IS0-2IS0-3IS0 -512IS0-7125012511252 HPIBMIS0-9IS0-2IS0-3 EBCDIC12IS0-7697/0277697/050012521256IS0 -2IS0-312571254125012511252 MicrosoftASCIIBIG-5 SJISIS0-9IS0-2IS0-3IS0-5IS0-6IS0-7IS0-8I S0-4IS0-1 BIG-5 SJISIS0-9IS0-2IS0-3IS0-5IS0-6IS0-7IS0-8I S0-4IS0-1 SAP SAP AG 2006, SAP TechEd 06 / SPC200 / 8 Pre- Unicode Solution for Multiple Languages: MDMPWest European ViewJapanese ViewKorean View SAP AG 2006, SAP TechEd 06 / SPC200 / 9 Pre- Unicode Solution for Multiple Languages.

3 MDMPWest European ViewJapanese ViewKorean ViewNosupport as of mySAP ERP 2005 IntroductionUnicode SAP System Why and HowUnicode Conversion Paths Basic ConceptHow to Convert a SystemHardware, Sizing, DowntimeAdditional InformationReferences and ContactsUnicode Conversion Paths SAP AG 2006, SAP TechEd 06 / SPC200 / 11 Who Needs Unicode ? Companies running global business processes like Global HRSystems or Global Master Data Management Companies offering Web Services to their customers: GlobalMaster Data containing multiple local language characters. Companies using Open Standards: J2EE and .NET integration(JAVA speaks Unicode ) Collaborative Business: Integration of Third Party Products thatrun on different code pagesActing in global business requires support of a Global Character Set! SAP AG 2006, SAP TechEd 06 / SPC200 / 12 Example: Application ImpactExample:CRM Business Partner SAP AG 2006, SAP TechEd 06 / SPC200 / 13 Example: System Integration and Non-UnicodeABAPKSC5601: J#rg M#llerJ2 EEUnicode: J rg M llerWeb Dynpro J rg M ller J#rg M#ller J rg M llerUnicodeNon- Unicode SAP AG 2006, SAP TechEd 06 / SPC200 / 14 Example: System Integration and UnicodeABAPU nicode: J rg M llerJ2 EEUnicode: J rg M llerWeb Dynpro J rg M ller J rg M ller J rg M llerUnicodeNon- Unicode SAP AG 2006, SAP TechEd 06 / SPC200 / 15 Example: Scripts Supported With Unicode In South Asian countries there are a lot of different officialscripts, for example Devanagari (mainly used for writing Hindi),Tamil and scripts are supported in Unicode SAP Systems .

4 General information about South Asian scripts in the Unicodestandard are available here: Attached to SAP Note73606you will find an excel sheet listingall languages which are technically supported in SAP Systems . SAP Note895560provides information about languages whichare only supported in Unicode SAP Notes73606895560 SAP AG 2006, SAP TechEd 06 / SPC200 / 16In this table the column NAME contains the term for color Blue inthree Indic script languages: Hindi (HI) Kannada (KN) Tamil (TA)Example:Indic Scripts in Unicode SAP systemsExample: Scripts Supported With Unicode SAP AG 2006, SAP TechEd 06 / SPC200 / 17 Internationalized Software With Unicode TheUnicodeStandard was adopted by industry leaders , HP, IBM JustSystem, Microsoft , Oracle, SAP, Sun ,Sybase, Unisys and many others. Unicodeis required by modern standards such as XML,Java , ECMAS cript (JavaScript ), LDAP, CORBA , andWML.

5 Unicodeis the official way to implement ISO/IEC 10646 andis supported in many operating Systems and all modernbrowsers. SAP AG 2006, SAP TechEd 06 / SPC200 / 18 Conclusion: Why Convert to Unicode ? Unicode defines the character set for .. efficient text processing in any maintaining text data integrityUnicode Systems .. need only one locale ( Unicode locale = platform-independent).. integrate seamless in existing system landscape (SAP andnon-SAP Systems ).. provide all ISO 639-2 language keys and 86 additional country-specific language keys a total of 560 technically supported languages!Users can .. enter and display any character from any script no matter whichlogon language they print text data in multiple languages SAP AG 2006, SAP TechEd 06 / SPC200 / 19 Why Convert to Unicode ?One character set in systemlandscapeEasy handling for endusersLower operation costsIntroductionUnicode SAP System Why and HowUnicode Conversion Paths Basic ConceptHow to Convert a SystemHardware, Sizing, DowntimeAdditional InformationReferences and ContactsUnicode Conversion Paths SAP AG 2006, SAP TechEd 06 / SPC200 / 21 Ways to Your Unicode SAP SystemUnicode Conversion without UpgradeCombined Upgrade & Unicode ConversionTwin Upgrade & Unicode Conversionfor target release mySAP ERP 2005 onlypilot projectSupported Unicode Conversion Paths standard path: Web AS mySAP ERP 2004 SAP AG 2006, SAP TechEd 06 / SPC200 / 22 Prerequisites Unicode -based mySAP components For current status, see SAP Note 79991.

6 Unicode - enabled ABAP programs For more information, please visit the following session: Related Workshops/Lectures at SAP TechEd 2006 SPC251, making programs Unicode enabled , Hands-onPrerequisites SAP AG 2006, SAP TechEd 06 / SPC200 / 23 Basic Concept1. Prepare non- Unicode Export non- Unicode database and convert non- Unicode Create new Unicode database and import the non- Unicode Do post- Conversion activities in the Unicode Conversion Paths are based one concept SAP AG 2006, SAP TechEd 06 / SPC200 / 24 Ways to Your Unicode SAP SystemUnicode Conversion without UpgradeCombined Upgrade & Unicode ConversionTwin Upgrade & Unicode Conversionfor target release mySAP ERP 2005 onlypilot projectSupported Unicode Conversion Paths standard path: Web AS mySAP ERP 2004 SAP AG 2006, SAP TechEd 06 / SPC200 / 25easyPrepare Non- Unicode SystemAll character data in the non-UC database requirelanguage information before the database export Code Page Systems /Unambiguous Blended Code Page Systems (ca.)

7 90% of all customer Systems )MDMP Systems /Ambiguous Blended Code Page Systems (ca. 10% of all customer installations)WHY?not soeasy CODE PAGE ASSIGNMENT SAP AG 2006, SAP TechEd 06 / SPC200 / 26 Content in Unicode we need to knowthe language/code pageof every character .. SAP AG 2006, SAP TechEd 06 / SPC200 / 27 MDMPJU nicode Database ConversionMDMP System (logonlanguage DE)UnicodeSystemRUJAKO150080008500410341 034103DE11004103 Code Page Switch SAP AG 2006, SAP TechEd 06 / SPC200 / 28 Example: Russian Text Data in MDMP SystemThe Hex-code entry0xE2D5 DAE1E2is found in adatabase table which has no language system configurationISO-8859-1 (Western Europe)ISO-8859-2 (Eastern Europe)ISO-8859-5 (Cyrillic)The entry could be either: Englishk Polish RussianWorst case: Russian speakers have to identify the data D5 DA E1 E2 ISO-8859-1 ISO-8859-2 ISO-8859-5 SAP AG 2006, SAP TechEd 06 / SPC200 / 29 Prepare Non- Unicode SystemProblemCode page assignment in MDMP/Ambig.

8 Blended Code PageSystems is complex, because ..ALL table rows in the database need code page information!Solution: You use existing language information create and maintain a Vocabulary (collect wordsJassign language) import and use a Vocabulary from another system(sandboxJprod. system) use various assignment methods delivered by SAPI ntroductionUnicode SAP System Why and HowUnicode Conversion Paths Basic ConceptHow to Convert a SystemHardware, Sizing, DowntimeAdditional InformationReferences and ContactsUnicode Conversion Paths SAP AG 2006, SAP TechEd 06 / SPC200 / 31 Prepare Non- Unicode System: Transaction SPUMGP reparationUnicode ConversionFinalizationSUMGC onversionCompletionin theUnicodesystemSAPinst(R3load)DatabaseE xport, Conversion & Import Unicode system isup and running Verification ofData Consistency IntegrationTesting focusedon languagehandling Set up theConversionProject CheckPrerequisites Plan databasedowntimeduringconversion EnableCustomerDevelopmentsSPUMGC onversionPreparationinnon-Unicodesystem SAP AG 2006, SAP TechEd 06 / SPC200 / 32 SPUMG Consistency Check Tables without Language Information Tables with Ambiguous Language Information Tables with Language Information Reprocess INDX Analysis INDX RepairSPUMG consists of several database scansIn transaction SPUMG you collect and analyzecharacter data without code page information.

9 SPUMG creates control information that will be used during thedatabase PageandMDMP! SAP AG 2006, SAP TechEd 06 / SPC200 / 33 SPUMG Language ListsDrag&DropAll languages supported in non-UC SAPsystems are inserted automatically: activeinstalled in the system, can be usedfor Vocabulary maintenance inactivenot installed, but can occur in tableswith Lang. Infocannot be used in Vocabulary but duringconversion SAP AG 2006, SAP TechEd 06 / SPC200 / 34 SPUMG SettingsMaintain the SPUMG settings and then initialize the worklist forthe Consistency Check!GlobalFallbackCode PageSettings for theVocabulary:MDMP only! SAP AG 2006, SAP TechEd 06 / SPC200 / 35 Checks table consistency (existence in DDIC, access) Writes control information to SPUMG control tables Classifies tables into tables with or withoutlanguage information (MDMP only)Consistency InfoWith InfoSingle CodePage andMDMP!

10 SAP AG 2006, SAP TechEd 06 / SPC200 / Without Language InformationConsistencyCheckWithoutLang. InfoWith InfoMDMP only! The goal of this scan is to build the Vocabulary! All tables without language information are scanned. SAP AG 2006, SAP TechEd 06 / SPC200 / 37 Tables With Ambiguous Language InformationConsistencyCheckWithoutLang. InfoWith only! All tables with language information are scanned. Words with an ambiguous language are added to SAP AG 2006, SAP TechEd 06 / SPC200 / 38 VocabularyThe Vocabulary must be filled and maintainedbefore the database export is can Reuse existing language code page assign-ments imported from other Systems ordelivered by SAP Insert language keys automatically with scanTables withLanguage Information CreateVocabulary Hintsto assign a language based onother table fields Manually assign language to word inthe Vocabulary Do automatic language assignment withpredefined methods Download and use language patternsSAP Notes756534756535871541 MDMP only!