What is INDEX Concept. What is Primary Index and Secondary
Index and Difference between Primary & Secondary Index
Answer / uma mb
Index on a table or indexing a table can speed up record
access in the table. Index is a copy of the database table
but in its reduced form (only certain key fields exist in
the index along with a pointer)The data stored in the index
is in a sorted order of the primary key in a primary index
and secondary (alternate) key in a secondary index.
Primary index is automatically created when the table is
activated after creation. A secondary index is created
manually (by ABAP developer or admin person as per dictates
of the workshop) if it is felt that a large table is
accessed too many times based on some field (like employee
name in the EMPLOYEE MASTER) or fields that do not
participate in the primary key formation.
It is possible to specifiy while creating secondary index if
this index should be created on table activation. And then
these secondary indexes can give a performance gain only on
certain database systems and therefore these database
systems can be specified while creating the secondary index
so that such an index is created only on those specific
database systems. Also user created secondary indexes must
begin with Y or Z and can have three character position
names. Must not use 0 (zero) as this is reserved by SAP for
primary index.
Is This Answer Correct ? | 28 Yes | 5 No |
create a Report to print Stock & Valuated Stock for Plant (ALV Grid) Selection Screen Ranges: Material Number (MARA-MATNR) Material Type (MARA-MTART) Valuation Class (MBEW-BKLAS) Storage Location (MARD-LGORT) Parameter filed plant (MARD-WERKS) Selection condition: Total valuated stock – MBEW-LBKUM – should be greater than zero Table to be used MAKT,MARD,MBEW,MARA,T001L.. (Use inner joins) Display output: Storage location: (TOO1L-LGORT) Description (T001L-LGOBE) Material No (MARA-MATNR), Material Description (MAKT- MAKTX), Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), IF MBEW-VPRSV = 'S'. Price – MBEW-STPRS ELSEIF DTAB-VPRSV = 'V'. Price – MBEW-VERPR. ENDIF. Subtotal of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), Grand Total of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), In the ALV grid display keep a button in the tool bar which on clicking navigates through the screen to the next grid which displays the grand total. Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button.
What is img? : sap abap hr
What is the difference between normal report program and module pool program?
3 Answers Atos Origin, Kaavian,
Which method of BDC’s would u apply ? Session or call transaction ? why ? Which is more good ? Its advantages ?
what is the status code when IDOC is created?
Pls someone answer me this, Can we acheive everything using OOPs? If not? What cant be acheived? Have you encountered any scenario liike, you cannot acheive it using Function modules & can be acheived using Oops? What is the advantage of BADI over UserExit? Difference between BAPI and RFC? Thanks in advance.
How will you decide whether to use implicit enhancement or explicit enhancement?
What is the maximum number of structures that can be included in a table or structure : abap data dictionary
How do you convert non-char field into char type fields ?
what is difference between rfc and bapi
can onyone tell me , how many data classes and size categories are there ?
Explain what is sequence of event triggered in report?