In SAP Profitability and Performance Management(SAP PaPM), Writer function allows you to write data from Input function to the Output function type:
- ‘Model Table’
- ‘Model BW’
- ‘Model RDL’
Series 1 – Output function: ‘Model BW’ and ‘BW write type’: Loading
In this blog series we focus on ‘BW write type’ loading and it is split into 3 parts
Part 1: How to create writer function with ‘BW write type’ – Loading
Part 2: Overview of objects generated in the activation of writer
Part 3: Troubleshooting and known issues
One of the pre-requisites is that you have SAP Profitability and Performance Management SP09 or higher installed in your system. If you are in below SP09, some of the features discussed here may appear differently, so it is recommended to upgrade your system to the latest SP available.
Part 1: How to create simple writer function with ‘BW write type’ – Loading
In part 1, we discuss how to
- Create a simple writer function to write data from Model Table to ‘Model BW’ (ADSO)
- Define Formula in writer
- Apply selections on the input/output function
In this example, we create Model Table and write data to ‘Model BW’ with a simple writer function. As first step, maintain below fields in the ‘Environment fields’
Model Table (Input function)
Create Model Table with Source ‘Environment’
On activation, DDIC table with name Y- is generated. Select ‘Maintain data’ to enter/upload data to the table and select ‘Save’ to store these data in the table. For Masterdata Infoobjects, F4 help can be used to select the values.
‘Model BW’ (Output function)
We create ‘Model BW’ Function using fields
Source : Environment
Editable : Default (No)
From Model Table, include all the Chars and KFs and another keyfigure UNITPRICE. In the writer function, we define a formula to calculate this Keyfigure.
On activation, ADSO with technical name Y- is created in BW client.
Create a writer function to load the data from Model Table to ‘Model BW’. When output function is ADSO, system automatically offers different options and you can select
‘BW write type’ : Loading
‘Model writer type’ : Insert
When you activate the writer, the system generates all the necessary objects in background for writing data from Input function to ‘Model BW’ using DTP. When you Run, the process chain is triggered and data is written to the output ADSO.
When you can load data to ADSO successfully, configuration of your system with SAP BW client is proper.
View data in Model BW
- In the ‘Model BW’ -> Select ‘Analyze’ – the output displays the aggregated data
- For data Slicing & dicing, add/remove fields to the rows/columns
- Unit price has initial value ‘0.00’ as it is not populated due to no corresponding field in the Model Table
Define Formula in the Writer to calculate UNITPRICE
First, include the field in Signature tab -> Action -> add.
In the Output tab, add UNITPRICE and define formula as AMOUNT / QUANTITY
Activate the writer again to regenerate all the objects and run to calculate UNITPRICE
Apply selections on the input/output function:
Filter the PRODUCT with values PROD2, PROD3
- Select “+” sign and add PRODUCT from the list
- Select the filter icon, enter value PROD2
- Select “+” and enter another value PROD3 and select OK to save these values
These values appear under the column Selection
Activate the function to apply all these changes. When you run the writer function, the results are filtered on Product values PROD1 & PROD2 and UNITPRICE is calculated as per the formula.
As we reach end of the Part 1, now you can create simple writer function and load data to ‘Model BW’. When data is successfully written to ADSO shows that your system is configured correctly with the SAP BW client.
In the next part, we discuss the objects generated in the backend when activating the writer.
You can share your thoughts and feedback in the comments section. You can follow the tag ‘SAP Profitability & Performance Management’ and my profile to get new content notification.
For questions, you can post in the SAP Profitability and Performance Management – Q&A
Thanks for reading!
‘Model Table’: Model Table – Help documentation
‘Model BW’: Model BW – Help documentation
Writer(‘BW write type’ loading): Writer – Help documentation