|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Date mapping logic to convert date to dd-MON-yyyy format in PI/XI
By Deepak Shah, L&T Infotech
databases (e.g. Oracle) accept date in dd-MON-yyyy format. If they don’t
receive date in this format then an exception is triggered. This cannot be
achieved using standard date transformation function available. Following
mapping logic will help in converting date from yyyy-MM-dd to dd-MON-yyyy
condition’ checks if the source date field in not blank or zero. If source
date field comes blank then blank value is passed to target.
substring (0...4) function will filter out ‘year’ part from input date.
(5..7) filters out month part from the input string and then gets equivalent
month in “MON” format which is defined in fix value function shown below.
(8...10) function filters the day from the input date string.
Testing the Message mapping in test tab.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards