Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
DilipShukla
Explorer

Introduction: We often get the requirement to copy dataset and make it easy for the business users to pre-populate it rather than creating the new data, one of the common examples is to copy data from one period to another or copy quarterly data, in absence of Copy function in PaPM we can use the Writer function to copy the data.

This blog will help you to understand and configure how to copy data from one quarter to another quarter dynamically using the process parameters and selection.

Configuration:

In this example we will copy ‘Equity Ownership’ data from quarter Q2 2023 to another quarter based on process selections and parameters, let’s move forward with the configuration approach.

Step 1: Model table ‘Equity Ownership Data’ with fields Company, Country, Quarter and Equity Ownership

DilipShukla_0-1706506574349.png

Step 2: We need to create a parameter which will be used in Process Parameter as to which quarter we want to copy data, add the Parameter and selection in Calculation unit as shown below.

DilipShukla_1-1706506722653.png

Step 3: Create Writer function ‘Copy Equity Ownership’ with Writer Type as 'Insert'

  1. Input - Equity Ownership Data (Model table)
  2. Signature

DilipShukla_2-1706506845119.png

3.Output – Pass on the parameter value ‘TO_QUARTER’ to filed ‘Quarter’ as below

DilipShukla_4-1706507087688.png

Step 4: Create a Process Template and executable Activity as per below details.

Process Steps and Activity with writer function ‘Copy Equity Ownership’

DilipShukla_7-1706508341861.png

DilipShukla_8-1706508372806.png

Step 5: Let’s copy Equity Ownership data from Quarter Q2 2023 (20232) to Quarter Q3 2023 (20233) by providing Process Parameter and Process Selection as below.

DilipShukla_9-1706508454881.png

Output: Equity Ownership Data has been copied from quarter Q2 2023 to Q3 2023

DilipShukla_10-1706508503614.png

Summary: Writer function can be utilized with Process Selections and Parameters to copy the data dynamically based on parameters value provided through process template and this facility can be rolled out to business users to copy the data as per the requirements.

If we have a requirement to copy a multiple dataset available in different Model tables , same approach can be used, instead of executing the writer function through process template, we can create join function and use the multiple writer function in union join as input and call the final join function in process template.

References:

Build Writer Function : https://help.sap.com/docs/SAP_PROFITABILITY_PERFORMANCE_MANAGEMENT/56471df1959f4cfd9e3bf7a6d2d5be42/...

Thanks,

Dilip Shukla

Labels in this area