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
temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi
Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes
Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?
class MyApp
{
utl_file open error
i have file in the unix path
Path /popdev01/pop/popdevb/tfi/
File name
Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:
Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :
how can i make a .gif images for my site
Dear Friends ,
Pls solve my problem , I am starting making new site but i dont know how can i
. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!
My son
upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t
gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext