Question Re: Function Module Extractor with Delta in Technology Q&A

Function Module Extractor with Delta

Former Member — Fri, 24 Aug 2007 21:58:38 GMT

I'm very new to working with the BW, so I hope I'm explaining my question in a way that makes sense.

I need to make a BW extractor that pulls data from at least one table, possibly more, and which also calculates some data.

I think the only way I can do that is by using an extractor with a function module.

I've been looking at the examples in function group RSAX, and I think I sort of get it, except for one part.

I'm really confused about how the delta works.

I'm looking at the example: RSAX_BIW_GET_DATA_SIMPLE

Does it even use a delta?

I'm trying to understand how the delta gets passed, and how it gets used to filter the data in the function module. I'm not sure if it's something I need to code in myself, or if it's something that BW does by itself, or what.

I'm not sure if I'm making sense, but if anyone could help me, I'd appreciate it.

Re: Function Module Extractor with Delta

Former Member — Fri, 24 Aug 2007 22:02:51 GMT

1. When you create your data source in RSO2, there is a push button "delta" press that and you will see the settings that you can make for delta.

2. If you pull just one table, then you can try doing the data manipulations on BW side, which is not hard compared to writing a FM in R/3.

Ravi Thothadri

Re: Function Module Extractor with Delta

Former Member — Fri, 24 Aug 2007 23:24:18 GMT

for dealing with delta in your extractor you will need a field that is relevant for delta something like a date or a timestamp for instance let say you know you have the field aedat for modification date so include it in your structure you build for the extractor and afterwards follow Ravis' post point 1 when you create the datasource in rso2.

I would recommend you before chosing a field for delta to discuss and ask a functional consultant to see which field make sense in changes of transaction data you want to pull from source system.

hope this could help you

regards

Boujema

Re: Function Module Extractor with Delta

Former Member — Mon, 27 Aug 2007 11:29:57 GMT

I'm not actually on the BW team, so I'm not doing anything on that side. I think they are even creating the stuff in RSO2, the BW guys are doing that part, I believe.

What I'm unsure about is, once they've made their delta settings in RSO2, how do I use that in my function module? Is it something that happens automatically? Or do I have to pre-filter the data by the timestamp for the delta before I populate the structure?

Re: Function Module Extractor with Delta

Former Member — Mon, 27 Aug 2007 13:38:40 GMT

Hi,

the delta information is passed to the fm in internal table i_t_select. You need to grap the delta information (mostly a timestamp or a date) to goto the database and make a select on creation and/or change date based on that information. Take care about deletions.

Here some more help: /people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

kind regards

Siggi

Re: Function Module Extractor with Delta

Former Member — Mon, 27 Aug 2007 14:49:13 GMT

Thanks guys, you've been super helpful so far, so I'm just going to keep asking questions. I promise to award points at the end

I'm looking at it now, and I think if I change it to read from a table, instead of read from a function module I can use the 'numeric pointer' option for the delta. (Does that just mean a number? For example, payroll runid is a number, so I could use that and only get new payroll runs?)

However, there still are some calculated fields they want. Someone mentioned doing that on the BW side. How would that work?

Sorry for such vague questions, but any help is really appreciated.

Re: Function Module Extractor with Delta

Former Member — Mon, 27 Aug 2007 18:19:33 GMT

Hi Vanda,

The FM RSAX_BIW_GET_DATA_SIMPLE does not handle delta. If you want a FM that handles delta, take a look at the FM RSVD_BW_GET_DELTA_DATA. We had copied and modified the copied FM to handle the delta capabilities. Hope this helps.

Thanks and Regards

Subray Hegde

Re: Function Module Extractor with Delta

Former Member — Mon, 08 Oct 2007 21:53:19 GMT

Hi Subray,

I was working on the FM RSAX_BIW_GET_DATA_SIMPLE but could not get Delta. But now I am using the FM you suggested but when I test the datasource in RSA3, It is giving error. Can you please send me your template? I would appreciate your time and help. I will award you with points as well.

Regards,

Hanuma