String to DATS format Conversion

[Former Member]

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!!!!

[Former Member]

Thanks Experts for your valuable comments!!

[former_member189558]

Define both as string in XI..

It should work.

[Former Member]

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,

[Former Member]

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 , plz give the right format in source date

i.e 24-009-2007, if you make it blank then also same error will come so you have to give the source date .

hope this will help u.

thanx

HONEY

[justin_santhanam]

Lokesh,

Can u give a sample how ur input looks like and how u need to trasnform to output.

raj.