Table USR02

[Former Member]

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.

[nabheetscn]

Hi Gururaj

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

Thanks

Nabheet

[former_member202771]

ABAP query we write are open Query.

Which are client dependent.

At OS level tables are Native Query, client independent.

[VijayCR]

Hello Please check the below link.

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

Thanks,

Vijay.

[former_member219162]

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.

[matt]

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

Thread locked.