How to add new column in report painter

Advertisement

Hi Experts,
I want to add new column in report painter which as to calculate the previous column . value in the new column should be the precentage of previous column existing on left side...

Advertisement

HI  Pradeep,
Goto the transaction code (Change Report) GR32.
Give you library name and report name
And click on the column (application tool bar or F7) button then place the curser on the screen where you want column (please note you have to keep curser on the header section u2013Red column text) right click and insert element. Then you select formula as selection element  and enter. You will get the enter formula box. Then you can type your formula and continue. This will add new column to the report.
How to enter formula: you can see the formula components in that id and description.
Id is columns that are present and description indicates explanation of that column.
Enter formula according your requirement.
Examples:
Enter formula screen:
ID :    des
X001  amount
X002  pt000
X003  test
1. Enter formula as: ( X001 u2013 X002)
The above formula is for fist column u2013 second column.
2. ( ( X001 u2013 X002) / X003) * 100
First column u2013 second column and devide by third column after that multiple with 100.
Hope this will help you
Regards
Manohar

October 11, 2015

How to add new column in report painter

Hi Experts, I want to add new column in report painter which as to calculate the previous column . value in the new column should be the precentage of previous column existing on left side...HI  Pradeep, Goto the transaction code (Change Report) GR32

How to add external call from Report Painter

Hi experts, I'm working on a report painter, and I need to do an external call, from the generated code. add something like this    PERFORM Z_CALCULO_IMPORTE_COMPENSADO(ZCASS_FFMRBCS)                                                                   

New column to report painter

Hello ABAP Gurus, There is a report created with Report Writer (S_ALR_87013000) and I should add some extra columns to the end of it. The problem is that the new columns are not contained by the basic keyfigures of Report Painter; they should be red

How to add new columns to datablock

Hi, I am new to oracle forms. Can you gurus out there help me with a simple query. I've a data block based on system_parameters table. I've to add two new text items corresponding to two new columns (let say A & B) added in the same table. I've added

ERec: How to add new column in Recruiter TRM New Registered Candidates list

Hi, In the Recruiter tab, active query for TRM> New Registered Candidates, there are 9 columns which has candidate name, registered since, resume, interest group and so on. If I want to add "Country" in the view, how to proceed? Please advice

Can we add a new column in report which is not in table.

Hi All, Can we create a new column in report which is not in table. I have two columns in my table completion_date, manufacture_date. If the difference between the completion_date and manufacture_date is 0, -1, 1 then the new column of the report wil

How to include variable in the text column in report painter?

Dear Expert, Would like to seek for your help to include How to include variable in the text column in report painter?Please advice. Thank you. Regards, Karen Edited by: Karen Swee Ping Ho on Jun 17, 2011 2:48 AMHi, Thank you for the promt reply. 1)

How to add Two Columns in SQL

How to add Two Columns in SQL For Example Jan Feb 215 NULL How to add these two values in SQLAnything + NULL is NULL. Check this: SQL> SELECT 1 + NULL from dual;     1+NULL SQL> You have to do this: SQL> with t as (SELECT 235 JAN, NULL FEB FROM d

How to add new fields in asset master data

Hello, i was wonder if anyone knows how to add new fields that arent defined in the asset master data. Thanks. PedroHi Pedro, SAP allows entering upto 8 fields on the asset master. These fields are called 'Evaluation group'. Out of 8, 4 are four char

How to add new currency in ORCO and ORBO

Hi, I have successfully install ORCO, ORBO and ORPOS. I followed Implementation Guide, Volume 1 – Implementation Solutions to add new currency in ORPOS. But I still do not know how to add new currency in CO and BO. I try to use import parameter featu

How to add new attribute in product catalog?

Hi All, Can anyone tell me how to add new field/attribute in product catalog? The requirement is to display product's new attribute on product catalog screen. Do I need to create any custom java class? Need suggestion!! Thanks. Regards, RupaliHello R

How to add new data file

Hi Friends, We have 4 below file systems. Sybase/TST/sapdata_1 Sybase/TST/sapdata_2 Sybase/TST/sapdata_3 Sybase/TST/sapdata_4 Already we have added one data file each in sapdata_1 and 2.  Sapdata3 and 4 are emptry. How to add new data file in sapdata

How to add new fields in SAP-Query

Hi, Can any body tell how to add new fields to the existing query. Thanks a lot, Bhaskar.hi, when we create internal tables like. in final table you can include the extra fields. data : begin of itab_mara,          matnr like mara-matnr,          erd

How to add new item in more options dialog box

Hi all, Can anyone tell me how to add new item in more options dialog box(site actions -> more options). I want to add new item there to the new page layout which I created but I didn't find any way to do it. can anyone assist me for this.Good point,

How to add new group attribute in OAM?

Hi, I'm using SunONE DS 5.2 P4 as my Oracle Access Manager repository. I would like to add some new attributes to Users and also to Groups. I am able to add the new attributes to users by adding the attributes to the oblixorgperson object class in Su

Want to add one new column in Report form

Hi all, I have searched in forum but not able to find the answer. I want to add one new column in form 12KST1C. I have added one column PR commitment in left and saved the form, it is showing in form but when i am running the report again then pr com

How add new column in analysis from two subject area

which is the right way to add a new column to an existing combined analysis from two subject areas? if I add the new column first in my two combined queries, then I saw a new column in the results column panel, but this new column is empty and I can'

EXTREMELY URGENT: % Cost (out of Total Costs) Column in Report Painter

Hi Gurus, I'm not new to Report Painter, but, am stuck at one thing. In report, Col 1 shows Costs by Administration (row 1), Labor (row 2), Others (row 3) and total (row 4 being formula as total of row 1, 2 & 3). Client wants col 2 to show % Cost of

How to add new tab to GL Accounts Determination Form

Hello Professionals, I want to add new tab to GL Accounts Determination. This form can't be opened using screen painter in SAP, Also, i have tried several codes to add it through UI API but with no progress so far. How can i do this? Thanks in advanc

Add emil functionality to Report Painter

Hi all, It is tough to explain my requirement but I i am doing my best to make it clear!!1 We have Transaction ZZ007A which calles Report writer Program My requirement is to add emil functionality to send these reports to clients. We have one of sele