Question Re: blank field getting converted into wrong date in Technology Q&A

blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 11:41:10 GMT

Dear All,

I have one date field in SAP table in which there are some entries and some blank entries.

when Proxy is sending this data from ECC blank entries are converted into 00000000 and through XI in file

this

00000000 entry for date getting converted into wrong date like 30.11.0002 in file.

I have taken data type as string do I need to take data type as date.

My doubt is if there is no entry in table why it is convertng to 00000000 and after passing from XI why it is converting into

30.11.0002 .

Regards

Re: blank field getting converted into wrong date

Shabarish_Nair — Wed, 24 Mar 2010 11:53:30 GMT

check you proxy implemenmtation.

Is proxy logic creating empty dates with value 000000000?

Also if you want to avoid incorrect conversions, do a check on the mapping of the date field in PI.

Use a string comparison or equals functions to check for 00000000 and then do the required processing.

Also I suggest converting the data type of the date field to string in the proxy.

Re: blank field getting converted into wrong date

Former Member — Wed, 24 Mar 2010 11:56:07 GMT

HI,

Check for some conversion routines getting triggered when Proxy is executed in ECC.

Check for the Date format parameters if you have used in mapping.

Regards

Praveen.

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 11:59:44 GMT

Hi Shab,

Yes I have checked the ECC side moni these empty tags are getting converted into 00000000 for this do I have ask abper to send same empty tags beacuse these tags converting into 00000000 in ECC MONI only .and for data type I have take string and ECC side also it is string.

Regards

Re: blank field getting converted into wrong date

Shabarish_Nair — Wed, 24 Mar 2010 12:01:20 GMT


> Hi Shab,
> 
> Yes I  have checked the ECC side moni these empty tags are getting converted into 00000000 for this do I have ask abper to send same empty tags beacuse these tags converting into 00000000 in ECC MONI only .and for data type I have take string and ECC side also it is string.
> 
> 
> Regards

yes. Ask the ABAP folks to default to blank instead of converting it to zeros. The logic resides in ABAP proxy code

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 12:03:39 GMT

why this empty tags are converting into 000000000?

Regards

Re: blank field getting converted into wrong date

stefan_grube — Wed, 24 Mar 2010 12:04:45 GMT

> yes. Ask the ABAP folks to default to blank instead of converting it to zeros.

That would not help. The mapping includes a DateTrans function which leads to an error, when an empty String is processed.

So the mapping has to be adjusted with an if clause.

It seems to be a bug in the DateTarns function, as the result of 00000000 should be 0000000 as well.

Regards

Stefan

Re: blank field getting converted into wrong date

stefan_grube — Wed, 24 Mar 2010 12:05:42 GMT

> why this empty tags are converting into 000000000?

The tag is not empty. ABAP provides an initial date value, this is 00000000.

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 12:09:47 GMT

Hi ,

My date format like this

source --yyyyMMDD

target-DD.MM.YYYY

so if

source is

00000000

should comes like this

target

00.00.0000

but it is converting into

30.11.0002

every where in file values for 00000000 is coming like 30.11.0002

Regards

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 12:11:10 GMT

yes stefan you are absloutly correct these 00000000 are coimg from ECC MONI only

Re: blank field getting converted into wrong date

Shabarish_Nair — Wed, 24 Mar 2010 12:12:35 GMT

Stefan,

the mapping has to be changed in anycase to handle the date as mentioned by me earlier. DateTrans will not handle blank or input date as 00000000

Re: blank field getting converted into wrong date

stefan_grube — Wed, 24 Mar 2010 12:13:41 GMT

> every where in file values for 00000000 is coming like 30.11.0002

This could be

- a bug

- an expected behaviour,

anyway you have to use an if clause to deal with the initial date.

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 12:33:53 GMT

Hi stefan,

|This could be- a bug- an expected behaviour

Is there any reason why these empty tags are getting converted into 00000000 in ECC MONI only(data when getting converted into XML)

Regards

Re: blank field getting converted into wrong date

stefan_grube — Wed, 24 Mar 2010 12:41:17 GMT

> Is there any reason why these empty tags are getting converted into 00000000 in ECC MONI only(data when getting converted into XML)

In fact the values are not converted. The 00000000 are the values which are stored in db table.

This is the default value for an initial (non-existing) date.

Re: blank field getting converted into wrong date

abhay_aggarwal — Wed, 24 Mar 2010 13:10:04 GMT

Hi Stefan,

thanks for reply...

my doubt is why 00000000 are getting convertd in unexpected 31.02.0002 date ? is there any specific reason for this

Regards

Abhay

Re: blank field getting converted into wrong date

prasanna_shanmugasundaram — Wed, 24 Mar 2010 14:25:43 GMT

Hi,

If you are using date transform in your mapping, It is always advisable to use ifthenelse.

Coming to your actual question, check this thread might be of some help

Thanks

Prasanna

Re: blank field getting converted into wrong date

stefan_grube — Wed, 24 Mar 2010 14:34:35 GMT

> my doubt is why 00000000 are getting convertd in unexpected 31.02.0002 date ? is there any specific reason for this

I have already answered this.

Re: blank field getting converted into wrong date

Former Member — Thu, 25 Mar 2010 07:10:25 GMT

Abhay,

This is default Java behavior (see also ).

If you want to treat "00000000" as a special case, please use some kind of if-then-else construction to catch this.

Regards,

Koen

Re: blank field getting converted into wrong date

abhay_aggarwal — Mon, 10 May 2010 09:30:28 GMT

Solved

Re: blank field getting converted into wrong date

prasanna_shanmugasundaram — Mon, 10 May 2010 09:34:35 GMT

Hi Abhay,

It will be very useful if you can give a gist of how u solved it!!

Thanks

Prasanna