Copying the 0Fi_GL_12 Extractor

[Former Member]

Hello Gurus,

We have a requirement to make copy of the 0FI_GL_12 extractor. So we tried to copy the extractor by creating custom extractor YFI_GL_12_FR in RSO2, with the same extract structure FAGL_EXTSTRUCT_LEAD. We used a custom program to update ROOSOURCE table value to enable delta queue based delta for the extractor.

We have copied the Function group of the FM FAGL_GET_TT_DATA_LEAD and updated the FM ZFAGL_GET_TT_DATA_LEAD in the custom extractor but while executing the Extractor in RSA3 transaction, we are getting error occured during extraction error.

Please help in understanding the ways of copying a standard function module for our custom extraction.

Let me know for any clarifications.

Thanks and Regards,

Raghu

[former_member185132]

Normally people do not copy a standard DataSource, because there is very little need to do so. Why do you need to copy the standard DS, why not just use the standard DS itself?

[Former Member]

Hi Suhas,

I need to slpit this extractor based on country to reduce the data load failure because of huge volume during my cutoff days. Initially we tried to have multiple inits for different countries but during my delta
load, all the inits are clubbed as one in my delta selection.

Basically to achieve this, we want to copy the datasource.

Regards,

Raghu

[former_member185132]

In that case, you could go to RSA6 and enable selection for the country/company code field. That would control data volume for the init.

For controlling delta volume, try running the InfoPackage multiple times per day. That will keep the amount of data small in each InfoPackage request. How much data are you getting per day anyway?

Copying the DataSource is not a good idea: you are taking the risk of unpredictable errors that SAP may not support. Also, if they release any fixes/changes for the DataSource, the copied DataSource cannot take advantage of them.

[Former Member]

The requirement is not to restrict the data based on country/company code, but to split the data based on country/ company code.

We analyzed these before coming into the conclusion of copying the datasource, because of the data volume ECC system is having performance problems during our period end. We understand the risks involved in this but let us know if there is any alternative. It would be really helpful.

Regards,

Raghu

[former_member185132]

Splitting the data based on country/company code is the same as running multiple InfoPackages, each with a different country/cc restriction

Anyway, if you want to copy the DataSource are prepared to accept the risks involved, what error are you facing?

[Former Member]

Hi Suhas,

I am  getting "Errors occurred during the extraction" ""Message no. RJ012" error message.

Regards,

Raghu

[former_member185132]

That's not sufficient info to understand the problem. There is a log button available in RSA3, see what is available there please. Otherwise try to call the DS using an InfoPackage, then check the job log in R/3 for the BIREQ* job that gets generated.