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
14
Other forums
Not capturing all the information we require in the form.......
Hi Guys,
I was wondering if you would share some more of your knowledge today, I'm hoping it
php/xmlrpc class issue
I am working on xml-rpc in php to start with.
I have a class that only has variables defined
Validating time
Hi Guys
what do you think of the following approach to validate a 24hour time:
http://
Help with syntax
Hi all!
The $bridge variable is not getting passed while it is contained in the line below:
Allegro crashes when running load_bitmap. Why?
I can not get Allegro to load any BMP images. Here is a section of test code. The picture is in the
array empty
Hiya peeps,
Ok here is the codes.
order.php
Code:
Need help making login verification cleaner...
I use the below to verify user login. I first check the cookie for the id, ip and a unique id. If it
Format String help
I have a textbox where a person enters an application number. the application number is 10 characte
PHP XML extraction text
I would like to extract an xml text and have that text directly echo(print) out on my web page. Her
FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde