topic Re: Doubt in function module relating to delta upload in Application Development and Automation Discussions

Doubt in function module relating to delta upload

Former Member — Mon, 26 May 2008 11:57:26 GMT

Hi,

Is there any ABAPer alive around who can tell me how i can write a funtion module to update data to BW side.

They only tell me data is not going to BW side. Can anyone throw light as to how function module should be structured. I have a function module that works very finely for full update mode in RSA3. What should be done in my function module for delta update mode to work on BW side?????

<h1> THIS IS CRITICAL </h1>

Regards,

Prakash.K

Re: Doubt in function module relating to delta upload

matt — Mon, 26 May 2008 12:06:50 GMT

Critical? Why? Should I respond faster because you've a problem that's urgent for you?

Does full extraction work when you run the extraction from BW? Extraction only stops when you return an empty package. Hence, RSA3 won't tell you if you've made this mistake. RSA3 will work fine, but the extraction will never end when run from BW. I refer you to this discussion I had earlier. [] I'll emphasise one important point: Also SAP supply RSAX_BIW_GET_DATA_SIMPLE as an example of how to write FM extractors

If your FM is actually working with full, then to get your function module to work as a delta load, you need to be able to determine which data records have changed with since the last extraction, and only send those. How you do this depends very much on the data. You'll also have to define the datasource as Generic.

matt

Re: Doubt in function module relating to delta upload

Sm1tje — Mon, 26 May 2008 12:14:24 GMT

so where are you calling this function module? Is it on the BW side or on the source side?

What does this FM do?

Is it called during a delta update?

Is the checkbox Delta Update marked in the datasource on the source side of the extraction?

A lot of questions, since it is not clear what the problem might be. Can be a lot of things, so before anyone can give an answer to this question, you will need to clarify your requirement first.

Re: Doubt in function module relating to delta upload

Former Member — Mon, 26 May 2008 12:22:33 GMT

Hi matt,

The BW team tried to do a delta init loading.They gave a selection screen of 1 to 10. It gave 6 records. They say its working fine.

But there is no data extracted in the AIE delta extraction mode. Is there anything that has to be done from ABAP side.

I am working in SD with tables VBAK, VBFA etc.

Should the order creation date or order change date be a part of the extraction structure.They say that these dates should be used to capture changes done to sales orders. Is it right?? Should i do a check in CDPOS table to see if changes are done in the VBAK table.

Please help me matt.

Regards,

Prakash.K

Re: Doubt in function module relating to delta upload

Former Member — Mon, 26 May 2008 14:02:14 GMT

Hi micky,

The requirement is that the sales documents have to be sent to BW side with a few more additional fields which are indicators saying if the order is delivered with scheduled time or not.

I am not sure if the function module is called during the delta update. In SM37, i see that during a full update mode extraction a different EXIT gets triggered(Something like EXIT_RSAP_001). But during a delta update mode i see that the error message says that some function module is missing & there is no indication that the above mentioned EXIT is trigerred. That function module i verified is an auto created one. something to update the BW side data or something like that.

Does that make the requirements clear?

Regards,

Prakash.K