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

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav