jdbc-rfc mapping error

[Former Member]

Hi...All,

we r doing JDBC-RFC Scenario, in this we are facing problem while mapping the source date and target date fields .

i tried with using the date transfer function, but i am getting the mapping exception date unparseble error.

pls suggest me how can i rectify this error..

thanks in advance,

Pasi.

[Former Member]

Hi,

If target format is supported by XI then you used in built function of Transfermation. If XI is not supported you need to write udf

Thanks,

RamuV

[Former Member]

Hi pasi,

date unparseble error is due to mismatch of the date format between the Sr sys and Trg Sys pls do chk with ur Sr date format are goining with the standard functons or else UDF

if u are goining with UDF pls do chk the code for conversions

Thanx

Sampath

[GabrielSagaya]

Use Date in the form of YYYYMMDD in the properties of the function DateTransfer between source and target message

[Former Member]

Hi....Seshagiri / Selvam,

I tried with using the date transformation only(yyyymmdd), still i am getting the same error.

pls consider we r fetching the data from database and it should be transormed to SAP format.

pls help me...

Regards,

Pasi

Edited by: pasi s on Jun 23, 2008 3:17 PM

[rodrigoalejandro_pertierr]

hi,

put the date you receive from DB.

also check the real format value that receiver R3 is specting.

try ussing TransDate with this values:

20080101

01012008

sap format is yyyyMMdd but in some cases it wait for yyyyddMM

hope Helps.

Rodrigo

[Former Member]

Hi,

in mapping,

Source Date--Data TransformaationTarget Date

in the properities of the data Transformation----use your source JDBC date format and in the target

specify the SAP Date Format.(may be 20080623)

Regards

Seshagiri