search material in payload

[Former Member]

I have 1000's of IDOC (same idoc, message type, same interface) in SXMB_MONI.

How do I search for material name in the payload to find corresponding IDOC and the payload contents?

It is difficult to open each message from SXMB_MONI and search the payload with the material name.

I'm looking for search functionality to payload of same interface. Please help.

Thanks.

[Former Member · Accepted solution]

Hi,

You can do this

1) goto WE09---give direction as 1,give Logical Message, give Search in Field ... as segment name in which the MATNR present , give for Value as MATNR NO. then press execute

you will get the Idoc No.

2) Copy this Idoc No and goto IDX5---give Idoc No and execute

3) You will get the right one which u r searching for and check the payload

REgards

[Former Member]

I read the suggestions, it was useful will try the same. Thanks for the input. Awarded points as well.

[Former Member]

Hi Ravi,

I would suggest one more approach.

Its always better to find the IDOC from ECC side insted of searching it in PI.

In ECC, you can use WE09 to find a IDOC number for corresponding Material and then that IDOC number you can check in SAP XI IDX5 to check if it is processed or not.

-Gouri

[Former Member]

IDX5 will not solve as the IDOC number is not known either.

I'm going to try Michal suggestion:

use CLASS "cl_xms_persist_adm".

1) use date and time as input

method "select_msg" will get all message_id in PI for that day

2) method get_xi_payload will get the payload (input is message_id)

3) see if payload contains the material, repeat the check for all payloads (step 2 to 3)

4) display all payloads if it contains the material

[former_member204873]

hi,

For searching in the payload based on some field, you can also refer to this Blog:

/people/sravya.talanki2/blog/2006/02/21/abap-based-trex-in-xi-proto

forum:

Thanks.

[MichalKrawczyk]

hi,

there are many way you can go:

1. trex - for indexing XI messages - not very efficient but works

2. you can create your own SXI_MOINTOR that will allow searching by payload (at least two examples in blogs in SDN)

3. you can also use the new message search based on xpath from EhP1 of PI

I'd suggest option 2 for you if you want to have it quickly

Regard,

Michal Krawczyk

[NikiScaglione]

Hello,

I'm trying to figure out approach number 3 (you can also use the new message search based on xpath from EhP1 of PI), but I guess it's only for messages passing adapter engine and not integration server?

Can you please clarify this topic?

Thank in advance,

Niki

[prateek]

Hello Niki,

I was going through the document below and it is mentioned that this option is for messages from both Integration Server and AAE.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a8defd-e400-2c10-faaf-8049d83d1...

Regards,

Prateek

[NikiScaglione]

Hello,

I'm already testing successfully user-defined search of messages from AAE, but I'm not able to do the same from IS.

I'm checking any eventually missing configuration step.

I have just solved configuration issues and tested message search on IS as well.

Kind regards,

Niki

Edited by: Niki Scaglione on Feb 19, 2010 2:42 PM