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

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s

Need a Timecode Class...
Not a Time Stamp, Time Code. Format is a bit different. HH:MM:SS:FF where FF is Frames. I dont re

Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

mysql_query returning boolean instead of mysql ressource
Hi,

I seem to have a weird issue with the php command mysql_query. I pass 2 arguments the que

Please help understand this code
I noticed the index page on my site was modified this morning and found this code inserted at the bo

array help
Does anyone know how to require 10 text fields for individual grades and output class average? (10 p

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t