topic Table USR02 in Application Development and Automation Discussions

Table USR02

Former Member — Mon, 28 Oct 2013 12:07:35 GMT

Hello,

If i use select query in ABAP on table USR02 in client(202), it displays results of only client 202(mandt).

But if the same query is run on OS level, the same table USR02 displays all the clients like 200, 201, 202 etc.

Let me know why these two queries behaving differently in ABAP and in OS level.

Regards,

Gururaj.

Re: Table USR02

nabheetscn — Mon, 28 Oct 2013 12:09:00 GMT

Hi Gururaj

One small question how do you run your query at OS level?

Thanks

Nabheet

Re: Table USR02

former_member202771 — Mon, 28 Oct 2013 13:00:24 GMT

ABAP query we write are open Query.

Which are client dependent.

At OS level tables are Native Query, client independent.

Re: Table USR02

VijayCR — Mon, 28 Oct 2013 13:12:42 GMT

Hello Please check the below link.

https://scn.sap.com/thread/744280

Thanks,

Vijay.

Re: Table USR02

former_member219162 — Mon, 28 Oct 2013 13:21:45 GMT

Hello Gururaj,

When you use a Select query using ABAP from SAP login, whether you mention MANDT or not in the select query, automatically at the select statement, if it is a client Dependent table, SAP adds up in the DB process to fetch only the data that is present for the login client.

When you are running a direct database command, let's say in Oracle Console for the same SAP tables, unless you specify explicitly the Client field, all records would be pulled from Oracle database for the table.

Re: Table USR02

matt — Mon, 28 Oct 2013 14:16:01 GMT

I suggest you do some reading on what "client" means in SAP terminology.

Thread locked.