Getting Date and Time into a single field

[Former Member]

Hi,

I am loading from a flat file which has field Start time which comes in the format of MM/DD/YYYY HH:MM:SS ( Hour: Minute: Second). How can i bring this and store this in BW as one single field. Even in the source it is a single field.

I would also need to use this info object as a key in my ODS

Please advise,

Thanks

Rashmi.

Edited by: Rashmi Vellampalli on Oct 8, 2008 7:32 PM

[udayabhanupattabhiram_cha · Accepted solution]

>

> Hi,
> 
> I am loading from a flat file which has field Start time which comes in the format of MM/DD/YYYY  HH:MM:SS ( Hour: Minute: Second). How can i bring this and store this in BW as one single field. Even in the source it is a single field.
> I would also need to use this info object as a key in my ODS
> 
> Please advise,
> 
> Thanks
> 
> Rashmi.
> 
> Edited by: Rashmi Vellampalli on Oct 8, 2008 7:32 PM

You should user an infoObject/field for tyoe CHAR, length 24. Once you read this, in transfer rules, write an ABAP Code to seperate Data, time and AM, PM. Once you read all the characters from your source, its very simple ABAP to seperate them in Transfer Rules.

Uday-Ram Chamarthy

[Former Member]

data type: NUMC

length : 14

[Former Member]

The value will come with an AM or PM, will that work too if i have the data type as NUMC.

Thanks

Rashmi