Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shreeshaildiggi
SAP buffering :
Buffering of data from database tables defined in a table
buffer in the shared memory of the current application
server. The definition determines whether and how a
database table is buffered. Buffering generally leads to
greatly enhanced performance (by a factor of between 50 and
500) and is administrated by the database interface.
Buffering usually becomes effective when Open SQL commands
are used for database access. However, some variants do not
use the buffering process.
The following Open SQL statements implicitly bypass the SAP
buffer and access the database tables directly:
SELECT with the addition FOR UPDATE,
Access to a table using single-record buffering without
selecting a single record using SINGLE SELECT or by
specifying the primary key in the WHERE condition (this
behavior depends on the current implementation of the
database interface and may be different in future
releases).
SELECT with the addition DISTINCT,
SELECT with aggregate expressions,
Open SQL statement with the addition CLIENT SPECIFIED,
without specification of the client ID in a WHERE
condition,
SELECT with JOIN expressions
Access to a generically buffered area without full
specification in a WHERE condition
Open SQL statements with IS [NOT] NULL in the additions
WHERE and HAVING,
Use of a subquery in a WHERE condition,
SELECT with the addition GROUP BY,
SELECT with the addition ORDER BY, whereby the sort key is
not the primary key.
Thanks and Regards
SHREESHAIL DIGGI
SAP Technical Consultant Infinite India
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between function group and function module?
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
Explain what is the step-by-step process to create a table in data dictionary?
Can i know some of the Realtime tickets that anyone has been faced ?
What is the difference between call transaction and session method? : abap bdc
What are uses of foreign key?
What are the different methods of passing data? : abap modularization
How many ways can a sap system be accessed?
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
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 is tcode se16?
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
after creating lock object if does n't access record by second user what should we do?
What does the insert statement in extract datasets do?
