|
|
 NEW INTERVIEW QUESTIONS.COM 
 SAP R-3 INTERVIEW QUESTIONS
SAP REPORTS 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
|
COLLECT allows you to create unique or summarized datasets. The system first tries to find a table entry corresponding to the table key. The key values are taken either from the header line of the internal table itab, or from the explicitly-specified work area wa.
If the system finds an entry, the numeric fields that are not
part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an
entry, the system creates a new entry instead.
The way in which the system finds the entries depends on the type of the internal table:
- STANDARD TABLE:
The system creates a temporary hash administration for the table to find the entries. This means that the runtime
required to find them does not depend on the number of table entries. The administration is temporary, since it is
invalidated by operations like DELETE, INSERT, MODIFY, SORT, ...). A subsequent COLLECT is then no longer independent of the table size, because the system has to use a linear search to find entries. For this reason, you should only use COLLECT to fill standard tables. U
- SORTED TABLE:
The system uses a binary search to find the entries. There is a logarithmic relationship between the number of table
entries and the search time.
© 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
|
|
ABAP is basic (technical) side of SAP. which helps other function of business sibe ex.financial,sales,inventory& human resource.
|
|
Cluster index work as a primary key and as we know in a single table only one primary key should be there....Hence only one records can take cluster index.
|
|
Select Employee.*, Department.* from Employee LEFT OUTER JOIN Department ON Employee.EmpId=Department.DeptId
|
|
Both are the connection object but SQLCLIENT using while connect with Sqlserver database and OLEDB using while connect with MS-access database and Oracle database.
|
|
Only 1 cluster index and 255 non cluster index.
|
|
Because it's used to read the data from the DB as Read-only manner, only forward direction not backward..hence its not supporting edit operation.
|
|
I will throw my wife because if my wife dies ican get another but mother is only one I cannot get another
|
|
When mistake is found by compiler is known as ERROR , when a mistake is found by tester while testing is a BUG and when mistake is found by the end user it is known as DEFECT.
|
|
Create customer code & transporter code, create sales order, checke the payment received then released order from Finance, delivery, billing, invoice.
|
|
Invoice is a request sent by vendor for the payment against services/goods with all the necessary details like - Price, Rate, Quantity, Vendor Name, Vendor Address, Unique Invoice Number (From Vendor), Terms & Conditions.
|
|
Rating
(0.0) By 0 users
Added
Views
Rate it!