Answer / rahul singh

1. Don't use the followings :-
a. loop within loop.
b. select endselct.
c. Occur (statements)
d. Move corresponding.
e. use of cluster tables.
f. use select * (all feilds)
g. use of OR statement in select statement.
h. use of negative conditions.

2. Use the following :-
a. loop with reads if needed to be read multiple time.
b. Use of IN statement in select statement instead of OR.
c. use of maxium key feilds with select statement.
d. use of function modules instead of select statement
if it is available.

Answer / muralitharan

Additional to above points,

In select query Use For All Entries while pulling data from
database.

Frequently don't use inner join in your program

While Looping create work area and process the record

These are some points to improve performance of program

Answer / jc

1. Clear understanding of requirement.
2. Construct the how-to before actual coding starts.
3. Avoid using multiple read to the same database table.
4. Make sure to use indexed field while reading to database table.

can any one tell me if i will put mode as error(E) in session or call transaction for at background and if any error data is there in flat file , then what will be happen ,

1 Answers  

---

How many secondary indexes can we create in a table?

0 Answers  

---

Which method of BDC’s would u apply ? Session or call transaction ? why ? Which is more good ? Its advantages ?

1 Answers  

---

what is Composite key in table creation? what is the use?

1 Answers   Wipro,

---

What are the differences between table and structure in data dictionary?

0 Answers  

---

What is the transaction code to display the payroll results

2 Answers  

---

i have 3 screens say S1,S2,S3 and i want to validate only S3.What code shud i write in the flowlogic of the screen??

2 Answers   Siemens, Tech Mahindra,

---

what is direct input method?

1 Answers   Keane India Ltd,

---

how to add a field to existing TMG with out deleting that TMG. tmg over riding techinique.

1 Answers   Cap Gemini, L&T,

---

what is session and what is the use of that one?

2 Answers   Keane India Ltd,

---

B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.

0 Answers  

---

what are the events in lsmw?

3 Answers   Satyam,

---