Site icon SAP Human Resources Experts And Solutions

Data conversion in SAP ALE

<p>Some time ago we discussed SAP ALE&comma; what it is&comma; how it works&period; <a href&equals;"http&colon;&sol;&sol;saphcmsolutions&period;com&sol;2017&sol;08&sol;21&sol;sap-ale-works&sol;" target&equals;"&lowbar;blank" rel&equals;"noopener">Here is the link<&sol;a>&period; Today I want to share with you how we can change data on-fly when we need to do some conversion during the integration process&period;<&sol;p>&NewLine;<p>Usually&comma; we need conversion in heterogeneous landscapes&comma; where different systems presented with miscellaneous settings&comma; types&comma; architectures&period; Let&&num;8217&semi;s say you want to include a new SAP ERP during company acquisition into your landscape&period; There will be another business unites codes or personnel numbers&comma; which differ from your present system&period; Or you want to send some flag depending on your conditions in the source system&period; Here data conversion rules come into place&period;<&sol;p>&NewLine;<p>When you do SAP ALE configuration&comma; you usually use IDOC conversion rules&period; So to start with conversions&comma; have a look at these three IMG paths&period; Run SALE transaction and scroll down to our menu&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;01&period;png"><img class&equals;"alignnone size-full wp-image-2432" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;01&period;png" alt&equals;"" width&equals;"523" height&equals;"374" &sol;><&sol;a><&sol;p>&NewLine;<p><&excl;--more--><&sol;p>&NewLine;<p>Create Rule &lpar;BD62 transaction&rpar; defines rules per segment which works for specified segment&period;<&sol;p>&NewLine;<p>Maintain Rule &lpar;BD79 transaction&rpar; defines fields we want to convert&comma; what algorithms to use&period; If double click on &&num;8216&semi;Sender fld val&&num;8217&semi;&comma; a new window opens with a bunch of settings&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;02&period;png"><img class&equals;"alignnone size-full wp-image-2433" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;02&period;png" alt&equals;"" width&equals;"820" height&equals;"183" &sol;><&sol;a> <a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;03&period;png"><img class&equals;"alignnone size-full wp-image-2434" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;03&period;png" alt&equals;"" width&equals;"710" height&equals;"787" &sol;><&sol;a><&sol;p>&NewLine;<p>Assume&comma; field &&num;8216&semi;Nickname&&num;8217&semi; should be filled with a constant&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;05&period;png"><img class&equals;"alignnone size-full wp-image-2439" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;05&period;png" alt&equals;"" width&equals;"699" height&equals;"533" &sol;><&sol;a><&sol;p>&NewLine;<p>Done&comma; let&&num;8217&semi;s verify&period; Run PFAL transaction&comma; select personnel number and send&period; In BD87 transaction open Outgoing IDOCs to see what would be sent through ALE&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd97&lowbar;01&period;png"><img class&equals;"alignnone size-full wp-image-2440" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd97&lowbar;01&period;png" alt&equals;"" width&equals;"1014" height&equals;"555" &sol;><&sol;a><&sol;p>&NewLine;<p>Looks like it works&period; Let&&num;8217&semi;s complicate&period; We want to convert value based on some table values&period; For each old value&comma; we need a new value&period; In this case&comma; I want to change initials from the second infotype&period; Silly&comma; I know&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;02&period;png"><img class&equals;"alignnone size-full wp-image-2562" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;02&period;png" alt&equals;"" width&equals;"745" height&equals;"541" &sol;><&sol;a><&sol;p>&NewLine;<p>In &&num;8216&semi;value receiver&&num;8217&semi; field we set what we expect to be as an outcome&comma; on the right side &&num;8211&semi; income value&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;03&period;png"><img class&equals;"alignnone size-full wp-image-2563" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;03&period;png" alt&equals;"" width&equals;"487" height&equals;"227" &sol;><&sol;a><&sol;p>&NewLine;<p>Run PFAL and look at the result&period; My name is <a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;resume-sap-architect&sol;">Vitalii Igorevich<&sol;a>&comma; so initials are VI&period; They were changed to IV&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;04&period;png"><img class&equals;"alignnone size-full wp-image-2564" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;bd79&lowbar;04&period;png" alt&equals;"" width&equals;"995" height&equals;"454" &sol;><&sol;a><&sol;p>&NewLine;<p>In Assign Rule to Message Type &lpar;BD55 transaction&rpar; we assign conversion rules to logical systems&period; It would allow us to be more specific and apply conversions to specific systems&period; It could be helpful in heterogeneous systems&period;<&sol;p>&NewLine;<p><a href&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;04&period;png"><img class&equals;"alignnone size-full wp-image-2436" src&equals;"http&colon;&sol;&sol;saphr&period;ru&sol;wp-content&sol;uploads&sol;sale&lowbar;04&period;png" alt&equals;"" width&equals;"693" height&equals;"238" &sol;><&sol;a><&sol;p>&NewLine;<p>I&&num;8217&semi;d recommend you to read my another article about sending long-tail infotypes in SAP HCM &&num;8211&semi; <a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;how-to-send-custom-infotype-over-sap-ale&sol;" target&equals;"&lowbar;blank" rel&equals;"noopener">How to send custom infotype over SAP ALE<&sol;a>&period; There are also some tricks how to convert data with ABAP code&period; There you will take full control od data exchange in SAP landscape&period;<&sol;p>&NewLine;<p><&excl;-- Begin MailChimp Signup Form --><&sol;p>&NewLine;<style type&equals;"text&sol;css">&NewLine;&Tab;&num;mc&lowbar;embed&lowbar;signup&lbrace;background&colon;&num;fff&semi; clear&colon;left&semi; font&colon;14px Helvetica&comma;Arial&comma;sans-serif&semi; width&colon;100&percnt;&semi;&rcub;<br &sol;>&NewLine;&Tab;&sol;&ast; Add your own MailChimp form style overrides in your site stylesheet or in this style block&period;<br &sol;>&NewLine;&Tab; We recommend moving this block and the preceding CSS link to the HEAD of your HTML file&period; &ast;&sol;<br &sol;>&NewLine;<&sol;style>&NewLine;<div id&equals;"mc&lowbar;embed&lowbar;signup">&NewLine;<form id&equals;"mc-embedded-subscribe-form" class&equals;"validate" action&equals;"https&colon;&sol;&sol;saphcmsolutions&period;us3&period;list-manage&period;com&sol;subscribe&sol;post&quest;u&equals;9946caca159afc9a77502e9a5&amp&semi;id&equals;ba2e54e4b1" method&equals;"post" name&equals;"mc-embedded-subscribe-form" novalidate&equals;"" target&equals;"&lowbar;blank">&NewLine;<div id&equals;"mc&lowbar;embed&lowbar;signup&lowbar;scroll"><label for&equals;"mce-EMAIL">Stay tuned for our best practices and top-notch advice<&sol;label><br &sol;>&NewLine;<input id&equals;"mce-EMAIL" class&equals;"email" name&equals;"EMAIL" required&equals;"" type&equals;"email" value&equals;"" placeholder&equals;"email address" &sol;><br &sol;>&NewLine;<&excl;-- real people should not fill this in and expect good things - do not remove this or risk form bot signups--><&sol;p>&NewLine;<div style&equals;"position&colon; absolute&semi; left&colon; -5000px&semi;" aria-hidden&equals;"true"><input tabindex&equals;"-1" name&equals;"b&lowbar;9946caca159afc9a77502e9a5&lowbar;ba2e54e4b1" type&equals;"text" value&equals;"" &sol;><&sol;div>&NewLine;<div class&equals;"clear"><input id&equals;"mc-embedded-subscribe" class&equals;"button" name&equals;"subscribe" type&equals;"submit" value&equals;"Subscribe" &sol;><&sol;div>&NewLine;<&sol;div>&NewLine;<&sol;form>&NewLine;<&sol;div>&NewLine;<p><&excl;--End mc&lowbar;embed&lowbar;signup--><&sol;p>&NewLine;

Exit mobile version