i have to fetch the data based on non primary key field from a pooled or clustered table, but for pooled and clustered tables we can't create secondary index then to achieve the performance what to do?
Answer / marek
I assume this question is not about SAP HANA, but the old fashion data bases.
You should avoid selection from cluster data base table. The better way to do this is to use base tables. For example if you want to select data from BSEG table you should use "lower level" tables like BSAK BSIK BSAD BSAK etc.
Also to achieve this you can use standard function module or some kind of BAPI designed for this purpose.
As always you should remember to use optimized WHERE part of the query and WHOLE key in exact the same order like it is in data base (of course this optimization practices can only be applied to one type of DB, Orcale and MS have different ways to optimize the SELECT statement). Additionally you should one import fields you need to, trying to avoid the '*' usage as much as possible. Using FOR ALL ENTRIES and INTO CORRESPONDING FIELDS is not efficient as well.
Is This Answer Correct ? | 0 Yes | 0 No |
how to print barcode in vertical manner
Dear Experts pls answer the folowing qs that i have faced in the recent intvws: a) Can we execute the script individually? If yes How? Else what we need to do so? b) Are Layout sets Client independent? c) How do you assign a print program to a script? d) Can we call a subroutine in a script? If so, how? e) What are the steps to print SAP script form?
WHAT IS TCODE TO CREATE NEW MESSAGE TYPE?
why Transaction Varient needed?
How to debug a smart form?
5 Answers IBM, Mind Tree, TCS,
How will you decide whether to use implicit enhancement or explicit enhancement?
I am trying to automate a manual processing of iDOCs in BD87. I used the following code to pass idoc-id to global variable 'DCN' and then skip the first screen of BD87 to go to processing directly. After running this code SET PARAMETER ID 'DCN' FIELD itabhdr-idoc_id. CALL TRANSACTION 'BD87' AND SKIP FIRST SCREEN. it takes me to the first screen because it cannot recognize my idoc-id. How I can pass idoc-id to global? I have used the above code to goto VA02 with VBELN and it worked perfectly.
What are domains and data element?
Menu painter?
Explain what are the steps in the SD process at least up to the invoicing stage?
How can end-of-selection be used?
What are multiple use BADIS?