Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 8851 Views
- SAP Labs, I also Faced
- E-Mail Answers
Answer Posted / vkbpl6012
In my opinion, the correct answer is
E: NE invalidates the use of an index
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How can we omit a leading sign and a leading zero in sapscript?
What are the different abap/4 editors?
Under Data Transfer Portion of ABAP, what do you mean by DX Project
What is the basic difference internal tables and database tables? : abap data dictionary
How will you read from internal table records in a given value range (without using loop)
Give an example of interface from your project explaining why you used it?
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
What is the t-code to display batch input sessions? : abap bdc
What are null values? : abap data dictionary
Final class
What is the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary
SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
What is filter dependent BADI?
Difference between .Include and .append?
