Looking for XI_AF_MSG fields

[Former Member]

Hi there,

I am looking for "End of Execution from" "End of Execution Until" Fields name in Table: XI_AF_MSG, but I didn't found that field

is anyone know where and how to display these fileds...

basically I am trying to display sxmb_moni records through SQL using the date conditions such as:-

SELECT TRUNC(tran_delv_time) FROM sapsr3db.xi_af_msg WHERE TRUNC(tran_delv_time) = TRUNC(SYSDATE);

Your response will be really appricated with points

Regards,

[Former Member · Accepted solution]

Hi Angelina,

Could you please refer the sap note 823116 to see all the fields available in the table XI_AF_MSG.

can you use TRAN_DELV_TIME TIMESTAMP ? not sure if helpful but is there any way you can try modifying you query

SELECT * FROM sapsr3db.xi_af_msg WHERE TIME_STAMP < '2010-05-01 00:00:00'"; to display all .

Not very sure if it helps to meet your requirement

Regards,

Srinivas

[Former Member · Accepted solution]

XML messages: through

-

---

SXMB_MONI --> Integration Engine -->

End of Execution from 05/15/2010 00:00:00

End of Execution Until 05/15/2010 23:59:59

Shows (17) records

1. TABLE: XI_AF_MSG

-

---

select * from sapsr3db.xi_af_msg where trunc(tran_delv_time) = trunc(sysdate-2);

Shows (34) records

2. XI_AF_MSG_AUDIT

-

---

select * from SAPSR3DB.XI_AF_MSG_AUDIT WHERE trunc(time_stamp) = trunc(sysdate-2);

Shows (439) records

select * from sapsr3.SXMSPMAST

WHERE trunc(sendtimest) = trunc(sysdate-2);

Error messages

How do I check xml messages through SQL qureey...??????????????

[Former Member]

hi

you can use "SCHEDULE_TIME" with less than or greater than operators in SQL query

Regards

Ramg

[prateek]

See this

Regards,

Prateek