Help required for time Conversion

[#1]

Hi Folks,

Got stuck where my datasource is BODS based & am I getting a timestamp(CHAR30) fields, entries as shown below in PSA

Now in the DSO , I have field TIMESTAMP(refrence of 0TCTTIMSTMP) which is of TYPE NUMC14, But standard trasformation here failes to work as I an having data is target DS column as say 09.30 00:00:00( say for 1st records) & like wise.  though I can handle this puttinf some routine but I am not allowed to do any data modification atleast to 1st layer( Data propagation layer in LSA++) .

Can any one suggest, is there any way, I can handle this via standard transformation.

Also I am facing a strange issue wherein wherein Whereever I receiving any timestamp field from my ECC source its comversion to time stamp has added 2 extra hpurs to it, When I checked at the InfoObject level, I saw a TIMES conversion is applied which is actually creating a issue, screeshot below for reference

As you can see above the input is 30.09.2015 10:20:00 but when in BI it turns as 30.09.2015 12:20:00(added 2 hours extra), similarly lets say an other example

In above the input is 30.09.2015 23:00:00 but when in BI it turns as 01.10.2015 01:00:00(added 2 hours extra, since its already 23 hours in inputs & hence it chnages the next day in output),

Can anyone help on above 2 issues please,

Regards,

Fox

[Former Member]

Guys,

Please only consider the 1st part of above question wherein how can I handle the time timestamp from BDOS datasource which is coming as CHAR30 is handled in TIMESTAMP filed in BI which is NUMC14 using stnadard conversion.

I just checked the convesrion TIMES, actaully its picking sy-zonlo as 'CET' and added the ours to the input value.

Kindly suggest

Regards,

Fox