It is common knowledge that buffering of database tables improves the system performance, provided the buffering is done judiciously – i.e. only those tables that are read frequently and updated rarely are buffered. But how exactly can we determine i...
Hello Experts,I have a question regarding the COMMIT WORK statement when the underlying database is HANA.My observation has been - when the underlying DB is MS-SQL, a statement like - INSERT dbtab FROM wa does not need a COMMIT WORK statement after t...
Hello Experts,My question is regarding the "Character Strings" check of Extended Syntax Check (SLIN). Say you have a code like:DATA: GW_VAR(20) TYPE C.GW_VAR = 'X'. When you check this on SLIN (make sure that the "Character Strings" checkbox is check...
Hello Experts,What I want to achieve is - create a tabstrip with 2 tabs in a std selection screen. When tab2 is displayed, I should have 2 buttons in the application toolbar of the std selection screen. When tab1 is clicked, these two buttons should ...
Hello Experts,I am not very clear with regards to the "Table Buffer Trace" of ST05. Firstly, I considered the following cases:Case 1:DO 3 TIMES. SELECT * FROM DARTT ""DARTT is a fully buffered table with 514 records I...
Hi Denis,You probably might have found a solution by now, but just wanted to share my knowledge with the community. Please refer to the SAP Note: 2215852. The note says the following:“Structures used in the interfaces of BAPIs and released RFC module...
Hi Anusha, The documentation says the following:"Unlike the statement READ TABLE with a free key specified, no binary searches can be forced for a table expression and it is not possible to specify explicit table key for optimizing searches using sec...
Hello Yunus, Before I address your specific question, I would like to draw the attention to some basic concepts. Say, the database table - dbtab is single record buffered. And it is queried for a record that does NOT exist, like primary_key1 = value_...
Hi Faaiez, Maybe you can use the statement - FIND ...IN TABLE....[{RESPECTING|IGNORING} CASE] The exact statement should be constructed like: FIND ALL OCCURRENCES OF 'aaa' IN TABLE itab IN CHARACTER MODE IGNORING CASE RESULTS DATA(result_tab). Sincer...
Hi Bill,Really appreciate your exhaustive list of links/resources.I just wanted to say that the link - http://www.experiencesaphana.com/servlet/JiveServlet/downloadBody/2171-102-4-4396/SAPHANA_TechnicalDocumentsV2.zipdoes NOT take me to a place where...