on 09-05-2009 1:48 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check if the below link helps you.
Regards,
Akhan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.