difference between primary index and secondary index.when we
use secondary index in reports?
Answer Posted / sivaramakrishna
when we want to get the details based on a field in select
statement we should use always primary key fields to
improve the performence. but in any case needed to get
detais based on non primary key fields then we go for
secondary index . ie based on which non primary key fields
we need to fetch the data using select st for those fields
we create secondary index in sell.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
When the get cursor command used in interactive lists?
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.
What is the function of a domain?
What is at exit-command:?
What is table pool?
What is pretty printer?
How to create any functions? How to go about it?
What are the check tables and value tables?
What are the names of the function modules that will be generated upon activation of a lock object?
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
What happens if a function module runs in an update task? : abap modularization
In which particular scenario we use sorted table and which particular scenario we use standard table?
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
What is the purpose of at first and at last?