Skip to Content
Author's profile photo Former Member

FAQ: Extracting Data for Spend Performance Management

Over time I realized that I was responding to the same questions and queries on the Spend extractor starter kit. 

Questions like:
* What source systems does the extractor starter kit support?
* What are the different options for transferring data from source systems?
* Where can I download this starter kit?
* Where can I find additional documentation?
… 

So I collated the most commonly asked and posted their answers at the following wiki location:
http://wiki.sdn.sap.com/wiki/display/CPM/FAQ+-+Data+Extraction+for+Spend+Performance+Managementhttp://wiki.sdn.sap.com/wiki/display/stage/FAQ+-+Data+Extraction+for+Spend+Performance+Management

I will refresh the wiki with additional questions and answers as we go along.

Your suggestions/comments/questions are welcome.

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Francisco Milán Campos
      Francisco Milán Campos
      Hi Rajesh:

         I'm afraid that the Wiki URL is not working.

      Regards,

      Francisco Milán.

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Milan,

      Thx for pointing it out!

      I have fixed it.

      ~Rajesh

      Author's profile photo Former Member
      Former Member
      Hi Rajesh,

      Nice wiki, but I have a question about your answer at question: If I want to write my own extractors, how do I know which fields to extract and map?

      In your answer is a link to two spreadsheets, but when I follow that link I do not find that spreadsheets. Do you know if these have been moved? I have found two spreadsheets in the Spend Analytics 2.0 folder, are that spreadsheets the same for SPM?

      https://websmp109.sap-ag.de/~form/sapnet?_FRAME=OBJECT&_HIER_KEY=501100035870000015092&_HIER_KEY=601100035870000218625&_HIER_KEY=601100035870000214942&_HIER_KEY=601100035870000221084&_HIER_KEY=701100035871000536912&#HOME

      Best regards,
      EJ Koersen

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Hi EJ

      The mapping documents are in the same place, you need to click the link at the top right of the frame, in order to be able to see them.

      Here are more details on the documentation:
      SPM Documentation

      Regards
      Rajesh

      Author's profile photo Former Member
      Former Member

      Hi Rajesh,

      The links seems not working. Could you please provide the correct links?

      I have gone through most of the white papers written by you. They are wonderful. I am looking for a document which explains SPM standard extractors and the detailed procedure/steps to take data from SAP ECC/SRM to SPM cubes.

      Please share your thoughts.

      Best Regards

      Gowtham

      Author's profile photo Former Member
      Former Member

      Hello Rajesh,

      I have tried to check your blog - but this wiki location is not working "

      http://wiki.sdn.sap.com/wiki/display/CPM/FAQ+-+Data+Extraction+for+Spend+Performance+Managementhttp://wiki.sdn.sap.com/wiki/display/stage/FAQ+-+Data+Extraction+for+Spend+Performance+Management"

      I have started implementing this extract structures in ECC, and setup the ZSA_FFCUSTTABL table entries like \\SERVER1\Interface\SAP\SPM_Analytics\ for the project and all objects. Copied the delivered project.

      When I tried to run Z_SA_EXTR transaction for a test dates for PO, it gives that Flat file creation was successful, but nowhere could it be found!!! not sure how to fix the issue? Your help greatly appreciated.

      Thanks

      Srini