FM to read Cluster table SXMSPCLUR and SXMSPCLUS.

[Former Member]

Hi Experts,

Does anyone know the FM to read data of payload stored in cluster tables SXMSPCLUR and SXMSPCLUS.

I want to read the XML data and delete the entries from these cluster tables.

Regards

Milan Shah

[Former Member]

Hi,

there is no function module for this, you have to use class methods.

Have a look at this wiki I posted: [Massive proxy errors monitor |https://wiki.sdn.sap.com/wiki/display/Snippets/Massiveproxyerrors+monitor] where I read the message payload.

Regards,

Sergio

[Former Member]

Hi Sergio,

I have seen this Wiki...But i want to read the messages that are not yet processed.

I want to check the values before processing the queues.

Regards

Milan

[Former Member]

Can you explain you requirement?

BTW messages that are not yet processes just have a different status in SXMSPMAST.

Regards,

Sergio

[Former Member]

Hi Sergio,

We receive same messages multiple time.

I have to write a program to delete these messages from the queue that are already processed once.

I have to compare the order id for this.

Regards

Milan

[Former Member]

Hi,

I expect that the order id is a custom value/field, why don't you do an enhanced received determination for this?

if the message should not be processed then do not assign a receiver and flag "terminate message".

Regards,

Sergio

[Former Member]

goto se11.give table name then click on where used list ,choose function module radio button from the list displayed

you will get to know In which function module the particular table is used