on 11-11-2007 8:52 PM
Hello Experts,
I am using Powerbuilder system to get my Legacy data.In Powerbuilder Date needs to be supplied in STRING format.So I am giving String Format (dd-mmm-yyyy).
However, at SAP end, Date needs to be in DATS format (Standard SAP yyyymmdd) .
In Message Mapping I have given I/P structure as String and O/P structure as DATS format. When I test mapping in XI, it gives me Parseable error.
Can anybody tell me, is there any way in XI to convert from String to DATS format so that I do not get Parseable error.
Please Help!!!!
Lokesh,
With XI there is a date transformation function under date category there you need to provide source date format and target date format..
I have used the same for fetching the data from oracle..and posting into SAP..it works fine..
Try this ..this will solve ur problem....you just need to see what is the exact date format used by powerbuilder internally...
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
while doing string to DATS format you have to use Date Transformation Function, in Source date format dd-MMM-yyyy
Target date format yyyyMMdd (which is SAP understandable).
now when u r going for test , <b>plz give the right format in source date</b>
i.e 24-009-2007, <b>if you make it blank then also same error will come so you have to give the source date .</b>
hope this will help u.
thanx
HONEY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How are you converting the Source Date format into the Target Format?
Are you using the Standard DateTransformation function? If yes, is the source and the target format set as needed?
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Bhavesh for a quick reply!!!
Yes, I am using Date Transformation Function.
Source date is dd-MMM-yyyy (String Format)
I have used date transformation to convert to yyyyMMdd format.
But, when I test Message mapping it gives me Parseable Error, as source is in String and target is in DATS format (RFC field, SAP).
Please Help!!!
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.