{"id":1291,"date":"2018-03-18T16:51:10","date_gmt":"2018-03-18T14:51:10","guid":{"rendered":"http:\/\/www.esfoor.fi\/en\/?p=1291"},"modified":"2021-10-08T11:13:00","modified_gmt":"2021-10-08T09:13:00","slug":"report-painter-beginners-guide","status":"publish","type":"post","link":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/","title":{"rendered":"Report Painter – Beginners Guide"},"content":{"rendered":"

Report Painter is an easy and effective tool for SAP ERP reporting. This is Report Painter tutorial for beginners. Screen by screen you will learn\u00a0 how to use this tool. When you\u00a0master the basics, you’re ready to start with your own reports.\u00a0 Avoid\u00a0reinventing the wheel, use the existing standard reports as models.<\/p>\n

1 Report Painter in SAP menu<\/a>
\n2 Creating your first report<\/a>
\n2.1 Report Design<\/a>
\n2.2 Create report (GRR1) <\/a>
\n2.3 Main elements of a Report Painter Report<\/a>
\n2.4 Row definition<\/a>
\n2.4.1 Lead Column<\/a>
\n2.4.2 Row 1 \u2013 Cost Elements <\/a>
\n2.4.2.1 Cost Element interval<\/a>
\n2.4.2.2 Set<\/a>
\n2.4.2.3 Variable<\/a>
\n2.4.2.4 Set Variable <\/a>
\n2.5 Column Definition<\/a>
\n2.5.1 Key figure with characteristics<\/a>
\n2.5.2 Predefined key figure \u2013 Actual costs<\/a>
\n2.5.3 Predefined key figure \u2013 Plan costs<\/a>
\n2.5.4 Formula<\/a>
\n2.6 General Data Selection<\/a>
\n2.7 Save and execute<\/a>
\n2.7.1 Report Group<\/a>
\n2.7.2 Errors?<\/a>
\n2.7.3 New trial<\/a>
\n2.8 Add Cost Centers to the report<\/a>
\n2.8.1 Cost Centers in Rows<\/a>
\n2.8.2 Cost Centers in Columns<\/a>
\n2.8.3 Cost Center in General Data Selection<\/a>
\n2.8.4 Variation <\/a>
\n2.9 Column Heading Texts<\/a>
\n2.10 Fiscal Year and Periods<\/a>
\n2.11 Add and delete columns<\/a>
\n2.11.1 Delete a Column<\/a>
\n2.11.2 Insert a Column<\/a>
\n2.12 Report title<\/a>
\n2.13 Report \/ report interface<\/a>
\n2.13.1 Drilldown to line item reports<\/a>
\n2.15 Report Layout<\/a>
\n2.15.1 Format Group<\/a>
\n2.15.2 Report Layout<\/a>
\n2.16 Sections<\/a>
\n2.15.1 Create New section<\/a>
\n2.16.1.1 Section with characteristics and key fig<\/a>
\n2.15.1.2 Section with calculated key figures<\/a>
\n3 Main elements of Report Painter<\/a>
\n3.1 Library 1VK and Report Table CCSS <\/a>
\n3.1.1 Characteristics<\/a>
\n3.1.2 Basic Key Figures<\/a>
\n3.1.3 Key figures (predefined key figures) <\/a>
\n3.2 Create your own library<\/a>
\n3.3 Report Group YREP<\/a>
\n3.4 Sets and Variables<\/a><\/p>\n

 <\/p>\n

<\/a>1\u00a0\u00a0\u00a0\u00a0 Report Painter in SAP menu<\/h3>\n

You find the Report Painter report from SAP Menu under:\u00a0 Information Systems \/ Ad hoc Reports\/ Report Painter \/ Report<\/em><\/p>\n

\"Report<\/p>\n

Or under Controlling \/ Cost Center Accounting (or Profit Center Accounting) \/ Information Systems \/Tools \/ Report Painter \/ Report<\/em><\/p>\n

\"Report<\/a><\/p>\n

Library, Report Group and other important elements of Report Painter are under Report Writer menu.<\/p>\n

\"SAP<\/p>\n

In which system or client you should do your exercise? If your Company has Sandbox client, use it. Otherwise use the test system.<\/p>\n

<\/a>2\u00a0\u00a0\u00a0\u00a0 Creating your first report<\/h3>\n

<\/a>2.1\u00a0 Report Design<\/h3>\n

Before jumping into Report Painter, spend a while planning your report.<\/p>\n

We want to create a simple actual vs. plan cost accounting report.<\/p>\n

\"Cost<\/p>\n

<\/a>2.2\u00a0 Create report (GRR1)<\/h3>\n

Start the Report Painter and select from menu Create Report (or use transaction GRR1).<\/p>\n

First you need to enter a library. Use the search help (F4) and open the library view.<\/p>\n

\"Create<\/p>\n

Take a closer look at the available libraries. Libraries beginning with a number are SAP standard libraries. You find libraries that contain cost accounting reports (cost centers, orders, projects, product costing), Financial Accounting reports and Logististic information system (LIS) etc.<\/p>\n

\"Find<\/p>\n

A reporting table is always assigned to the library. This table contains characteristics and key figures that you can use in reports. Examples of characeristis are cost elements, cost centers, periods etc. Key figures are numerical value fields, such as Actual Costs or quantities.<\/p>\n

Most SAP standard cost center reports are in library 1VK. Reporting table of 1VK is CCSS.<\/p>\n

You can use an existing library or create your own library. Let\u2019s use the library 1VK for our new report.<\/p>\n

Give your report an id and description. The name must not start with a number or special character. Start the report name with Z or Y.<\/p>\n

You can also copy the definitions from an existing report.<\/p>\n

\"Create<\/p>\n

Press CREATE.<\/p>\n

<\/a>2.3\u00a0 Main elements of a Report Painter Report<\/h3>\n

The main elements of every Report Painter report are Rows, Columns and General Data.<\/p>\n

\"Main<\/p>\n

Press CREATE.<\/p>\n

Creating a report begins from an empty report with four rows and columns. You are going to use this report structure as a basis for your own report. It displays the report rows and columns as they will appear in the final report.<\/p>\n

\"Report<\/p>\n

<\/a>2.4\u00a0 Row definition<\/h3>\n

<\/a>2.4.1\u00a0\u00a0\u00a0\u00a0 Lead Column<\/h4>\n

Double-click on the \u2018Lead Column\u2019 (1) and replace the text\u00a0 with ‘Cost Elements’<\/p>\n

\"Lead<\/p>\n

Confirm with enter or green check mark.<\/p>\n

<\/a>2.4.2 Row 1 \u2013 Cost Elements<\/h4>\n

The title of the lead column is now Cost Elements.<\/p>\n

\"Lead<\/p>\n

Double-click on Row 1.\u00a0The Element Definition box opens.<\/p>\n

\"Report<\/p>\n

Select Cost Element from the ‘Available characteristics’ and move it to the left.<\/p>\n

\"Report<\/p>\n

\"Report<\/p>\n

If you try to confirm the selection, you get\u00a0a message: \u201cEnter a set, a single value or an interval\u201d.<\/p>\n

\"Confirm\"<\/p>\n

You need to define the cost element values and how they are presented in the report.<\/p>\n

There are a couple of options how to do that.<\/p>\n

<\/a>2.4.2.1 Cost Element interval<\/h4>\n

You can use the actual cost element numbers (single or interval).<\/p>\n

\"Row:<\/p>\n

In case you wish to enter several individual values or intervals, press ‘More’ to insert multiple lines. To compress the inserted lines press the ‘More’ with green arrow on the first line.<\/p>\n

\"Row:<\/p>\n

Scroll to the end of the line. There you can choose how the values are presented in the report. You can choose between No explode<\/strong>, Explode<\/strong> and Single values<\/strong>. In the standard system, the No explode indicator is set as the default.<\/p>\n

\"Row:<\/p>\n

No explode<\/strong>: the values of an interval are summarized to one row.<\/p>\n

\"Row:<\/p>\n

Explode<\/strong>: the values are singled out and totaled<\/p>\n

\"Row:<\/p>\n

Single values<\/strong>: cost elements are shown separate with no\u00a0 grand total.<\/p>\n

\"Row:<\/p>\n

<\/a>2.4.2.2 Set<\/h4>\n

Instead of the actual cost elemement values you can use a set.\u00a0A set is a collection of cost elements. For example, all Cost Element Groups are sets.<\/p>\n

\"Row:<\/p>\n

\"Row:<\/p>\n

Check the ‘Set’ and write the cost cost element group in From. If you don\u2019t know any cost element groups, you can search for them with \"Row: (F4)<\/p>\n

In the ‘Selection of set’ box, click on the small triangle.<\/p>\n

\"Selection<\/p>\n

Choose Set Class \u2018Cost Elem Grpr\u2019 and enter the name of your Chart of Accounts under Organizational Unit.<\/p>\n

\"Selection<\/p>\n

Confirm your choices.<\/p>\n

Select the Cost Element Group you want to use in your report. In this example group OAS is chosen.<\/p>\n

\"Sets:<\/p>\n

Scroll to end of the line. Choose between No explode<\/strong>, Explode<\/strong> and Single values<\/strong>.<\/p>\n

\"Row:<\/p>\n

No explode<\/strong>: all the values are totaled to one line.<\/p>\n

\"Row:<\/p>\n

Explode<\/strong>: the report displays single values, subtotals, and a grand total. The cost element group is exploded and subtotals are calculated based on the hierarchical structure.<\/p>\n

\"Row:<\/p>\n

\"Row:<\/p>\n

Single Values<\/strong>: the levels of the cost element group are not displayed; only individual cost elements are shown. No grand total.<\/p>\n

\"Row:<\/p>\n

<\/a>2.4.2.3 Variable<\/h4>\n

Next alternative is to use Variables. You can only use variables that are defined in the reporting table of the library.<\/p>\n

\"Row:<\/p>\n

Reporting table CCSS (the table of our library 1VK) has no variables defined, why this choice is not possible.<\/p>\n

\"Row:<\/p>\n

Look for available variables with (F4). Sort By Tables.<\/p>\n

<\/a>2.4.2.4 Set Variable<\/h4>\n

You could not use variables, but you can use something called ‘Set variables’.\u00a0When you check both the Set and Variable, you indicate that you want to use a Set variable.<\/p>\n

\"Row:<\/p>\n

There are several ‘Set variables’in table CCSS.<\/p>\n

\"Row:<\/p>\n

Display variable (transaction GS13).<\/p>\n

Set variable 1KSTAR contains all cost elements of the Controlling Area.<\/p>\n

\"Row:<\/p>\n

Scroll to end of the line. Choose between No explode<\/strong>, Explode<\/strong> and Single values<\/strong>.<\/p>\n

\"Row<\/p>\n

No explode<\/strong>: totals the values to one row.<\/p>\n

\"Row<\/p>\n

You might wonder why the total value of Actual costs is not the same as above, when we used the cost element group OAS? The explanation is that cost element group OAS does not contain all the cost elements of the Controlling Area, while 1KSTAR does.<\/p>\n

Explode<\/strong>: 1KSTAR explodes only to one level. The report contains all cost elements and a grand total.<\/p>\n

\"CE<\/p>\n

You can replace 1KSTAR with a Cost Element Group in the report selection. In that case, it will be opened.<\/p>\n

\"Row:<\/p>\n

Single values<\/strong>: cost elements are singled out. No grand total.<\/p>\n

\"Row<\/p>\n

Set variables enable the use of groups, sub-groups and value(s) in the report start. Variable 1KSTAR adds the selection group Cost Element Group or value(s). 1KSTAR has only one level, but you can replace it with any Cost Element group.<\/p>\n

\"Selection<\/p>\n

In our report we will use the Set variable 1KSTAR for cost elements.<\/p>\n

\"CE<\/p>\n

Click on the pen and maintain the default row text.<\/p>\n

\"Maintain<\/p>\n

Enter the text: Total Costs.<\/p>\n

\"Row<\/p>\n

Confirm the entry.<\/p>\n

\"Confirm\"<\/p>\n

Now you can see the text \u2018Total Costs\u2019 and a * before it. It means that, the row contains a one-level group or set.<\/p>\n

\"Total<\/p>\n

You cannot save the report before at least one column is defined.<\/p>\n

\"Error:<\/p>\n

<\/a>2.5 Column Definition<\/h4>\n

Columns contain a combination of characteristics and basic key figures. You can also use predefined key figures, which contain ready to use combinations defined by SAP.<\/p>\n

Double-click on Column 1.<\/p>\n

A box with two choices opens.<\/p>\n

Let\u2019s take a closer look at both of them.<\/p>\n

<\/a>2.5.1 Key figure with characteristics<\/h4>\n

Select first ‘Key figure with characteristics’ and press enter.<\/p>\n

\"Columns:<\/p>\n

Empty Element definition opens. If you are not familiar with Report Painter, you probably don\u2019t know, what to choose.<\/p>\n

\"Element<\/p>\n

<\/a>2.5.2 Predefined key figure \u2013 Actual costs<\/h4>\n

Let\u2019s try the second option \u2013 Predefined key figure.<\/p>\n

\"Element<\/p>\n

You get at list of choices. Pick ‘Actual Costs in current year’.<\/p>\n

\"predefined<\/p>\n

This looks better. The Basic Key figure (SWKG Costs) and characteristics are automatically filled in.<\/p>\n

\"predefined<\/p>\n

CO version is 0 = plan\/actual version, value Type is 4 = Actual, 1GJAHLJ is a formula variant that defaults the current fiscal year.<\/p>\n

Take a peek at the variable definitions (transaction GS13). The value #S001 in the formula field brings the current year to the variable. If you use a formula variable, you don\u2019t need to maintain the report definition, when the fiscal year changes.<\/p>\n

\"Formula<\/p>\n

Let\u2019s stick to this choice. Don\u2019t worry about the Column text. We will deal with it later. Double-click next on Column 2. Now there is also a third option ‘Formula’.<\/p>\n

\"Column<\/p>\n

<\/a>2.5.3 Predefined key figure \u2013 Plan costs<\/h4>\n

In column 2 we want to present the planned costs. Let\u2019s experiment with the Predefined key figures, if we can find something useful there.<\/p>\n

\"Column<\/p>\n

Total plan costs in curr. year<\/b>\u00a0 brings the plan costs for the total year,\u00a0 for periods 1-13.<\/p>\n

\"Column<\/p>\n

Plan costs, curr. year, curr. period<\/strong> brings the plan costs for the current month (1PERIK)<\/p>\n

\"Column<\/p>\n

\u2018Cumulative planned cost in curr year<\/strong>\u2019 brings the plan costs from the beginning of the year (period 1) to the current period.<\/p>\n

\"Column<\/p>\n

Formula variable 1PERIK contains value ‘#S006’ = current period (check with transaction GS13).<\/p>\n

There is no exact match with the actual cost definition. Let\u2019s try the option ‘Cumulative planned cost in curr year<\/strong>\u2019.<\/p>\n

<\/a>2.5.4 Formula<\/h4>\n

Now we have the actual costs in column 1 and planned costs in column 2. In column 3 we want to show the difference between actual and plan. Double-click on Column 3. Select this time Formula.<\/p>\n

\"Column<\/p>\n

A formula editor opens. In the ‘formula components’ part you see X001 and X002, which are the two columns we just have defined.<\/p>\n

\"Column<\/p>\n

We want the absolute difference of these two columns in Column 3. It is easy. Just type X001-X002 in formula line, or choose the formula elements from formula components.<\/p>\n

\"Column<\/p>\n

Enter a text.<\/p>\n

\"Column<\/p>\n

Now we have the last column left. We want to show here the difference in percentage. Double-click Column 4.<\/p>\n

\"Column<\/p>\n

Select Formula and type the formula (x001\/x002)*100 or choose the formula elements from formula components..<\/p>\n

\"Column<\/p>\n

Maintain the text.<\/p>\n

\"Column<\/p>\n

This is how our report looks now.<\/p>\n

\"report<\/p>\n

Try to save it. Still something missing. Controlling Area must be specified somewhere.<\/p>\n

\"error:<\/p>\n

<\/a>2.6 General Data Selection<\/h4>\n

Besides rows and columns, we need to maintain General data selection (under the Edit menu). Specify in General data selection all characteristics not needed in report rows or columns .<\/p>\n

\"General<\/p>\n

Empty Element definition opens.<\/p>\n

\"Element<\/p>\n

Move CO Area from the right to the left. If your company only has one controlling area, you can put the value here.<\/p>\n

\"Element<\/p>\n

<\/a>2.7 Save and execute<\/h4>\n

Now you can save the report and take a first look at it.<\/p>\n

\"Element<\/p>\n

Start with the clock.<\/p>\n

\"Execute<\/p>\n

<\/a>2.7.1 Report Group<\/h4>\n

You get a message on report group. All Painter Reports must be assigned to a Report Group before executing.\u00a0On initial creation of a report the system will let you create a new report group.<\/p>\n

\"No<\/p>\n

Answer YES.<\/p>\n

You can put the report in an existing report group, or you can create a new one. Create a report group YREP.<\/p>\n

\"Report<\/p>\n

\"Create<\/p>\n

Answer YES and the system will create the Report Group.<\/p>\n

<\/a>2.7.2 Errors?<\/h4>\n

Successful generation of a Report Group requires that Controlling Area, Fiscal Year and Period<\/strong> all have been correctly defined.<\/p>\n

We have defined Controlling area in General data and Fiscal year in Columns. Something is wrong with the characteristics Period.<\/p>\n

\"Error:<\/p>\n

Characteristics Period was used in Plan Costs column.<\/p>\n

\"Plan:<\/p>\n

Actual Costs doesn’t\u00a0 have Period, only Fiscal year is defined.<\/p>\n

\"Actual:No<\/p>\n

We need to add the Period also to Actual column.<\/p>\n

\"Actual:add<\/p>\n

After this correction the system generates the Report Group and the programs necessary to run the report.<\/p>\n

<\/a>2.7.3 New trial<\/h4>\n

Start the report again with the clock.<\/p>\n

This time we pass all the checks and the report selection screen opens.<\/p>\n

\"Report<\/p>\n

The fiscal year, period and plan version get default values from the used variables. If you are using SAP IDES system, you probably need to change the defaulted fiscal year to an earlier one. I have changed the defaulted 2018 to\u00a0 2013. The use of Set Variable 1KSTAR for cost elements adds the selection group for cost elements. Select group OAS.<\/p>\n

Our first report looks like this.<\/p>\n

\"Cost<\/p>\n

This report displays all the costs of controlling area 1000. To see the costs per cost center, we need to define the cost centers somewhere in the report.<\/p>\n

<\/a>2.8 Add Cost Centers to the report<\/h4>\n

A characteristic can only appear once either in rows, columns or general data selection. What would be the best place for cost centers?<\/p>\n

<\/a>2.8.1 Cost Centers in Rows<\/h4>\n

We could add characteristic Cost Center to the row definition. Double-click on row 1. Select Cost Center and move it from the right to the left.<\/p>\n

\"Row:<\/p>\n

We will use a Set Variable 1KOSET that contains all cost centers.<\/p>\n

Choose Explode (at the end of the line) for both Cost Element and Cost Center.<\/p>\n

Save the report and execute it.<\/p>\n

The selection screen has now changed. Cost Center Group or value(s) has been added to the Selection group. The Set variable 1KOSET enabled that.<\/p>\n

IDES has very old data, why I change the defaulted fiscal year. The selection is restricted to Cost Center Group H2410 and Cost Element Group OAS_PERS.<\/p>\n

\"Selection<\/p>\n

The report lists Cost Centers by Cost Elements. The Cost Element group is exploded with subtotals and a grand total.<\/p>\n

\"Report:<\/p>\n

Is it possible to change the order?<\/p>\n

We can change the order of characteristics in the report definition. Select under menu Edit Rows\/Explode.<\/p>\n

\"Menu:<\/p>\n

In the Explode Characteristics you see the order of the elements.<\/p>\n

\"Explode:<\/p>\n

Change the indicator from 2 to 1 for Cost Center.<\/p>\n

\"Explode:<\/p>\n

Save and run the report with same selection as above.<\/p>\n

Now we have the report in reverse order.<\/p>\n

\"cost<\/p>\n

You can experiment with different choices. For example you could choose Single values for Cost Elements.<\/p>\n

\"cost<\/p>\n

The report shows then the Cost Elements for each Cost Center without Cost Element hierarchy levels.<\/p>\n

\"cost<\/p>\n

<\/a>2.8.2 Cost Centers in Columns<\/h4>\n

Columns are used to display key figure values, why the idea of placing characteristic Cost Center there may seem strange.<\/p>\n

However, you might want to create a report consisting of a few Cost Centers and their values. You can then define the characteristic Cost Center in each column and use the cost center number as header text.<\/p>\n

\"cost<\/p>\n

Double-click on the first column. Move Cost Center to the elemements.<\/p>\n

\"cost<\/p>\n

Change the the column heading to Cost Center Name. Save and execute the report.<\/p>\n

The report looks like this.<\/p>\n

\"cost<\/p>\n

<\/a>2.8.3 Cost Center in General Data Selection<\/h4>\n

We have still one option. We can specify the characteristics Cost Center in General data selection.<\/p>\n

Remove the Cost Center from column definition and add it as a Set Variable 1KOSET to General data selection (under Edit).<\/p>\n

\"cost<\/p>\n

Choose Explode.<\/p>\n

When you run the report, the Cost Center Group opens in the navigation area on the left.<\/p>\n

\"cost<\/p>\n

To hide the Navigation Area, click on the Hierarchy Button on the left. The variation buttons on the right allow you to navigate between hierarchy levels.<\/p>\n

<\/a>2.8.4 Variation<\/h4>\n

The variation function allows you to print several reports at one go. It is possible to print a report for each element in a group (set) defined in General data selection.<\/p>\n

\"print_variation_reports\"<\/p>\n

The hierachy in the picture has 3 levels and 6 individual cost centers. When you print, you can choose, whether you want to print the selected level (H2010) or 9 separate reports of all variation levels.<\/p>\n

Variation is defined in report definition and is related to General data selections . Characteristics defined as groups (sets) in General data selection show up in variation (menu Edit\/Variation).<\/p>\n

\"menu:<\/p>\n

\"variation:<\/p>\n

The characteristic Cost Center is expanded, because it was exploded in the General data selection.<\/p>\n

If you execute the report in expert mode, you can change the variation setting.<\/p>\n

\"Selection<\/p>\n

In Expert mode Variation is displayed in report selection.<\/p>\n

\"Selection<\/p>\n

How to set expert mode:<\/p>\n

\"Menu:<\/p>\n

\"Expert<\/p>\n

If Expert Mode is not checked, variation is not visible.<\/p>\n

\"Selection<\/p>\n

<\/a>2.9 Column Heading Texts<\/h4>\n

Our report looks now like this. What if you wanted to show the periods in the column headings? This can be done with variables.<\/p>\n

\"Column<\/p>\n

We used element Period in columns 1 and 2 with values 1-1PERIK. Let’s change the From-value from 1 to 1PERIV. The default value of 1PERIV is 1, but the the value of can be changed at report start. Make this change in both columns.<\/p>\n

Double-click on the column header and maintain the texts in the Element definition.<\/p>\n

\"Column<\/p>\n

If you want to use the period interval in column text, enter the text in the Long text like this Actual &1PERIV – &1PERIK. It is also possible use arrow heads (Actual <&1PERIV> – <&1PERIK>)<\/p>\n

\"Column<\/p>\n

\"Column<\/p>\n

Short text is defaulted, why you need to change the header text lenght to One-line long text.<\/p>\n

\"Menu:<\/p>\n

\"Menu:<\/p>\n

You can now see the variables in column headings.<\/p>\n

\"Menu:<\/p>\n

When you execute the report, the variables are replaced with their values.<\/p>\n

\"Menu:<\/p>\n

<\/a>2.10 Fiscal Year and Periods<\/h4>\n

So far we have defined Cost Elements in the row, Cost Centers and Controlling Area in General Data selection, Fiscal year and Period in Columns.<\/p>\n

Fiscal year and Period interval are in both Actual and Plan columns. We could consider moving them to General data selection. In this report it would be OK, as the values are the same in both columns. For now we will leave the Fiscal year and Period as they are in column definition.<\/p>\n

Next we want to add a new column for previous years values. Select the predefined column Act.costs prev.yr. It adds fiscal year but no periods.<\/p>\n

\"Menu:<\/p>\n

\"Menu:<\/p>\n

Because of the missing period, we get an error when we try save and to run the report.<\/p>\n

\"Menu:<\/p>\n

We have two alternatives to correct the error:<\/p>\n

1. add period definition also to the previous year column<\/p>\n

2. move the period definition to General data selection<\/p>\n

We choose alternative 2. First remove Period from all columns and then add it to General Data. Now it is valid for all columns.<\/p>\n

\"Menu:<\/p>\n

Change the name of the Prev.yr. column heading to &1GJAHVJ &1PERIV – &1PERIK<\/p>\n

\"Menu:<\/p>\n

Run the report.<\/p>\n

\"Menu:<\/p>\n

Where did the variable 1GJAHVJ get the value 2012?<\/p>\n

The explanation is found in variable definition (transaction GS13). The 1GJAHVJ is a formula variable with value ‘&1GJAHLJ’-1. Variable 1GJAHLJ contains value ‘#S001’ = current year.<\/p>\n

\"formula<\/p>\n

In my example I changed the defaulted current year to 2013, because IDES does not contain current data.<\/p>\n

We need to keep the Fiscal year in columns, because it is not the same in all columns.<\/p>\n

In table CCSS we find several variables for Fiscal year. Does it matter which of them we use? If you check the variable definition (transaction GS13), you find out that several of them default the current year (‘#S001’)<\/p>\n

\"selection<\/p>\n

Let\u2019s experiment a little.<\/p>\n

Change the Fiscal year variable as follows:<\/p>\n

Actual: 1GJAHR, Plan 1CGJAHE, Previous year 1GJAHVJ.<\/p>\n

Run the report. The Fiscal year appears three times in the selection.<\/p>\n

\"selection<\/p>\n

\"report<\/p>\n

Change the definition as follows:<\/p>\n

Actual 1GJAHR, Plan 1GJAHR, Previous year 1GJAHVJ.<\/p>\n

Run the report.<\/p>\n

\"report<\/p>\n

\"report<\/p>\n

Why do we still get two Fiscal Years? The cause is variable 1GJAHVJ that we used for Previous year. It is derived from the current year variable 1GJAHLJ, which is displayed in the selection.<\/p>\n

If you use in the report figures for previous years, use 1GJAHLJ for current year. Variables 1GJAHVJ and 1GJAHVV are derived from 1GJAHLJ.<\/p>\n

1GJAHVJ = 1GJAHLJ-1, 1GJAHVV= 1GJAHLJ -2.<\/p>\n

\"selection<\/p>\n

You can avoid the problem of multiple selection fields caused by inconsistent variables, if you can move the characteristics to general data selection. We did this with the characteristics Period. However, you need to keep the Fiscal Year in column definition, because it is not same for all columns.<\/p>\n

<\/a>2.11 Add and delete columns<\/h4>\n

<\/a>2.11.1 Delete a Column<\/h4>\n

If you need to delete a column from the definition, right-click on the column and select Delete from the menu.<\/p>\n

\"delete<\/p>\n

<\/a>2.11.2 Insert a Column<\/h4>\n

If you need to a column between existing columns, click inside the column before which you want to add the new column. Right-click to open the menu. Select Insert element. Select element type.<\/p>\n

\"insert \"select<\/p>\n

<\/a>2.12 Report title<\/h4>\n

You might wonder where you can change the \u201c: Selection\u201d displayed at the beginning of the report.<\/p>\n

\"report<\/p>\n

You do it in the Report Group (GR52). Enter there the text you want to see in ‘Description’.<\/p>\n

\"report<\/p>\n

The description text is added before \u201d: Selection\u201d .<\/p>\n

\"Cost<\/p>\n

<\/a>2.13 Report \/ report interface<\/h4>\n

In the SAP standard reports we can drilldown to line items and original documents. How do we get this functionality to our own reports? This is also done in the Report Group.<\/p>\n

<\/a>2.13.1 Drilldown to line item reports<\/h4>\n

You find Reports Groups in Ad Hoc reports under Report Writer. SAP Menu: Information Systems \/ Ad hoc Reports\/ Report Writer\/Report Group<\/p>\n

\"Menu:<\/p>\n

Our report group was YREP.<\/p>\n

\"Report<\/p>\n

The drilldown feature is called Report\/Report Interface. It can be defined at Library or Report Group level.<\/p>\n

\"Report\/report<\/p>\n

Click on Configure.<\/p>\n

\"Report\/report<\/p>\n

To add a report definition, click on Plus.<\/p>\n

\"Report\/report<\/p>\n

Enter the name of the Report Group. Our group was YREP. Select ‘Other Report Type’.<\/p>\n

\"Report\/report<\/p>\n

Select Report type TR Transaction.<\/p>\n

\"Report\/report<\/p>\n

Check in the SAP menu, which are the transactions for Cost Center line item reports. \"KSB1<\/p>\n

Return to Report Group and add transaction code KSB1 Actual line items.<\/p>\n

\"TR<\/p>\n

When you return back to Assign Report, click on Plus to add the Plan line items report. Enter the report group YREP, select Other Report Type and TR. Enter the transaction KSBP Plan line items.<\/p>\n

You can change the order of the reports, if you want.<\/p>\n

\"Change<\/p>\n

Select (1) first Actual line items, place then the cursor on Plan Line items and click on Move (2).<\/p>\n

\"Save\"<\/p>\n

Save the definition.<\/p>\n

There are now two reports assigned to the report group.<\/p>\n

\"configure\"<\/p>\n

Test run your report. Double-click a figure in actual column.<\/p>\n

\"test<\/p>\n

A report selection box opens. Select Actual line items.<\/p>\n

\"drilldown<\/p>\n

You come to the Actual line items report.<\/p>\n

\"cost<\/p>\n

Here you can choose a line, double-click it and move over to the original document. In this example to the accounting document.<\/p>\n

\"fi<\/p>\n

Return to your cost center report with the green arrow.<\/p>\n

<\/a>2.14 Report Layout<\/h4>\n

Next we will take a quick look at the report layout.<\/p>\n

<\/a>2.14.1 Format Group<\/h4>\n

Above every column you can see a format group (0).<\/p>\n

\"format<\/p>\n

You find the format settings from menu Formatting\/Columns.<\/p>\n

\"menu<\/p>\n

The format groups controls: the column width, scaling 1-1.000.000, decimals 0 \u2013 0,00000 etc.<\/p>\n

\"format<\/p>\n

Change the scaling to thousands.<\/p>\n

\"report<\/p>\n

This setting is not a very good for column 4 Var (%). We can change the format group for this column. Double-click on the format group 0 above the column. Assign format group 1 for this column.<\/p>\n

\"assign<\/p>\n

Change the scaling in group 1 to 0, with no decimals and check the outcome.<\/p>\n

\"format<\/p>\n

<\/a>2.14.2 Report Layout<\/h4>\n

Select Report Header from menu Edit<\/p>\n

\"menu:<\/p>\n

SAP standard layout is the default setting.<\/p>\n

\"maintain<\/p>\n

SAP standard layout is the default, but you can also define your own layout and set it as standard layout.<\/p>\n

\"sap<\/p>\n

\"sap<\/p>\n

\"sap<\/p>\n

Use transaction GR11 to create own layouts.<\/p>\n

\"sap<\/p>\n

Copy the new layout from existing standard layout and make the changes you want.<\/p>\n

\"menu:<\/p>\n

The Report layout is in menu Formatting\/Report Layout.<\/p>\n

\"formatting<\/p>\n

If you run the report in Expert Mode, you can change the Layout settings under Settings\/Report Layout.<\/p>\n

<\/a>2.15 Sections<\/h4>\n

<\/a>2.15.1 Create New section<\/h4>\n

You can use sections in your reports.<\/p>\n

\"menu:<\/p>\n

First you define the type of the section.<\/p>\n

\"new<\/p>\n

<\/a>2.15.1.1 Section with characteristics and key figures<\/h4>\n

The definition of Sections with characteristics and key figures is the\u00a0 same as for columns. You can present statistical postings, statistical key figures, acticity types, quantieties in report sections.<\/p>\n

SAP Help: “If cost centers, orders and project wbs are needed together, they are usually in separate sections of the report. The cost cost center is repeated in each sections lead column.”<\/p>\n

As you already know how define Report Painter rows and columns,\u00a0 I will not repeat it here.<\/p>\n

\"section<\/p>\n

<\/a>2.15.1.2 Section with calculated key figures<\/h4>\n

Here you can present all kind of key figures. In our report we had in columns 3 and 4 the difference between Actual and Plan. We could present them as calculated Key figures.<\/p>\n

\"section<\/p>\n

Before you start with the section definition, you need to define cells that\u00a0you use in the key figures. Double click the intersection of row and column. A check mark is added. It indicates the cells you can use in calculations.<\/p>\n

\"section<\/p>\n

Move to the section with section buttons.<\/p>\n

\"next<\/p>\n

Enter the header texts.<\/p>\n

\"section:<\/p>\n

Double-click on the first row the lead columns and add the name of the first key figure. Repeat for the next key figure. In the adjacent column\u00a0 + xxx.xxx is added. It is a placeholder for the formulas.<\/p>\n

\"section:<\/p>\n

Double-click on the placeholders. The formula editor opens. The cells defined are already there. Write the formula to the formula line.<\/p>\n

Save and test run the report.<\/p>\n

\"report<\/p>\n

\"report<\/p>\n

<\/a>3 Main elements of Report Painter<\/h4>\n

The main elements of Report Painter reports are:<\/p>\n

\u00b7 Reporting tables<\/p>\n

\u00b7 Report Libraries \/<\/p>\n

\u00b7 Report Group<\/p>\n

\"main<\/p>\n

We have already encountered them, when creating our report.<\/p>\n

<\/a>3.1 Library 1VK and Report Table CCSS<\/h4>\n

Let\u2019s take a closer look at library 1VK (tx. GR23)<\/p>\n

\"display<\/p>\n

1VK Most Standard Cost Center reports are in here<\/p>\n

\"display<\/p>\n

The keystone of the library is a reporting table (1) that provides the characteristics and key figures you can use in reports. Library 1VK uses table CCSS. If you create your own library, the first thing to do is to choose a reporting table.<\/p>\n

Below some of the most commonly used reporting tables.<\/p>\n

\"display<\/p>\n

<\/a>3.1.1 Characteristics<\/h4>\n

Characteristics (2) are elements you will use in the report rows, columns and selections. Such as cost center, cost element, profit center, account.<\/p>\n

\"characteristics\"<\/p>\n

<\/a>3.1.2 Basic Key Figures<\/h4>\n

Basic Key Figures (3) are numerical value fields. Such as costs, quantity, Total costs in trans. or object currency.<\/p>\n

\"Basic<\/p>\n

<\/a>3.1.3 Key figures (predefined key figures)<\/h4>\n

Predefined key figures (4) combine key figures and characteristics. Examples of key figures: actual costs in current year, plan costs in closed year.<\/p>\n

\"Key<\/p>\n

<\/a>3.2 create your own library<\/h4>\n

\"menu:<\/p>\n

Start the names of your own libraries with Y or Z.<\/p>\n

\"create<\/p>\n

\"create<\/p>\n

\"copy<\/p>\n

<\/a>3.3 Report Group YREP<\/h4>\n

A Report Painter report contains only the report definition. Everything else is in the Report Group. When you run a new report for the first time, the system checks the Report Group assignment. If the report is not in any Report Group, you can either choose an existing Report Group or let the system create a new group.<\/p>\n

The system executes all the reports in the Report Group at the same time. Usually there is only one report, but there can be several, e.g. month end reports. You can assign a report to several Report Groups.<\/p>\n

\"change<\/p>\n

If the report group contains several reports these can be executed as a set. For example you have two reports in report group YREP.<\/p>\n

\"report<\/p>\n

Start the reports from the report group.<\/p>\n

\"report<\/p>\n

Both reports show up on the report screen, where you can start them.<\/p>\n

\"report<\/p>\n

In the report group header you entered the description that shows up in the report selection screen.<\/p>\n

The drilldown to line items was defined in the Report\/Report interface of the Report Group.<\/p>\n

\"report<\/p>\n

<\/a>3.4 Sets and Variables<\/h4>\n

We have in our definitions used different sets and variables.<\/p>\n

All the cost element, cost center, order, profit center groups are sets that you can use in the report definitions.<\/p>\n

For cost elements and cost centers we used Set variables.<\/p>\n

\"cost<\/p>\n

\"variables\"<\/p>\n

Variables are in Report Writer menu.<\/p>\n

\"menu:<\/p>\n

Set variable 1KSTAR contains all cost elements. Set variable 1KOSET contains all cost centers.<\/p>\n

The use of set variables adds to report selection the possibility to select groups. For example 1KOSET ->\u00a0Cost Center Group or values(s), 1KSTAR -> Cost Element Group or value(s).<\/p>\n

Depending on their definition the variables can get different default values.<\/p>\n

\"menu:<\/p>\n

We used variables also in the column headings. Before the variable a prefix\u00a0 “&” was added. Numerical variables enable calculations, such as\u00a0 “&CURYEAR – 1”.<\/p>\n

\"menu:<\/p>\n

You can maintain the variables with transactions GS13 Display, GS12 Change.<\/p>\n

Set variable 1KSTAR contains all cost elements. Set variable 1KOSET contains all cost centers.<\/p>\n

\"display<\/p>\n

We explored the use of variables to define Fiscal year and Period.<\/p>\n

1GJAHLJ contains a system variable #S001= current year.<\/p>\n

\"variable<\/p>\n

Variable 1GJAHVJ contains a formula ‘current year – 1<\/p>\n

\"variable<\/p>\n

Variables 1PERIV, 1PERIK define the period interval.\u00a0 The default value of 1PERIV is 1, which you can be change in the report selection.<\/p>\n

\"variable<\/p>\n

The variable 1PERIK contains a system variable\u00a0 #S006 = current period.<\/p>\n

\"variable<\/p>\n

Use standard variables for the reporting tables, if possible. Table T802G contains the variables per the tables.<\/p>\n

What next?<\/h2>\n

At this stage of the exercise you should have the basic skills necessary to work with your own reports. Keep in mind that there are lot’s of standard reports in the system that you can copy and mofify to suit your own purposes.<\/p>\n

How to get the reports to production? That depends on the IT policies of your company. It is possible to create transport requests or export the report definitions as text files to other systems (DEV, PRD). It is possible to\u00a0 generate transactions and attach the reports to report trees (Area Menus).<\/p>\n

\"SAP<\/a><\/p>\n

More on the subject:<\/p>\n

SAP Area Menus<\/a><\/p>\n

How to export\/import report groups<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

[…]<\/p>\n","protected":false},"author":3,"featured_media":1324,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,15,93],"tags":[97],"class_list":["post-1291","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-materials","category-reporting","category-sap-report-painter","tag-sap-report-painter"],"yoast_head":"\nReport Painter - Beginners Guide - Esfoor<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Report Painter - Beginners Guide - Esfoor\" \/>\n<meta property=\"og:description\" content=\"[…]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Esfoor\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-18T14:51:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-08T09:13:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1094\" \/>\n\t<meta property=\"og:image:height\" content=\"294\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ritva\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ritva\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"24 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/\"},\"author\":{\"name\":\"Ritva\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"headline\":\"Report Painter – Beginners Guide\",\"datePublished\":\"2018-03-18T14:51:10+00:00\",\"dateModified\":\"2021-10-08T09:13:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/\"},\"wordCount\":4884,\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2018\\\/03\\\/RP_image000-1.jpg\",\"keywords\":[\"SAP Report Painter\"],\"articleSection\":[\"Materials\",\"Reporting\",\"SAP Report Painter\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/\",\"name\":\"Report Painter - Beginners Guide - Esfoor\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2018\\\/03\\\/RP_image000-1.jpg\",\"datePublished\":\"2018-03-18T14:51:10+00:00\",\"dateModified\":\"2021-10-08T09:13:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2018\\\/03\\\/RP_image000-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2018\\\/03\\\/RP_image000-1.jpg\",\"width\":1094,\"height\":294,\"caption\":\"CO std report - Report Painter\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2018\\\/03\\\/18\\\/report-painter-beginners-guide\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Report Painter – Beginners Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\",\"name\":\"Esfoor\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\",\"name\":\"Ritva\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"caption\":\"Ritva\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Report Painter - Beginners Guide - Esfoor","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/","og_locale":"en_US","og_type":"article","og_title":"Report Painter - Beginners Guide - Esfoor","og_description":"[…]","og_url":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/","og_site_name":"Esfoor","article_published_time":"2018-03-18T14:51:10+00:00","article_modified_time":"2021-10-08T09:13:00+00:00","og_image":[{"width":1094,"height":294,"url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg","type":"image\/jpeg"}],"author":"Ritva","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ritva","Est. reading time":"24 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#article","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/"},"author":{"name":"Ritva","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"headline":"Report Painter – Beginners Guide","datePublished":"2018-03-18T14:51:10+00:00","dateModified":"2021-10-08T09:13:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/"},"wordCount":4884,"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg","keywords":["SAP Report Painter"],"articleSection":["Materials","Reporting","SAP Report Painter"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/","url":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/","name":"Report Painter - Beginners Guide - Esfoor","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#primaryimage"},"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg","datePublished":"2018-03-18T14:51:10+00:00","dateModified":"2021-10-08T09:13:00+00:00","author":{"@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"breadcrumb":{"@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#primaryimage","url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg","contentUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2018\/03\/RP_image000-1.jpg","width":1094,"height":294,"caption":"CO std report - Report Painter"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esfoor.fi\/en\/2018\/03\/18\/report-painter-beginners-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esfoor.fi\/en\/"},{"@type":"ListItem","position":2,"name":"Report Painter – Beginners Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.esfoor.fi\/en\/#website","url":"https:\/\/www.esfoor.fi\/en\/","name":"Esfoor","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esfoor.fi\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8","name":"Ritva","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","caption":"Ritva"}}]}},"_links":{"self":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/1291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/comments?post=1291"}],"version-history":[{"count":65,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/1291\/revisions"}],"predecessor-version":[{"id":1765,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/1291\/revisions\/1765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media\/1324"}],"wp:attachment":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media?parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/categories?post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/tags?post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}