cancel
Showing results for 
Search instead for 
Did you mean: 

Generic Datasource with Fuction Module with delta on Created Date

Former Member
0 Kudos

Hi Experts,

I have created a generic datasource using Function Module RSAX_BIW_GET_DATA. I have copied this function module and created a my own Function Module. I want to load delta using this. But I don't know how to handle delta in the code.

my code is working for full load but not for delta. I have seen that in ROOSOURCE tabel the Delta field is showing the AIE instead of D and extraction method is showing as F2. I have searched a lot of forums and articles but didn't get how to handle this.

Please advice.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Amit,

I've just killed same problem you've described in your post. The only thing you should do is to change field EXMETHOD of table ROOSOURCE against your datasource from F2 to F1. And that's it.

I didn't find any standard tools how to do it that's why I did it as usua - very dirty way: I've created maintenance view for table ROOSOURCE in se11, generated maintenace framework in SE55 and changed this field from F2 to F1.

The only thing that you should note that your function module will always receive 'F' in parameter I_UPDMODE. Only difference is that you'll receive different selection options for field which is used for delta.

Full mode: no restrictions in generic delta field

Init delta mode: LOW - empty, HIGH - maximum possible value

Delta mode: LOW and HIGH according to previous delta and settings for generic delta.

You can easily test it in RSA3.

BR

Maxim

Former Member
0 Kudos

Hi Amit,

Go through the link as suggested by AKhan which lets you understand the concept of offsets and the last extraction status.

In case of Table or View based GDS, the system takes care of the deltas based on the selections you make in the "Generic Delta" screen whereas in case of FM based DS, it is your responsibility to handle this part. Within your code, capture if the load is a Delta load (I_UPDMODE = D). Since your delta is on Created Date, maintain a Z table with name of the DS as the Key and a field representing the current value of the Delta field(created date in this case). When you first load the delta, there will be no record for your DS in this table. Create an entry with the current day. Next time when you load a delta, take this value, compare it with sy-datum and get all the records falling within these days. This has to be done in the Select stmt. Once selection happens, replace the value in the Z table with sy-datum. This way you can simulate the delta. The Z table can be used for other FM based Datasources also as it has DS as the key.

It would be easy if the exact SAP table where RSA7 delta field status is stored is known. Otherwise, the above method can be used.

Revert for any further queries.

Former Member
0 Kudos

Hi Shrikanth,

Thanx! for the suggestion. I will check and will let you know.

Regards,

Amit Rajput

Former Member
0 Kudos

Hi,

Check the following links

these might help you

Regards,

MADhu.

Edited by: MadhuMarupudi on Sep 9, 2009 6:41 PM

Former Member
0 Kudos

HI,

Delta on created on Field sometimes create problem as changes in them wont reflect during which changed on field only get updates.If it is always a new document you can try created on date in delta.

Thanks,

Arun.

Former Member
0 Kudos

hi Amit,

In your Data Source Structure having a Create Date field right. So go to T-code RSO2 the type your Data Source Name

go to change mode ( Click for Extract via Function Module ) over there one Tab Button is there " Generaic Delta" there enter the require field name or you get the list of fields of that structure press F4 button . then Save is .

That field is act your detla purpose in the BI side.

Regards,

Souman

Former Member
0 Kudos
Former Member
0 Kudos

Hi Akhan,

Thanx! for the suggestion. I have seen this document before but this didn't include how to create data source with Function module. I want to create a data source with delta based on Funtion Module on Created ate field. I have crteated one data source on FM for full load using FM RSAX_BIW_GET_DATA_SIMPLE. It was working fine. I have seen in one article that for delat u have to use FM RSAX_BIW_GET_DATA so I am doing the same. but it's behaving like full load.

I have to check with Shrikanth's solution then will let you know.

Thanks,

Amit Rajput