Function Module based Generic DataSource

[Former Member]

Hi Experts,

We have a DataSource based on Function Module. It fetches data from a Z table which has contracts data.

For data consistency, a loop has been added in the Function Module code, which fetches all the data related to a particular Contract.

The FETCH & OPEN CURSOR restricts the no of Contracts to 1, but the above loop multiplies and E_T_DATA is filled with Half a million records for the contract. So 500000 records get added to one data package.

The infopackage fails to update such a huge data package to BW.

Is there a way, in which I can split the E_T_DATA, that has 500000 records, and move only 50000 records at a time.

I have no option but to continue with the above LOOP to maintain data consistency.

Kindly suggest,

Nageswara

[Former Member]

Thanks Sujit & Sourabh.

These settings did not work .

That is because the FM gets all the relevant data(all records) for one Contract number to maintain the data consistency.

After E_T_DATA is filled with all the records, can we split this internal table into multiple packages?

Thanks & Regards,

Nageswara

[Former Member]

Hi Nageswara,

Definitely you need to handle it through your code then. The only way I see is to handle it using cursor. But you mentioned above that your cursor is designed to handle only one contract at a time. Can you explain what multiplies and give E-T_data so much of data. I guess you are talking about CRM Contract.

Regards,

Sujit.

[former_member182516]

Hi Nageswar,

Fine tune your FM code .... Please post your Code so that we can get idea if there are any points missed out while implementing the Code.

For your refer please check the FM code in below links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

This explains the steps in FM

http://scn.sap.com/people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

Code for FM

http://wiki.sdn.sap.com/wiki/display/BI/Code+for+generic+extraction+using+function+module

Regards

KP

[former_member1308742]

Hi,

Use transactiom RSCUSTV6 in R/3 system and change the data package size.

Thnaks,

Sourabh

[Former Member]

Hi Nageswara,

Log on to your source system,

SBIW

Data Transfer to the SAP Business Information Warehouse

General Settings

Maintain Control Parameters for Data Transfer

In this screen you can define such parameters.

You can logon to your BW system to see the settings.

Open the InfoPackage

On top left hand side - "Scheduler"

Datasource Default Data Transfer

In this screen you will be able to see the details.

Regards,

Sujit.