how to capture the errors BDC

[Former Member]

In Call transaction method, how to capture the errors ?

How to load data from MS Excel sheet to SAP by using BDC method ?

[Former Member]

capture error in call transaction -

---

>>>>>>

IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.

FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.

THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.

THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"

AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING

for uploading Ms Excel Sheet use fm -

---

>

KCD_EXCEL_OLE_TO_INT_CONVERT

[Former Member]

capture error in call transaction -

---

>>>>>>

IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.

FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.

THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.

THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"

AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING

for uploading Ms Excel Sheet use fm -

---

>

KCD_EXCEL_OLE_TO_INT_CONVERT

[Former Member]

needed some code for uplaoding excel sheet?

[Former Member]

• Add values to internal table

SORT t_cells BY row col.

LOOP AT t_cells INTO wa_cells.

MOVE : wa_cells-col TO l_index.

ASSIGN COMPONENT l_index OF STRUCTURE itab TO <f_value>.

MOVE : wa_cells-value TO <f_value>.

AT END OF row.

APPEND itab

CLEAR itab.

ENDAT.

ENDLOOP.

[Former Member]

In Call transaction method, how to capture the errors ?

CALL TRANSACTION 'FK01' USING IT_BDCDATA MODE 'A'

UPDATE 'S'

MESSAGES INTO IT_MESSAGES.

WRITe:/ SY-SUBRC.

PERFORM FORMAT_MESSAGES.

CLEAR IT_BDCDATA.

REFRESH IT_BDCDATA.

form FORMAT_MESSAGES .

DATA: L_MSG(100).

LOOP AT IT_MESSAGES.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = IT_MESSAGES-MSGID

LANG = SY-LANGU

NO = IT_MESSAGES-MSGNR

V1 = IT_MESSAGES-MSGV1

V2 = IT_MESSAGES-MSGV2

V3 = IT_MESSAGES-MSGV3

V4 = IT_MESSAGES-MSGV4

IMPORTING

MSG = L_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2

.

write:/ l_msg.

endloop.

How to load data from MS Excel sheet to SAP by using BDC method ?

use the FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Regards,

priya.

[varma_narayana]

hI..

1. To Capture errors in Call transaction:

Using BDCMSGCOLL Structure we have to declare an itab.

DATA : IT_MSG LIKE TABLE OF BDCMSGCOLL .

Then We can catch the messages using:

CALL TRANSACTION 'MK01'

USING IT_BDCDATA

MODE 'N'

MESSAGES INTO IT_MSG.

IF sy-subrc ne 0.

LOOP AT IT_MSG INTO WA_MSG

WHERE MSGTYP = 'E' OR MSGTYP = 'A'..

<< call the FM FORMAT_MESSAGE to get the Message text and display.>>

ENDLOOP.

2) To upload data from Excel:

use the FM GUI_UPLOAD.

<b>reward if Helpful</b>