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 7535In Open SQL statements such as Insert update delete which one is FASTlLY retrieve the results and which one is Efficient?
4 9274Function 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 17979Hi 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.
1571By 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 4046Post New SAP Labs SAP ABAP Interview Questions
What is build pipeline in jenkins?
Tell something about the history of dojo.
What do the master class and the output class do?
How to provide login information for a new odbc dsn?
How to check the date in unix?
What is transaction management in spring? Explain the different types of transaction management.
What are the different types of Machine Learning?
What is web service in python?
Which property of matrix gives the total number of rows in the matrix ?
Does crystal reports can be built on top of UDT?
What are the disadvantages of angularjs?
What is a Block Scanner in HDFS?
Explain what is the use of reference and service user in sap?
What is root device path?
Describe CDMA with one of advantage?