topic Re: Manipulating fields in a view in Application Development and Automation Discussions

Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 19:43:47 GMT

I have a table with a date and a time and I really need that data in a datetimestamp format. I'm trying to avoid creating a custom table and a custom program to get this information that already exists in this table.

If I put the data in a view, is there any way to perform calculations on the fields and show that as another field in the view?

I've got a view partially set up, but I just don't see a way to manipulate the fields to that degree?

Or any other way to do this without creating a custom table with the right field type and a program that converts the data from one to the other?

Thanks for any help.

Re: Manipulating fields in a view

former_member194669 — Wed, 01 Aug 2007 20:02:27 GMT

May be try with creating table maintenance generator for the table and use EVENTS to write your code to manipluate the data and display in differnet column.

aRs

Message was edited by:

a®

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 20:44:15 GMT

How would I add the extra field to the view to hold the data? Is there a way to put a field in a view that doesn't come from a table?

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:06:11 GMT

Hi,

It is not possible to include an extra field to the view that is not a part of any table.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:08:03 GMT

How then can I implement the previous suggestion without adding a new field to the view?

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:11:07 GMT

Hi,

You can use edit mask statement to display the date and time which ever format you like.

Example:

Data time type t value '154633'.

write (8) time using edit mask '_:_:_'.

Output will be 14:46:33

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

Message was edited by:

Srinivasa Bhanuprasad Moningi

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:16:41 GMT

Within the view?

Let me restate my question, because I think we're all confused.

I am looking at the table PEVSH.

I need to use a few fields from this table, including the date and time, but I need that together in a timestamp format, not in two seperate date and time fields.

Is there a way to create a view of PEVSH that displays those two fields together into a timestamp field?

I'm not seeing how I can use a maintenace generator to do that if I don't have the field. The same with the edit mask, there's no field to put the edit mask on.

If I can't do it in a view, is there a way, if I create a custom table, to have lines inserted into it everytime PEVSH is updated?

I'm happy to award points for helpful answers, but please consider my total problem when answering. Thanks.

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:27:53 GMT

Hi,

I am not sure of what time stamp format you are looking for.

But for example, the below lines can be used in a sample program.

data time type t value '154633'.

write (8) time using edit mask '__:__:__'.

write sy-datum.

The output will be:

15:46:33 08/01/2007

So, depending on this you can change to the format you want.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:34:59 GMT

But I'm not trying to write the data out, I'm trying to store it in a table or view where it can be accessed by a BW extractor.

So I don't think using an edit mask is at all helpful?

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:38:35 GMT

Hi,

I think you have to create a custom table.

Else it is not possible.

Thanks,

Srinivasa

Re: Manipulating fields in a view

Former Member — Wed, 01 Aug 2007 21:40:26 GMT

Yes I'm back to thinking that as well, thanks for everyone who tried to help.