on 04-23-2008 7:10 AM
hi abap experts, i have some doubts regarding abap general.
1. A standard table was already bufferd from the technical settings, but i don't want to use buffer when i reading data from that table.How can i avoid buffer for this table?
2. I maintained a log file in CALL Trancastion method and tranfered error records into one table when error occurs i,e MSGTYP = 'E'.I want to know what are the possible errors in that error record.i don't want to check error record table each time when i executed the program,how can i maintain logic to rectify the error automatically?
HI,
uase bypassing buffer along with select query
like
select ...... bypassing buffer.
the error table declataion is as
data: begin of it_error occurs 0,
text1 type string,
end of it_error.
DATA : IT_MESSAGE type table of BDCMSGCOLL WITH HEADER LINE.
for the error messages try like this
CLEAR IT_MESSAGE.
read table it_message WITH KEY msgtyp = 'E'.
IF SY-SUBRC = 0.
CALL FUNCTION 'FORMAT_MESSAGE'
EXPORTING
ID = it_message-MSGID
LANG = '-D'
NO = it_message-MSGNR
V1 = it_message-MSGV1
V2 = it_message-MSGV2
V3 = it_message-MSGV3
V4 = it_message-MSGV4
IMPORTING
MSG = V_MSG
EXCEPTIONS
NOT_FOUND = 1
OTHERS = 2
.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
it_error-text1 = v_msg.
append it_error.
clear it_error.
ENDIF.
loop at it_ERROR.
write: / it_error-text1.
endloop.
regards
prasanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1.use " bypass buffering "
select.....................................bypassing buffer .
... BYPASSING BUFFER
This addition causes the SELECT statement to avoid the SAP buffering and to read directly from the database and not from the buffer on the application server.
I am sure about this 100%
2.In call transaction method use format_message function module to format errors .
move into one table download that table into display.
then you can check .
reward points.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.