ALV sum various columns problem

Posted on 16th Feb 2014 07:03 pm by admin

Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is similar to this:
Year Month Type Item #days tue-1 wed-2 thu-3 ... 2009 September Project Project1 3 1 1 1 2009 September Project Projec2 5 1 1 0 2009 September Task Task1 1 0 1 0

The field #days is a sum of all the days columns for september next right to the #days column.
I can have an SQL wich can extract all the data to fill year,month,type,item and #days. But then, i need to flat these #days in the correct days column. I think i can do it with 2 sqls, but then i need to join these data to display it right.
Finally, present that data in an ALV.

I have a structure defined in ABAP dictionary with all the static fields. The columns representing the days (sat-1,sun-2,...) are not in the structure.
I've tried to define a new structure wich include the old one and define the remaining columns, but i can't show the fields defined in this extra structure, only the static fields defined in ABAP dictionary.

This is probably simple, but i'm just starting in ABAP, and this seems odd and confusing right now.

What's your advice to solve this problem?

Your Answer:

Login to answer

Other forums

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

Parse error: syntax error, unexpected T_ELSEIF in /home/......html/item.php on l
I do not know what is wrong with this. Hope some one can help. I do nto want to post the entire site

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Passing variables with pagination - iterating through unique id per link
Hi everyone,
I have seen a few topics like this one. Still cant find the specific thing, so I am

Change of partner analyse in sales orders
Hello,

I changed the partner analyse for sales orders and added a new mandatory partnerro

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Using mysql_real_escape_string for displayed content
On my website users can input data into a textarea and it will store it in the mysql database. But,

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<