BDC batch input Log status

[Former Member]

Dear all ,

Through FF67 am executing BRS run by entering few incoming and outgoing line items . Then its generating a Log in SM35. Then it is processed in Background Mode.

Suppose there are 10 line Items entry . Out of that 3 line items are generated as eroneous in SM35 and 7 line items are correct.

So my problem is i want to pick these eroneous line items and have to show in a custom Zreport .

How can i do it ? In which Table these eroneous entries are stored ?

Thanks in Advance

Jack

[Former Member]

Hi,

The Log created for the particular process is stored in table BDCLM you can get the success and the errors from the field MART.

Thanks,

[Former Member]

But the table u hav mentioned are structures (BDCMSGCOLL , BDCLM).

My requirement is like below :

Suppose 10 Line items am processing in background mode in SM35. and out of these 3rd , 5th and 7th line items are erroneous.

In which table the status of the line items are stored . means for 3rd,5th and 7th line item -> status will be Error and for other line items it should be Cleared.

Then only it will be easy for me to show the status of line item in my Zreport.

Thanks a lot for ur earlier responses.

[Former Member]

Hey Jack ,

While you are using a session method you can find out the errors in the following ways :

1. Go for 'E' mode and his displays only the errors and gives you a chance to rectify it .

2. If you going for a backgroud processing in session , you get a detailed list of errors like wher you have made it etc .

3 . Now since you want to use it in your ZREPORT you can get the messages and log of the the session from the table BDCLM .

4. Or you can you the table BDCMSGCOLL to cature the messages from fields (sy-msgv1,v2,v3,v4) and use it in your reports .

Hope it helps!

Much Regards ,

AMuktha .

[Former Member]

Hi ,

You can try with APQD and APQI table .

Regards

Pinaki Mukherjee

[Former Member]

Hi,

If u want to maintain message log in your program, u just call a funtion module

'FORMAT_MESSAGES'.

It holds the each and every msg.

and before u have to declare the msg table i.e. BDCMSGCOLL

Example

data:

t_bdcmsgcoll type standard table of bdcmsgcoll.

and then call funtion module......

Regards

Kiran

Edited by: Kiran Saka on Feb 5, 2009 7:56 AM

[viquar_iqbal]

HI,

Use this program RSBDC_ANALYSE give input as Qid and it would give all the error messages

Thanks

Viquar Iqbal

[Former Member]

Hi,

In your BDC program,you have to use an internal table having structure like BDCMSGCOLL,

which will capture all the messages of your bdc executed.

Then on that internal table,you can use READ TABLE statement with type = 'E' and move all those

error messages into another internal table.

And for that message number got captured in BDCMSGCOLL like structure internal table,

you can call then a function module

FORMAT_MESSAGE to capture the whole description of that error message.

Search on SCN you can find links on this kind of problem.

Hope it helps you

Regrds

Mansi