How to find all HR tables which is directly or indirectly associated with Company Code(BUKRS)?

[Former Member]

Hello People,

I was trying to search how can i get all the HR tables which are directly or indirectly have connection with Company Code(BUKRS).

FYI- although i got the list of all HR tables from (SAP HR TABLES - Wiki - SCN Wiki)

Thanks in advance for your support.

Regards,

Sameer.

[roberto_vacca2]

Hi.

There's no way. But with a list of table in HR module as

http://sapbrainsonline.com/hr-tutorial/list-of-sap-hr-tables-and-infotypes-tables.html

you'll find that only these tables has BUKRS field:

- CATSDB

- CSKS

- T001T

- T500P

- HRP1008

- HRP1518

- HRPS_T012K

- PA0001

- PA0017

Hope to Help

Bye

[Former Member]

actually there are many.

[roberto_vacca2]

Hi.

From DD03L Sap table you can insert the "tables name" in select-option and BUKRS in fieldname

You'll find if your field BUKRS is referenced somewhere.

The list I wrote you down is where BUKRS is referenced Directly.

Hope to help

[former_member187748]

Hi Sameer,

what about Where Used list.

Go to se11 put bukrs in database table field and then click on where-used list.

Then you will get a pop-up screen , select table fields and execute. It will provide you a vast list in which you have to select p* type table.

I don't think there is any other way to find it.

[Former Member]

thanks sanjeev.

i too had this same solution, just wanted to check if there is any other efficient way to do this.

i have one doubt does this where-list also give the HITS if BUKRS is being used in any cluster-table or cluster data

[former_member187748]

Hi Sameer,

it will provide you the list of Cluster table too.

[nishantbansal91]

Hi Virdi,

Go to se15

Left hand side click on Fields .

Go to table fields you will come to know.

Thanks

Nishant

[Former Member]

That's the same thing what where-list will show.

thanks Nishant

[nishantbansal91]

Hi Virdi,

Here you can find with the field names too.

Suppose you have field name Pernr and data element is pernr_D.

If you want to check the field name PERNR is existing in which table you can find that one.

Thanks

Nishant

[Former Member]

that is what where list is doing...
go to SE11 and type pernr in 'Database Table' Field and hit where-Used list then you can select from the pop-up screen and bound your search.

[nishantbansal91]

You can't use the where to use in se11 for finding the field present in the table. You can find the same into program, view etc. But not in table.

For that you have to go se15 for finding the field name present in the tables.

Try with pernr field.

Please let me know the answer. It might happened i missed some point.

Thanks
Nishant

[Former Member]

this is because pernr is actually a Structure.