topic Re: report which shows session method BDC log in Application Development and Automation Discussions

report which shows session method BDC log

SwarnaliBasu — Wed, 15 Jul 2009 19:14:38 GMT

i want to create a report which shows the log of BDC session method of failed transactions, the report will also show the incorrect fields of the transaction, this program must be in the form of report and the input is session name as in SM35.

please note: the program should not use table control, and the error should be downloaded as a flat file.

<<text removed>>

Regards

Swarnali Basu

Edited by: Matt on Jul 22, 2009 3:49 PM - don't offer points

Re: report which shows session method BDC log

Former Member — Wed, 15 Jul 2009 19:20:43 GMT

Hello,

What do you need? the full source code??, call your abap team to do it.

Bye

Re: report which shows session method BDC log

SwarnaliBasu — Wed, 15 Jul 2009 19:25:41 GMT

thanks for your reply but its hardly of any help, i have developed a part of it but i cant download the error file to flat file, if u have any fruitful suggesstion then post else please do not write.

Regards

Swarnali

Re: report which shows session method BDC log

Former Member — Wed, 15 Jul 2009 19:29:01 GMT

Hello Again...

Your post wasnt clear...remember to be more specific on your post....anyways....if you need to download an internal table to your hard disk use this FM as follows:



CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      filename                = file_tab
      filetype                = 'ASC'
      write_field_separator   = 'X'
    TABLES
      data_tab                = your_it_table
    EXCEPTIONS
      file_write_error        = 1
      no_batch                = 2
      gui_refuse_filetransfer = 3
      invalid_type            = 4
      no_authority            = 5
      unknown_error           = 6.

bye

Re: report which shows session method BDC log

SwarnaliBasu — Wed, 15 Jul 2009 19:36:42 GMT

Thanks again

but i knew this FM, what i am looking for is i want to capture those field name and field value which is shown when a session fails in SM35, these field name and field value should be downloaded in a flat file, ultimately may be i have to use this FM, but how do i capture in the 1st instance.

1. go to SM35.

2. Analyse a failed session

3. Check the number of incorrect entries

4. you might find fields like KUNNR (field name) and the field value(more than 1).

then i want the output in the flat file as

KUNNR(field name) ....

5(field value)....

i hope this makes my ques clear.

Re: report which shows session method BDC log

Former Member — Wed, 15 Jul 2009 19:45:29 GMT

Swarnali,

You may check the DB table APQI ( Queue info definition) in SE11 , In this table , the error sessions holds the status as E for incorrect processed sessions ( QSTATE Queue status ) for the corresponding session name ( GROUPID Group name: Batch input session name ). You can retrive the error records from it.

In order to find the screen fields details for erred session , Click on session name , It takes to details session details , go to screen( Tab) ,it just show the error screen ,not fields . In know the fields , there is a button on right side top (Field list).

U may debug it to find the table for this. Combine the results of previous query with this

I hope , it gives some info.

Regards,

Santhosh

Re: report which shows session method BDC log

SwarnaliBasu — Thu, 16 Jul 2009 07:42:31 GMT

even if i take the filed QSTATE from table QID, how do i get the fields name and field value, i have got the internal table from the program RSBDC_ANALYSE but it uses table controlhowever i m using aa report so how do i match those? can u help me with a sample code if possible?

Re: report which shows session method BDC log

Former Member — Thu, 16 Jul 2009 07:55:47 GMT

Hi,

Make use of the following FMs

RSTS_GET_ATTRIBUTES

RSTS_OPEN_RLC

RSTS_READ

RSTS_CLOSE.

Check the program RSBDC_PROTOCOL.

Regards,

Ankur Parab

Re: report which shows session method BDC log

Former Member — Thu, 16 Jul 2009 21:48:05 GMT

Hello Swanali,

I think, We are closer to the solution.

As u have found in the program RSBDC_ANALYSE, there is an internal table all_bdc_dynpro

which gets filled with the records of screen fields details.

If you put break point in the subroutine <b> scan_transaction and scan_dynpro </b> and see as how all_bdc_dynpro is filled ,

u would how how all_bdc_dynpro is filled.

Key code point :

APQD - table U get all you want

In subroutine <b>scan_dynpro</b> , you see how the data is moved

I believe , you would it up based on this input

Regards,

Prabu

Re: report which shows session method BDC log

SwarnaliBasu — Tue, 21 Jul 2009 10:31:06 GMT

i have solved the issue by my own....thanks to all who have tried to help

Re: report which shows session method BDC log

Former Member — Tue, 21 Jul 2009 20:32:01 GMT

Swanali ,

Can u just share with us as how you have solved the problem ,It would help us in future .

Thanks,

MVP

Re: report which shows session method BDC log

SwarnaliBasu — Thu, 23 Jul 2009 05:39:59 GMT

i am editing the program a bit, as soon as i complete i will surely let u all know