|
|
 NEW INTERVIEW QUESTIONS.COM 
 SAP R-3 INTERVIEW QUESTIONS
ABAP INTERVIEW QUESTIONS  DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
 Question |
What is the difference between collect and sum?
|
 Answer
|
SUM:
When processing an internal table in a block starting with LOOP and concluded by ENDLOOP , SUM calculates the control totals of all fields of type I , F and P (see also ABAP/4 number types ) and places them in the LOOP output area (header line of the internal table or an explicitly specified work area).
When you use SUM in a LOOP with an explicitly specified output area, this output area must be compatible with the line type of the internal table.When using LOOP to process a sorted extract (see SORT ), the control total
of f at the end of the group appears in the field SUM(f) - - if f is type I , F or P .
COLLECT.
COLLECT is used to create unique or compressed datsets. The key fields are the default key fields of the internal table itab .
If you use only COLLECT to fill an internal table, COLLECT makes sure that the internal table does not contain two entries with the same default key fields.
If, besides its default key fields, the internal table contains number fields,the contents of these number fields are added together if the internal table already contains an entry with the same key fields.
If the default key of an internal table processed with COLLECT is blank, all the values are added up in the first table line.
If you specify wa INTO , the entry to be processed is taken from the explicitly specified work area wa . If not, it comes from the header line of the internal table itab .
After COLLECT , the system field SY-TABIX contains the index of the - existing or new - table entry with default key fields which match those of the entry to be processed.
COLLECT can create unique or compressed datasets and should be used precisely for this purpose. If uniqueness or compression are unimportant, or two values with identical default key field values could not possibly occur in your particular task, you should use APPEND instead. However, for a unique or compressed dataset which is also efficient, COLLECT is the statement to use.
If you process a table with COLLECT , you should also use COLLECT to fill it. Only by doing this can you guarantee that the internal table will actually be unique or compressed, as described above and COLLECT will run very efficiently.
If you use COLLECT with an explicitly specified work area, it must be compatible with the line type of the internal table.
Sum inside the loop and collect outside the loop.
Answered By: lokesh Date: 7/10/2008
© NewInterviewQuestions.com
|
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
| Notify me when better answer is posted! |
A D V E R T I S E M E N T
|
|
|
Latest 10 Answers
|
|
With the help of bluetooth we can send information from mobile to mobile or from mobile to stationary device..it create a LAN i.e local area network and send data from source to destination.
|
|
That can either be done by using that web service in your web apllication. that is the simplest way....
|
|
N-tire
|
|
CLR,J#,C#,VISUAL STUDIO,
CTS,ASSEMBLY,,.....etc
|
|
A proxy server is a process that acts like a switchboard through a firewall to manage the various types of permitted communications with the outside world. Proxy servers may also use caching to make communications more efficient.
|
|
networking is the engineering discipline concerned with communication between computer systems or devices.
|
|
cascading prompt report recives the previes prompt values and restrict the data to curent prompt report.
but drill throw is acses the directly(no ristrict) to the current detail report
|
|
A snowflake schema is a set of tables comprised of a single,central fact table surrounded by normalized dimension hierarchies.
|
|
Maximum I tried to save my family.
If i can't, I just threw my wife first.
because, She is young.She had ability to save herself in some extent. In meantime,i threw a small boat which is available in Ship or Tube.
|
|
If you consider two hardware that do their work separately.In some extend,one hardware require the another one for finish its work and vice versa.Both did not give priority to each other.
|
|
Rating
(4.6) By 7 users
Added
Views
Rate it!