topic Re: regarding BDC in Application Development and Automation Discussions

regarding BDC

Former Member — Thu, 03 Jul 2008 09:45:35 GMT

if i want to upload more no of data, which method is preferred?...whether session method or call transaction?...if call transaction i choose, how can i face the error if occurs?

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 09:47:24 GMT

For error records use BDC , and then handle using the SM35 transaction.

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 09:52:42 GMT

Hi subhash.

Go with session method if you have huge amount of data... regarding errors you can check in sm35 in session method and in call transaction you have structure bdcmsgcoll

regards

padma

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 09:53:58 GMT

Hi,

my question is, to upload more no of data, which methid is best? and while any error occurs during the uploading how do we know that in call transaction method?

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 09:56:39 GMT

you can go for combination

if any error occurs add the error record to session, else process the record using call transaction method.

you can find the successfull ness of the call transaction using sy-subrc accordingly you can code.

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 09:58:50 GMT

hi subhash...

The combination is always termed as best.

And regarding error handling in call transaction... i guess you posted another thread ... just go through that... you will get your answer

regards

padma

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 10:01:08 GMT

In Call Transaction we have handle the errors explicitly.

means put messages into BDCMSGCOLL and call the function FORMAT_MESSAGE

pass the messages int table in the function module.

Then LOOP the Int table, using case when MSGTYP = 'E',

we can print the errors.

Hope this will help u lot..........

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 10:07:13 GMT

Hi,

In BDC Call Transaction method to handle the errors we are declaring a internal table like

DATA : IT_MESSAGES LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.

CALL TRANSACTION 'MM01' USING IT_BDCDATA MODE 'N' UPDATE 'S'

MESSAGES INTO IT_MESSAGES.

IF SY-SUBRC 0.

Using the FM 'FORMAT_MESSAGE' by passing the message no, and message id we can change the error message into a text format.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = SY-MSGID

LANG = '-D'

IMPORTING

MSG = V_MESG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

LOOP AT IT_MESSAGES WHERE MSGTYP = 'E'.

WRITE : / 'Message :'(I06) ,V_MESG.

CLEAR IT_MESSAGES.

ENDLOOP.

ENDFORM. " ERROR_MESSAGES

Hope this helps you.

Reward points if helpfull.

Thanks & Regards,

Y.R.Prem Kumar

Re: regarding BDC

Former Member — Thu, 03 Jul 2008 11:09:03 GMT

Hi ,

I have more no of data in my excel sheet like 10000 data...now how to upload it into SAP...I have to decide BDC or LSMW method..if its BDC, which method would be preferable ie.,Session method or call transaction method? and the reason behind that