I need to develop a data source in R/3 based on a view (which is straight forward).
One field in the R/3 Z table will be in like this 20,070,709,110,000
There is a function module developed in R/3 when executed will split the record(20,070,709,110,000) and display time & date
How can i incorporate this function module in data source so that the data and time records will be loaded to BW
Enhance the data source with date and time and populate these fields in the user exit using the function module IB_CONVERT_FROM_TIMESTAMP .
You can create Z function module IB_CONVERT_FROM_TIMESTAMP in BW side and write a routine in update rules/transfer rules to populate date and time.
hope this helps ...