Table ztest has a secondary index on the following fields: tnum, tcode. Select * from ztest where tnum ne '123' and tcode = '456'. Why is the index not used in the above case? Choices: a) Indexes are not allowed on Z tables b) Variables must be used, NOT literals c) Select individual fields, not select * d) Client is not in the where clause e) NE invalidates the use of an index Info: Can someone explain in detail why this happened? It will be really helpful to handle to case in Secondary index:
2 8840In Open SQL statements such as Insert update delete which one is FASTlLY retrieve the results and which one is Efficient?
4 11024Function Module to upload the Excel sheet into SAP Internal Tables. * a) GUI_UPLOAD b) CL_GUI_FRONTEND_SERVICES=>GET_UPLOAD_DOWNLOAD_PATH c) CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD d) All the above
2 19947Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
2065By default SAP provides locking mechanism if db is being used by a user ,then what is the use of writing enque method in your code?
1 4850Post New SAP Labs SAP ABAP Interview Questions
How can we optimize a sql query?
What is a Record Owner?
What is sequential search?
Which is the landing craft used by armstrong on the moon?
Explain intent component of android?
Which metrics should I track for email marketing?
How can users add to label the values of individual chart elements?
What mail program comes with windows 10?
what is a deadlock? : Sql server database administration
Explain what is clr?
What is the testng.xml file used for?
what is the space filled with in between the cell membrane and the cell wall when the cell is plasmolysed ??
How do I restart my start menu?
What type of code is found in a code-behind class?
Why it is a preferable option in parallelextender development ?