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?

No comments posted yet

Your Answer:

Login to answer
77 Like 14 Dislike
Previous forums Next forums
Other forums

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

Which practice of iteration through containers is preferred
In the "real world" what kind of loop do most people use to iterate through a container like a vecto

Somebody hacked into my site and changed coding >>> URGENT HELP NEEDED <<<
I am not that much into programming , but somebody is hacking to my site and injecting some kind of

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

upload control not working with update panel
Hi,

I am working with Asp.Net FileUpload control with ajax update panel,

if i use the

Export hangs
Hi all, please help

I have a Oracle 10.2.0.3.0 database. When I want to query the dba_segmen

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

Scheduler problems related to execution of a single BLT by many schedules
Hello all,

We are running several MII instances in a distibuted architecture using a sing

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash