Source as string and target a decimal

[Former Member]

hi...

my target bapi has a field <b>delivery_date</b> of type "decimal" (yes, it is decimal)

and my source file has input field as mm/dd/yyyy ...

so how do i paas my source structure to the target and get a response so tht there wud be no mismatch between my source and target...

do i use the date transformation in the mapping..??

if this is done, the input field still remains as say strin and target as decimal..? will this work..?

regards,,

vishal

[bhavesh_kantilal · Accepted solution]

Do the date transformation in the mapping.

The validation is not done in the mapping for the format type and this will happen only when the data reaches the target.

SO, as long as the format is correct there will be no issue.

Regards,

Bhavesh

[Former Member · Accepted solution]

hi bhavesh,

so fr the decimal, if i pass it as "MMDDYYYY HHMMSS" it shud work right??

the decimal target structure is meant for date and time.

[Shabarish_Nair · Accepted solution]

so fr the decimal, if i pass it as "MMDDYYYY HHMMSS" it shud work right??

>>>> you validation will be in target system.

You can handle it in Xi or in the target sys. if you know wht format it needs (say without /), you cud altyer it in your mapping and send.

[bhavesh_kantilal · Accepted solution]

hmmm.. there will not be an issue in XI.The target system should be able to handle the data that you pass to it.

Just find out what format it expects the data and send it in that format if possible by changing it in the mapping.

Regards,

Bhavesh

[Shabarish_Nair]

delivery_date of type "decimal"

>>> hmmm !!!!

maybe you cud just write a UDF or use std func replaceString to replace '/' with empty space.

[Former Member]

shabz,

v r plannin vry much the same...

thanx..