Delta Generic datasource for FAGLFLEXA

[Former Member]

Has anybody been able to successfully create a delta datasource for FAGLFLEXA table. Trying to create it using RSO2 does work.

I will appreciate if anybody has done this successfuly and can provide a solution. I will provide points for a successful solution provided.

[Former Member]

I was able to create a datasource using an SAP Infoset.

1. Create an infoset for only table FAGLFLEXA (tcode SQ02) in source system. Make sure you check the box for 'no automatic text recognition' to avoid generating text fields. include all fields from the table.

2. Go to RSO2 and create a datasource using the infoset.. Save your datasource without generating the generic delta. Ignore warnings for currency fields and save. Your currency will still be extracted.

3. Go to your created data source in RSO2 and create Generic Delta. I used Timestamp field with 1800 for the upper limit setting. This should create a generic delta datasource.

Let me know if you have any questions. Good luck

[Former Member]

Hi... This happens when you want to create a datasource based on a table and the table has reference dependence on some fields for Currency/Quantity with other tables...in this case the FAGLFLEXA table has some references to other tables (i.e. FAGLFLEX00_CUR_UNIT_INC field RTCUR, T882G field CURR1, T882G field CURR2, T882G field CURR3 ) and with this references the table cant been extracted directly.

You must create another structure and load it through function module or try another table.

Regards

[Private_Member_9643]

What problem you are facing? Could you please elobrate it more.

[Former Member]

I was able to create a datasource using an SAP Infoset.

1. Create an infoset for only table FAGLFLEXA (tcode SQ02) in source system. Make sure you check the box for 'no automatic text recognition' to avoid generating text fields. include all fields from the table.

2. Go to RSO2 and create a datasource using the infoset.. Save your datasource without generating the generic delta. Ignore warnings for currency fields and save. Your currency will still be extracted.

3. Go to your created data source in RSO2 and create Generic Delta. I used Timestamp field with 1800 for the upper limit setting. This should create a generic delta datasource.

Let me know if you have any questions. Good luck