Tables without mandant!?

[former_member384574]

Hi experts!

Can anybody give me a list of the tables that are independent of mandant?

Thanks a lot,

Regards,

Rebeca

[harishtk1 · Accepted solution]

I am assuming you mean client independent tables.

Any table which does not have MANDT field as one of the keys is a client independent table. I do not believe anybody will have a ready made list of client independent tables. I made a quick check and came up with more than 58000 tables which are client dependent and possibly there is any equal number if not more that are client independent.

Why do you need this list?

[former_member384574 · Accepted solution]

Thanks a lot for your answers, I need that list because we are making an upgrade to 6.0 and we want to check differences between development and production sistem. I found this table through internet, DD02L, that more or less give us all the tables that are independent of mandant, but the problem is that I need those that are of HR module....

Any idea?

Thanks a lot

Best regards,

Rebeca

[Former Member · Accepted solution]

Hi,

You can compare tables across clients using transaction SCMP.

Donnie

[former_member384574 · Accepted solution]

Hi,

Yes, I know that the transaction that compare two system is SCMP, but the problem is that I want to check if 2 tables in the 2 differents system has the same entries and the same value...so I need all the HR independent table in both of the systems....

More ideas, please?

Thanks a lot,

Regards,

Rebeca

Edited by: Rebeca R on Feb 9, 2010 3:57 PM

[harishtk1 · Accepted solution]

A quick google yielded this, Any good?

http://www.sap-img.com/human/finding-the-list-of-hr-module-tables.htm

[sikindar_a · Accepted solution]

We had a similar requirement

a report has been developed by the abaper to fetch the tables which are haveing Mandt Feilds that is Client specific and Cross Client Tables

Check with your Abaper

Still problems let me know will let update you with the Code

[former_member384574 · Accepted solution]

I'm the abap programmer so please, if you have the code, can you send it to me or give me the important tables where I catch all the necessary information?

Thanks a lot,

[harishtk1 · Accepted solution]

Rebecca,, Have you checked the link I attached a couple of posts above? it does a large number of important HR tables?

[sikindar_a · Accepted solution]

Check the attachment

and this will help you to fetch the tables from the whole SAP ERP but not specific if you want specific you have use the Packages which were been used in HR module

[former_member384574 · Accepted solution]

Yes, I saw that link, thanks a lot for that, but it still haven't all the hr tables, haven't it? thinking about the programm I think the only way is something similar to DD02L table...

Thanks a lot for all your answers!

Rebeca

[former_member384574 · Accepted solution]

I can't see the attachement document.... Is empty!

[sikindar_a · Accepted solution]

sorry

Edited by: Sikindar on Feb 9, 2010 9:35 PM

[former_member384574 · Accepted solution]

Don't worry, but now, I can't find the file you send me before....where is it?

[former_member384574 · Accepted solution]

Sorry Sikindar, bu I can't still open that document...could you please paste here all the information?

Thanks again.

Regards,

Rebeca

[former_member384574 · Accepted solution]

Sikindar, sorry but I can't see that document....could you please send it again?

Thanks a lot,

Regards,

[sikindar_a]

Have you Tried this way

Go to SPRO - IMG -

There from the Menu Additional Information - Technical Data - Client Dependence now you will get the list of Mandat tables and non mandat tables

Still if you have problem please let me know there is a report for that which has to be developed i will let you know