cancel
Showing results for 
Search instead for 
Did you mean: 

SPM Extractors Starter Kit

Former Member
0 Kudos

Hi,

I am working with SPM extracting data from one of our R/3 systems (R/3 4.7). I installed the extractors in our system, copy the existing project delivered by SAP and then generated the extractors for those objects that we need. My question is regarding deltacapability. I read delta is available for some objects, based on their creation, posting or last change date. Nevertheless I cannot make any of them work in delta mode (even for those where there is a date available for delta extraction, for example Cost Centers, Invoices, POs.). I go to transaction Z_SA_EXTR, select project and object, and then click on Start. I immediately get the message 'Object file created successfully' (what is true, the file is there). But I am never asked whether I want to execute it in full, init or delta mode.

The SPM application will be installed in a standalone server (not in any of our existing BW systems), so I will be generating flat files to be FTP to the final destination. Is it that if I do not have a datasource for BW the delta mechanism is not available?.

Please clarify me on how this works. Many thanks!

Claudia.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Claudia

Is there a reason why you are going the flat file route?

Generally speaking if the ERP and SPM system are on premise then the recommendation is to use the datasource mechanism.

And yes, in both Flat files as well as data sources, initial + deltas are supported (as long as delta information is available in ERP).

Regards

Rajesh

Former Member
0 Kudos

Thanks for your response. The point is that SPM will not be installed in any of our BW systems. Should I use datasources anyway? I mean, can datasources be configured in the SPM system even when that will not be sitting on any of the BW systems?.

Then, could you please let me know how to run the extractor in init / delta mode?. Does it requires any special prior configuration?. Could you please give me an example of any of the objects that supports delta extraction and how the steps should be? I mean, how to make the Z_SA_EXTR transaction ask me which way I want to run the extraction?.

Many thanks again.

Regards.

Former Member
0 Kudos

Hi Claudia

Aah, now I understand.

Ok, so to clarify, SPM needs BW. Now it doesnt have to be in your standard BW environment, it could also be your central BW system or a stand alone, it doesnt matter both are fine.

And then you can use datasources to connect the SPM BW system to the source system.

Hope that clarifies.

~Rajesh

Former Member
0 Kudos

Hi, thanks!

Any clue why I cannot find the option to run extractors in delta mode?. How should the procedure be to init and run in delta mode? I execute transaction Z_SA_EXTR and cannot see anything refering to delta extraction (for none of the objects). Many thanks.

Former Member
0 Kudos

Hi Claudia,

SPM extractors do run in delta mode. SPM applications maintains the previous successful load data & time. When extracted again the previous recorded data & time and current date & time range is used to bring in the delta records. This date range is automatically passed to the info-package during extraction date filter to bring in delta extract. This is also the reason only one info-package has to be created against the SPM extractors in BW.

When executing these extractors in source system using RSA3 (extractor test) you can pass the date range to retrieve delta records for testing.

The very first time you run the extractors it will run in INIT mode, meaning bringing all the records from beginning of time till today and the next load will be from previous successful load till today in DELTA mode.

If you want to load multiple INIT loads, meaning break the INIT load into multiple pieces use the following steps:

- Specify a date range in the info-package on BW side to bring in one year worth of data (01/01/2009 to 12/31/2009)

- Make sure you delete the specific previous successful load date time stamp from the table OPM_SOURCE_ST which maintains the extractors status. This is the table that is used to figure out which was the previous successful load.

- Repeat the above 2 steps depending on the number of INIT loads you want to perform

- For the final load only specify the from date and leave the to date blank, this will bring in data up to the current date. After successful load the system will record the current data in the table and will be used for the next extract as delta.

Keep in mind that a factor of safety of 5 days is used during extraction to make sure all the records are extracted.

Hope this helps.

In regards to your previous question on package size, please read the article posted on this topic - /people/divyesh.jain/blog/2010/07/20/package-size-in-spend-performance-management-extraction

Regards,

Rohit

Former Member
0 Kudos

Hi Claudia,

Rohit is exactly right in his post above and he refers to the delta mechanism used when loading data thru BW data sources (majority of the cases). SPM data mgmt automatically manages it. SPM will extract all data initially and then all data since the last load after that.

In case your extraction mechanism is Flat Files, then you need to use Z_SA_OBJ_SCHE transaction of the extractor starter kit and set the extraction period in the Tab "Data Selection". This is documented in extractor config in the chapter Background Scheduling of extractors.

Hope that answers.

Regards

Rajesh

Answers (0)