Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Getting Date and Time into a single field

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

replied

>

> 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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question