SAP Cost and Revenue Allocation for Financial Products offers various functions to incorporate data from surrounding systems and to define a harmonized comprehensive data model. In general, these functions can be divided into:
Read integration
Write integration
Harmonization and logical grouping
The following functions exist to incorporate data models for read access:
Model Views
Model Views are used if permanent network read access to the data of surrounding systems is possible. This is typically the case for all SAP systems, such as ERP including ECC and sFin, BPC, Bank Analyzer, Insurance Analyzer, BW. This includes indirect access via SAP Landscape Transformation Replication Server (SLT Server). Model views do not replicate data themselves, rather they provide permanent access to the source data, so that this data can be used in allocation models.
Model PM
Model PM is used if no permanent network read access to the data of surrounding systems is possible, or if the data is entered manually. This is typically the case for excel files with changing file names and in general for everything sent around via e-mail, for ad-hoc changeable parameters, or model assumptions. Model PM’ is a data store and thus replicates data to provide permanent, high-speed access to the data, which enables the data to be used in calculation models. As outlined above, Model PM tables are temporary data stores. Therefore, neither lifecycle management nor granular authorizations are supported. If you need permanent data stores, then BW InfoCubes or SDL / RDL data stores must be used instead.
The following functions exist to incorporate data models with the applications on top for write access:
Bank Analyzer / Insurance Analyzer RDL Write Adapter
The RDL Write Adapter is used to store calculation results in a traceable and auditable data store of the Results Data Layer, which does not allow the deletion of data. Instead, a versioning of results exists. It is typically used to store (interim)-results, which need to be communicated externally to shareholders or supervisors.
FI/ CO Write Adapter
The FI / CO Write Adapter is used to create aggregated, delta accounting documents based on calculation results and post them into SAP FI / CO. It is typically used to reconcile and update Profit & Loss sheets with new calculation results.
BW InfoCube Write Adapter
The BW InfoCube Write Adapter is used to store calculation results in a data store, which does not allow the deletion of data, rather only updates. It is typically used to store planning results, which are needed in further planning processes based on BW and/or BPC.
In reality, data from different sources needs to be harmonized and logically grouped so that it can be used easily and efficiently in model calculations. SAP FS-PER supports such transformations using two further functions:
Views
Views are used to project or aggregate data including necessary selections by filters, calculations by formulas, and field mappings. They are typically placed “on top” of sample read functions to transform the data into the needed format and granularity.
Joins
Joins are used to merge data from different sources based on foreign key relationships. They are typically placed “on top” of views or sample read functions to group data logically together.
Example
Sample content for read integration is provided with the solution for the following data models:
SAP FI Direct Costs
SAP CO-OM-CCA Indirect Costs
SAP PS Project System for Cost Drivers
SAP CO-PA for high-level profitability analysis
SAP BA/IA SDL Business Transactions and Master Data
SAP BA/IA RDL projection and actuarial cash flows and patterns
The sample integration business content of SAP FS-PER is preconfigured for the following data model write integrations:
SAP BA/IA Actual Allocation Results
SAP FI Reconciliation Postings
SAP BPC/BW Planning Allocation Results
Sample content for harmonization and logical groupings is provided with the solution for the following data models:
SAP BA/IA harmonization of SDL Business Transactions
SAP BA/IA aggregation of SDL Business Transactions to positions
SAP BA/IA logical grouping of SDL Master Data for Financial Assets and Liability basis data, characteristics, and key figures
SAP FI / CO harmonization of postings
SAP FI / CO aggregation of postings to positions
SAP BW/BPC harmonization of planning positions