NEW INTERVIEW QUESTIONS.COM SAP R-3 INTERVIEW QUESTIONS SAP REPORTS INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

What is diffrence between ON Change of & At New Field?? Select Single * from & select Upto 1 rows

Answer

At new - on change of diffrence:Incase if you waana calculate sub totals for same values in a field you can use the at new statement.ie: for example in a table sflight there are 2 fields carrid ( airline id) and seatsmax( seat available). Incase if you waana calculate the total number of seats available for each carrrid you can sort the table first and using the atnew and sum you can claculate the total seats for each carrid. Atnew will be triggered whenever there is a change in the carrid and the total seats will be returned for each carrid.In the same scenario if you use onchange of it will not return the total seats for each carrid , instead it will return the total seat count for the entire table( ie: for all the carrids in the table.Another diffrence is at new can be used only between loop and end loop whereas on change of can also be used in select- endselect , do -enddo.Another diffrence is while using at new inase if you code any write statements between at new and end at the value for the numeric fields will be returned as 0 and that of no numeric fields will be returned as *(asteriks). But in on change of the orginal values will be returned.Select single * and select upto 1 row diffrence.The select single * from stmt selects only one row form the database table and puts it in to the work area(internal table).The select upto n(where n stands for a integer number) rows stmt selects all the rows from the database table but writes only the specified number of rows specified by the n into the internal table. If its given as upto 1 rows only 1 row is written in to the internal table. © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	SAP Reports Interview Questions
Rating	(0.0) By 0 users
Added	7/22/2006
Views	153781
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

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!
Email: