internal table

Since cdhrd is transparent and cdpos is pool table, I suppose I cannot cary out a join, then how do I get the following fields into an internal table record

chhrd-changenr

cdhrd-udate

cdhrd-utime

cdpos-fname

cdpos-value_new

cdpos_value_old

from cdhrd and cdpos for a given

object class

objact value

field name

Then I need to sord the records as follows

change doc no time date

01 5:30 19.05.2008

02 4:30 01.02.2008

03 2:00 01.10.2007

Then for the sorted records above I need to carry out the following

record no from_date from_time to_date to_time

01 19.05.2008 5:30 Today Now

02 01.02.2008 4:30 19.05.2008 5:30

03 01.10.2007 2:00 01.02.2008 4:30

04 .......................... 01.10.2007 2:00

It is like a series, where from_date in record 1 becomes to_date in record 2.