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
MS Exchange 2007 integration with ECC 6.0
Hello Experts,
We have ECC 6.0 and MS Exchange 2007. We need to integrate ECC 6 and MS Excha
Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to
CHMOD script
Hi,
I need a script to read all files in a folder and set to 777.
Can anyone help out
Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me
What are the two different files you download to update kernel?
What are the two different files you download to update kernel?
help finding hacking loopholes
i was attacked by a redirect php injection
my pc is clean of viruses
so i figure that
Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER
Header redirect
Hello ive got a problem ive got form with its action set to itself.
Code: <form id="f
couldn't connect to your database
Hello I am new to php mysql
Actually i have read A tutorial on nettuts
"http://net.tu
Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!