topic Re: BDC batch input Log status in Application Development and Automation Discussions

BDC batch input Log status

Former Member — Thu, 05 Feb 2009 06:11:17 GMT

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

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 06:31:12 GMT

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,

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 06:35:29 GMT

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 .

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 06:49:11 GMT

Hi ,

You can try with APQD and APQI table .

Regards

Pinaki Mukherjee

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 06:56:26 GMT

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

Re: BDC batch input Log status

viquar_iqbal — Thu, 05 Feb 2009 07:07:52 GMT

HI,

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

Thanks

Viquar Iqbal

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 07:13:16 GMT

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

Re: BDC batch input Log status

Former Member — Thu, 05 Feb 2009 07:17:55 GMT

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.