Skip to Content
avatar image
Former Member

String to DATS format Conversion

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 11, 2007 at 09:33 PM

    Lokesh,

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

    raj.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2007 at 08:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2007 at 11:32 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2007 at 04:14 AM

    Define both as string in XI..

    It should work.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 13, 2007 at 02:46 PM

    Thanks Experts for your valuable comments!!

    Add comment
    10|10000 characters needed characters exceeded