cancel
Showing results for 
Search instead for 
Did you mean: 

GRCT HOW TO ADD Z TABLES IN REPORT PAINTER

andres_moreno
Participant
0 Kudos

Hi Gurus

Could you please send me information about how to activate z tables in report painter ? someone said me that i can user transaction GRCT to do that...¿ what aspects must I consider to add a table ?

mail: amoreno@colombina.com

Regards

Andrés Moreno

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member97095
Discoverer
0 Kudos

Hello,

I activate a z report writer table with the transaction GRCT by copying an existing report writer table (GLT0 existing in T804E table) . GLT3 (existing in T804A table) is the transfer structure of the new Z table.

Then, I create a library and a report painter report using the Z table.

Company code is one characteristic of general data selection .

The report works perfectly for one company code.

But, when selecting an interval of company codes, there is a short dump with the assignment error : Overwriting a protected field.

To look for OSS note, SAP advises the following selection criteria :

"MOVE_TO_LIT_NOTALLOWED_NODATA" C

"SAPLGUMD" or "LGUMDU01"

"G_READ_TEXT"

I don't find any OSS note.

Can anybody help me to correct this issue ?

Thanks a lot in advance.

Bandrian

Former Member
0 Kudos

hi Andres,

below are the steps for the Report Painter.....

Create a new report.

Menu Path: Information Systems > Ad hoc reports > Report Painter > Report > Create

On the Report Painter: Create Report screen, enter:

Library – 1VK

Report RSS-A

Report Description – Report w/Total Row

Hit <Create> button to move to the next screen.

Create the Rows of the Report – The first four rows are cost element characteristics

Screen: Report Painter: Create Report

Type ‘Cost Elements’ in the lead column cell

Double click on Row 1

In the Pop-up window 'Element definition: Row1", enter:

Note: If Pop-up window (select element type) appears, choose 'characteristics' and hit <Enter>.

Select 'Cost Element' as the characteristic in the 'Available characteristics' section

Hit <Move selected to left> button to move the characteristic 'Cost element' to the 'Selected characteristics' section

From – 430000

Hit <Change short, middle and long texts> icon (at the bottom of the window)

In the Pop-up for Enter Texts, Enter:

Short – Description from Table above for this Account

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Confirm> to close the Pop-up

Hit <Confirm/Enter> to check consistency and close.

Repeat the above steps for the other 3 accounts

Create a formula row to calculate the total of the Cost Element rows

Screen: Report Painter: Create Report

Double click on Row 5 or the next empty row.

In the Pop-up for Select Element Type select 'Formula'

Hit <Enter> to close the Pop-up

In the Pop-up 'Enter Formula'

Use the calculator buttons to create the formula Y001 + Y002 + Y003 + Y004

Hit <Enter> to close the Pop-up

In the Pop-up 'Enter Texts'

Short – Total

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Enter> to close the Pop-up

Make sure your cursor is in the cell containing the word ‘Total’

Follow the Menu Path: Formatting > Row

In the Pop-up 'Row Formatting'

Overscore – checked

Underscore – checked

Hit <Enter> to close the Pop-up

Create the first column for actual costs

Screen: Report Painter: Create Report

Double click on the ‘Column 1’ cell.

In the Pop-up 'Select element type'

Select Predefined Key Figure radio button, and press <Enter>.

In Pop-up 'Choose predefined column'

Select Actual Costs as the predefined column, and press <Enter>.

In the Pop-up 'Element definition: Actual costs'

Press <Confirm> to check consistency and close.

Define the second column for plan costs

Screen: Report Painter: Create Report

Double click on the ‘Column 2’ cell.

In the Pop-up 'Select element type'

Select Key Figure with Characteristics as the element type, and press <Enter>.

In the Pop-up 'Element definition: Column 2'

Value Type – 01 (Plan)

Version – 0 (Actuals)

Valuation – 0 (Legal valuation)

Hit <Change short, middle and long texts> icon

In the Pop-up for Enter Texts, Enter:

Short – Plan

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Confirm> to close Pop-up.

Hit <Confirm> to check consistency and close.

Create a formula column to calculate the variance between actual and plan costs

Screen: Report Painter: Create Report

Double click on the ‘Column 3’ cell

Assign the points....

Ranjit

andres_moreno
Participant
0 Kudos

Ranjit thanks for your response.. but the question is about how to add tables (ztables) to report painter in order to create reports.

Former Member
0 Kudos

hi,

the above steps are to create the tables only....

ranjit

andres_moreno
Participant
0 Kudos

Ranjit, the steps above are to create tables or reports ?? I believe that are in order to create reports.

I have a table Z and i want to use it in a new library but I must to activate the table in report painter first .

Message was edited by:

Andres Moreno

Message was edited by:

Andres Moreno

Former Member
0 Kudos

Hi Andres,

All the reports are based on Library and the Library is specific to a table. So you need to create a Library with the Table you want and then create the report under that Library. Do GR21 to create a Library.

Regards

Sridhar

andres_moreno
Participant
0 Kudos

Sridhar, It's true but you must register user defined tables by transaction grct before.... I want to know if someone have made it before, and have some documentation.

Regards

André