How to use FM RSAX_BIW_GET_DATA for Delta Loads

[Former Member]

Hi All,

Can any one tell me how to use Function module RSAX_BIW_GET_DATA for delta load.

Once the delta laod is done, how can i do init load if my requirements demands me to do it?

waiting for ur answers,

Anusha V.

[former_member428385]

Hi Anusha,

when creating a generic data source in transaction RSO2, you can choose function module as method of extraction. Now there exist two types of function modules for generic extraction:

1) F2-type. An example of this type is given by the FM RSAX_BIW_GET_DATA_SIMPLE. For this type of extractor you have to implement the logic for full and delta extraction in the FM. Each time the extractor is called in delta mode, the correct delta has to be determined at runtime.

2) F1-type. The FM RSAX_BIW_GET_DATA is an example for this type. Here you have to implement only the logic for the initial full load in the FM. Delta loads are extracted from the delta queue, which is a generic SAP table. BUT: You have to take care of filling the delta queue with entries by calling function module WRITE_TO_QUEUE at the runtime of your application. Example: Assume you have a Z-table which is filled by an application. You want to extract all the deltas which are written by the application to the Z-table. Then the FM WRITE_TO_QUEUE has to be called whenever the Z-table is updated. This would write the record to delta queue. At a later point, you can trigger the delta extraction from BW and receive all deltas.

Unfortunately, SAP does not provide a standard way to set a generic data source to type F1. If you create a data source by transaction RSO2 with method FM, it will be created as F2-type. You can modify the corresponding entry in table ROOSOURCE and set it to F1, but afterwards you would not be able to modify the DS in transaction RSO2 anymore. Workaround: Copy the transaction RSO2 and enhance/modify the code, so that F1 and F2-types are possible.

Further information:

[How to Create Generic Data Sources which use the Delta Queue (NW7.0)|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/10b68b99-022e-2a10-999d-c4dc9ec24a59]

[Functional Module Based Generic Datasource Part I|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c062a3a8-f44c-2c10-ccb8-9b88fbdcb008]

[Delta Queue Demystification|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40427814-376a-2c10-5589-bc1aaa6692c3]

Best,

Chris