Skip to Content
avatar image
Former Member

Date Format Error

Hi frends,

iam working in file_rfc_file scenario in PI7.1.my source data type as XSD:Date format is dd/mm/yyyy and in rfc it as yyyy/mm/dd

Using Data transfer function i hve made all changes but iam stil iam geeting the same error as.

could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Date '2010/05/12' has a wrong format at field DATUV: Unparseable date: "2010/05/12"

my input xml is.

<?xml version="1.0" encoding="UTF-8"?>

http://a.com/xi/erp/n47">

<Ecsin>

<Datuv>12/05/2010</Datuv>

<Equnr>10000958</Equnr>

<Stlan>4</Stlan>

<Stlty>E</Stlty>

<Trtyp>*</Trtyp>

<Werks>1000</Werks>

</Ecsin>

</ns0:Mt_Ecsin>

Help me out to sort this issue

With Regards,

Dinesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    May 12, 2010 at 07:37 AM

    >

    > could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Date '2010/05/12' has a wrong format at field DATUV: Unparseable date: "2010/05/12"

    if this is a JCO exception during the RFC call, then this is definitly because of the date format. the internal date format in SAP is YYYYMMDD. so have the date converted to tht format before making the RFC call

    http://www.sapdb.org/7.4/htmhelp/48/0d8018b4f211d2a97100a0c9449261/content.htm

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2010 at 07:13 AM

    Hi,

    I think u r data transformation is wrong.As per my understand RFC(SAP) requires date type is

    YYYY/MM/DD.But u made it in to YYYY/DD/MM and also check with data type of both the elements are 'DATE' data type.

    Thanks

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • May 12, 2010 at 07:06 AM

    Confirm which date format RFC expecting,

    YYYY/MM/DD or YYYY/DD/MM. I guess RFC expecting YYYY/MM/DD and you are converted to YYYY/DD/MM.

    Regards,

    Balaji

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2010 at 07:26 AM

    Hi Dinesh,

    In general the standard RFCs expecting the date format as "YYYYMMDD" so change the date format and try again, it solves your problem.

    Use the date format with out delimeter ' / '.

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded