Each transfer structure rule semantically defines an if-then statement. Once you are done in the Signature tab, you can now set the rules for the Transfer Structure function. To Remove fields on Granularity, Action and Selection section
To Add fields on Granularity, Action and Selection section. For the Action section, the fields for Premium 1 and Premium 2 were added as it will be used for calculating formulas and assignments within the rules the function. These will simply pass through the function without any change or any effect on the logic.įigure 6: Transfer Structure Function Signature TabĪs seen on the Figure 6: Transfer Structure Function Signature Tab, the fields for Contact and Product are added on the Selection section as it will be used as a condition within the rules of this function. The Formula screen will pop up and you can now input the formulaĪfter defining the Input Function, you need to maintain the Signature to define the relevant fields to be used on the function. Select the field and click the f (Formula) button. If you wanted to set/apply a formula (if not, you can skip this step):. You can also use the “Function Select Open” button. On the Input Function field, click the dropdown list to view all the available Input Function. Table 2: Transfer Structure Function New Input Data after enrichment I also defined the formula ZE_AMT = ZE_AMT/2.5 which will compute the new Amount that will be used on this function. Table 1: Transfer Structure Function Input Data For this example, the Input data are the following: Contract You can also set specific selections to restrict the data transferred from the Input function.įor more information, you can refer to the Application Help > Input section Figure 5: Transfer Structure Function Input TabĪs seen on the Figure 5: Transfer Structure Function Input Tab, I configured the function TR – Pivot Table 1 as the Input Function. Then, the function can use the modified input data for further processing. On this tab, you can also define a formula that once the input function is read, it will apply the formula and the input data will be modified. Next, you can define the input function that is available in the same environment and use its data or result as the input data of Transfer Structure Function. Using this option, key figures are automatically aggregated using all input characteristics as grouping fields.įor further information about the Header fields, you may refer to this link on our Application Help > Header Section. The retain fields option will retain all the fields used on this function except the fields defined on the Rules Tab > Rule > Selection section and the source fields used on Action section.įor Aggregate Result, I selected Group Characteristics. In this example, I used the following Header fields that will affect the result to generate the desired simple transfer structure result.įigure 4: Transfer Structure Function Headerįor Transfer Structure Type field, you may set if the function you are creating is a Transfer Structure or a Reverse Transfer Structure.įor Retain Fields, I selected All Fields except Selection & Action->Source Fields. On edit mode, you may now proceed to the Header section to set the standard settings of the function. You may set it by clicking the Edit Button located on the upper right side of the Function screen.įigure 3: Transfer Structure Function Edit Button Please make sure that the function is in Edit mode. Let’s start configuring a Transfer Structure function. The image below is a sample logic for the unpivoting of dataįigure 2: Reverse Transfer Structure Function Type Logic While the Reverse transfer Structure type, which is the opposite of the Transfer Structure, wherein it transfers columns to values and sometimes also called “unpivoting of data”. The image below is a sample logic for the pivoting of data.įigure 1: Transfer Structure Function Type Logic The Transfer Structure type simply transfers values to columns which is sometimes also called “pivoting of data”. This function has 2 types: Transfer Structure and Reverse transfer Structure. The Transfer Structure function can transpose data according to predefined condition fields and settings. SMAART 7 TRANSFER FUNCTION HOW TO
Let me provide you a step by step procedure on how to set up a simple Transfer Structure Function on the SAP Profitability and Performance Management environment. If you want to explore and know more about how Transfer Structure Function is configured, this blog post is for you.
SAP Profitability and Performance Management Solution has many modeling functions which can be used to create financial and business models, and the Transfer Structure function is one of them.
0 kommentar(er)
