Spend Performance Management Extractors and Data Model.
This KBA is a compilation of useful pieces of information regarding SPM extractors and the Data Model.
Some of the terms used in SAP Spend Performance Management Extractors:
Table & Table relationship
The first place to check for information about SPM Extractors will be Note 1239883 - Extractor Starter Kit for Spend Performance Management(SPM). The extractor starter kit is available to all customers to guide them in installing, configuring and running the SPM extractors. The extractors provide a template to help the customers transport metadata from one system to other (Dev - QA - Production). All the generated objects like programs, structures, Function Modules and Data Sources need to be generated separately in each of the target system based on the transported metadata using the transactions provided.
Transaction Z_SA_DEPD will show SAP delivered projects ERP and ERPC in case of releases 4.7 onwards.
ERPC project is only relevant when data enrichment services are not used. Copy the project ERP to a new name. This is done in order to separate SAP delivered code from any customer modification. All further actions should be done on the copied project. This is the recommended best practice.
List of SPM Extractors provided within the Starter Kit:
|Budgets||Costs Budget Data|
|Buyingorg||Buying Organisation (Purch. Org)|
|Category||Obsolete : will be deleted|
|GLAccount||General Ledger Account|
|IVBSAK||Invoices cleared items|
|IVBSIK||Invoices non-cleared items|
|LCategory||Category Material Group|
|LSupplier||Supplier Vendor Master|
|Product||Product Material Master|
|Sline||Delivery Schedule Line|
|StdPrice||Standard Price of Product|
|Supplier||Obsolete : will be deleted|
|TCurf||Currency Conversion Factors|
|TCurv||Exchange Rate Types|
|UOM||Units of Measurements|
Run transaction z_sa_extr to select and run the extractor for a chosen object. The extracted data file will be available in the directory that is configured
Table ZSA_FFCUSTTABL contains following fields:
Project –Project for which this setting is valid. Can use * if the setting should be used for all projects.
Object -Object for which this setting is valid. Can use * if the setting should be used for all Objects.
File Path –The directory path where the files will be stored
File Name –Name of the generated file. Leave it blank if * was used for Project or Object
Transaction AL11 can be used to browse the directory where the extracted files are placed (specified in Global settings).
Table ZSA_D_FLDVAL = Exclusion table : This table is used to exclude certain records from extraction based on certain values for any of the extracted fields. Execute transaction SM30 and view ZSA_D_FLDVAL.
Table ZSA_GLSPLIT - Spend amount can be distributed to different groups like Tax, Freight and Special Charges based on GL accounts which belongs to these groups. Execute transaction SM30 and view ZSA_GLSPLIT.
jmhiv, epm-sa, spm, spend performance management, order to load data, data loading order, data flow, dataflow, EPM, SAP SA, SAP SPEND PERFORMANCE MGMT, SAP Spend Performance Management, SAP Spend Analytics, SPM, EPM-SA, SAP BOBJ SPEND PERF MGMT, jmhiv2016e, SAP BusinessObjects Spend Performance Management , KBA , EPM-SA , Spend Analytics , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.