what we have to do in st05 and se30?
Answers were Sorted based on User's Feedback
Answer / sravan
These transactions are widely used in performance tuning of
any program.
We use ST05 tcode to SQL trace. we use SQL trace to analyse
the time consumed by various select statements in program.
If any select statement is taking long time to retrieve data
from Database, we can re-look into that and make necessary
changes.
We use SE30 for runtime analysis. This is for overall
evaluation of program. By using this, we can know about time
consumed by various processes (dialog,select) .Best practice
is make the time consumed by SQL statements very less.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / akram
sto5 is sql trace
se30 is runtime analysis used to exmine the performance of
an abap-program,transaction and functio;n module.
when we activate sql trace we can find out how many tables
are updated when we perform a transaction.
Is This Answer Correct ? | 3 Yes | 2 No |
What is modularization and its benefits?
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
What happens if a function module runs in an update task? : abap modularization
Explain the difference between domain and data element? What are aggregate object?
If you write a write statement after end-of-selection, will that be triggered ?
Please List ALL Events in Interactive Report & Classical Report in CORRECT ORDER.
create a Report to print Stock & Valuated Stock for Plant (ALV Grid) Selection Screen Ranges: Material Number (MARA-MATNR) Material Type (MARA-MTART) Valuation Class (MBEW-BKLAS) Storage Location (MARD-LGORT) Parameter filed plant (MARD-WERKS) Selection condition: Total valuated stock – MBEW-LBKUM – should be greater than zero Table to be used MAKT,MARD,MBEW,MARA,T001L.. (Use inner joins) Display output: Storage location: (TOO1L-LGORT) Description (T001L-LGOBE) Material No (MARA-MATNR), Material Description (MAKT- MAKTX), Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), IF MBEW-VPRSV = 'S'. Price – MBEW-STPRS ELSEIF DTAB-VPRSV = 'V'. Price – MBEW-VERPR. ENDIF. Subtotal of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), Grand Total of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), In the ALV grid display keep a button in the tool bar which on clicking navigates through the screen to the next grid which displays the grand total. Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button.
D/b view?
what is a field symbol?
How do you read a LOCAL Sequentional file
As an ABAP developer, how can we check after we release our object as to where has it reached(i.e. testing client box ,production client box etc)? In case it is not possible please let me know the same.
what is the diffreence between sap memory and abap memory plz give the example