SAP Managed Tags: ABAP Development Hi Ashok, I have created secondary index on one field in VBAP table and I am using the same in where condition and can you tell me how can i use it probably like syntax. This isthe select statement SELECT vbeln posnr zz_icinvce pstyv INTO TABLE...
Syntax on using the Secondary keys You can use the Secondary keys on the statements LOOP, READ, DELETE, MODIFY, APPEND, INSERT. See below code lines for complete Syntax when you want to use the Secondary Key. When to Use Secondary Keys Some guidelines on when to use Secondary keys Secondar...
Each additional index therefore slows down the insertion of records in the table. For this reason, tables in which entries are very frequently written generally should only have a few indexes. The database system sometimes does not use a suitable index for a selection, even if there is one....