topic Re: BDC Doubts in Application Development and Automation Discussions

BDC Doubts

Former Member — Tue, 18 Nov 2008 11:44:08 GMT

Moderator message: please use a more meaningful subject in future.

hi,

i am working on BDC,but i have some doubts:

(1) can call transaction BDC can be executed in background.if yes then how bcoz i tried to execute it in backgrond it got cancelled.

(2) if out of 20 records in the flat file ,10 records are uploaded and 10 are not uploaded due to error ,is there any way to display a log showing which all records are not uploaded.

Edited by: Matt on Nov 18, 2008 2:57 PM

Re: BDC Doubts

Former Member — Tue, 18 Nov 2008 12:01:28 GMT

call transaction method works in background also with MODE 'N'.

For error log :

Create the object and subobjects in SLG0. and see the log in SLG1

DATA: lt_obj_long_no TYPE STANDARD TABLE OF balnri.

CALL FUNCTION 'APPL_LOG_WRITE_MESSAGES'

EXPORTING

object = 'YCI346'

subobject = 'YCI346'

update_or_insert = 'I'

TABLES

messages = gt_messages

EXCEPTIONS

object_not_found = 1

subobject_not_found = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

CALL FUNCTION 'APPL_LOG_WRITE_DB'

EXPORTING

object = 'YCI346'

subobject = 'YCI346'

TABLES

object_with_lognumber = lt_obj_long_no

EXCEPTIONS

object_not_found = 1

subobject_not_found = 2

internal_error = 3

OTHERS = 4.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Re: BDC Doubts

Former Member — Tue, 18 Nov 2008 12:13:56 GMT

If you simply use write stmnt and write your msgs end of the program you can see those msgs in the log of the background job

Re: BDC Doubts

Former Member — Tue, 18 Nov 2008 13:08:29 GMT

hai..

1) can call transaction BDC can be executed in background.if yes then how bcoz i tried to execute it in backgrond it got cancelled

Ans..

We can execute call transaction BDC in background by simply

writing the statement call transaction <tcode> using <bdcdata> mode 'N'.

2) if out of 20 records in the flat file ,10 records are uploaded and 10 are not uploaded due to error ,is there any way to display a log showing which all records are not uploaded.

Ans..

declare one internal table ITAB with strucure BDCMSGCOLL and capture the error messages.

writing the statement "call transaction <tcode> using <bdcdata> mode 'N' messages into <ITAB>.

In this way we can easily capture the errors.

Use the FM FORMAT_MESSAGE also for analysing the error.

thanks and regards

sekhar.c

Re: BDC Doubts

matt — Tue, 18 Nov 2008 13:58:02 GMT

Please use a more meaningful subject in future.

Re: BDC Doubts

Former Member — Tue, 18 Nov 2008 15:01:31 GMT

hi,

when i am assigning mode 'N' to call transaction statement and executing in background ,then in SM37 tcode its showing 'JOB CANCELLED'.

Job log looks like:

Message text Message class Message no. Message

Job started 00 516 S

Step 001 started 00 550 S

Error during import of clipboard contents ALSMEX 037 A

Job cancelled 00 518 A

Re: BDC Doubts

Former Member — Tue, 18 Nov 2008 17:36:56 GMT

When uploading a file from presentation server, you cannot schedule it for background job. Only if the file is in application server, background job will run. So, the option you have is first import the file into application server and then call the file in the program and then schedule background job.

Regards,

Vishwa.

Re: BDC Doubts

Former Member — Sun, 23 Nov 2008 19:26:13 GMT

hi vishwa,

how to upload the file to application server and use it through code.i haven't done this before , can u help me out....does the uploading the file to application server can be done by coding or does any transaction exists for this.....

Re: BDC Doubts

Former Member — Sun, 23 Nov 2008 19:30:24 GMT

https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=howtodownloadfiletoapplicationserver&adv=false&sortby=cm_rnd_rankvalue