Flat Data Load in Spend Performance Management

[former_member190936]

Dear All,

We have a new Project, wherein Data from Various Flat Files (Flat Files from Multiple Non SAP Source Systems), needs to be loaded in SPM. We are new to SPM, any step by step documentation for loading Flat Files into SPM using Data Management Tool, will be really helpful.

Regards

Pankaj

[former_member257798 · Accepted solution]

Hi Pankaj,

These are the basic steps

1) Determine table and fields you going to load.

2) create file

3) upload file to folder

4) move through steps in user interface.

This topic is covered in the Master Guide section 3.1Data Management. You can download all of our docs here:

SAP BusinessObjects Spend Performance Management 3.0 – SAP Help Portal Page

These notes also have good details:

1796459 - Sequence for loading data in SPM

1891572 - SPM Data Model and Tables

1775340 - The key steps for loading supplier diversity file
1914255 - How to enable delta for SPM data load     

and of course these also for :

1239883 - Extractor Starter Kit for Spend Performance Management(SPM)

1679583 - Enhanced PO Extractor for Spend Performance Management

1358507 - SSA extractors: Contracts and Sch Agr Performance

* For more information about details of the delivery process
and environment, see Data Management in the see SAP Library for SAP Library for
SAP Spend Analytics.

* For more information about the data model, see the Analysis
Scenario SAP BusinessObjects Spend Performance Management – Data Model and Data
Flow in SAP NetWeaver BW in SAP Library

at

SAP BusinessObjects Spend Performance Management 3.0 – SAP Help Portal Page

Kind Regards,

John Harris

Senior Support Engineer, SAP Active Global Support,

SAP America, Inc., 1001 Summit Blvd, #2100, Atlanta, GA 30319, USA

[former_member190936 · Accepted solution]

Dear John,

Thanks for such a comprehensive and detailed Reply. This is really more than helpful.

Regards

Pankaj

[former_member190936 · Accepted solution]

Dear John,

Can you please answer this.

For Flat File Data Loads in SPM, does the Data get stored anywhere in any Data Source?

How and where can I view the Data, once I load a Flat File into SPM, before releasing and after releasing ?

I loaded the very first File on the sequence, Buyer, the file is not released yet. And went back to Buyer Data Source, under Flat File Source System, but I couldn't see data in the Buyer PSA.

Also after releasing, I couldn't see in the Buyer Attributes Object.

Can you help.

Regards

Pankaj

[former_member257798 · Accepted solution]

1891572 - SPM Data Model and Tables

Hi Pankaj,

The above note has the table names.

Kind Regards,

John

[former_member190936 · Accepted solution]

Thanks John, for the help

Regards

Pankaj