Skip to Content
0
Sep 28, 2020 at 01:45 PM

How to query all SAP B1 users from OUSR table without deleted users?

103 Views Last edit Dec 10, 2020 at 07:16 AM 2 rev

Hi all,

How can I display users of SAP B1 in query without deleted users

I tried to query them but I got all users mixed with deleted users

My sample query is below

SELECT * FROM OUSR T0

I need condition which will remove deleted users in my list

Please anyone can help me