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

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

C problem struct and string
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

PDO returns erroneous columns from within pdt
Hi All,

This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns a

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.

So this would write 2232 a