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.