skip to main content

SAP NetWeaver Newbie

SAP XI: SQL Queries to Check Messages in AFW

Number of Messages by Status:

select status, count(1) as
current_number from sap[sid]db.xi_af_msg
group by status;

STATUS CURRENT_NUMBER
------------ --------------
DLNG 20
DLVD 460529
FAIL 19
NDLV 17
TBDL 64

Messages With a Particular Status (ex: NDLV):

select count(1) from
sap[sid]db.xi_af_msg
where status like 'NDLV';

COUNT(1)
----------
17

Messages Processed after a Certain Time:

select * from
sap[sid]db.xi_af_msg
where sent_recv_time > [time]
and node = [node id];

These tables don't seem to exist in PI 7.1 with the same name


Edit:
BC_MSG is the table name in PI 7.1. Thanks to JustMe for providing the table name.

2 comments:

  1. Hello,

    It tried to turn it off and on again :)

    The same table in PI 7.1 is BC_MSG

    ReplyDelete

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.