2015 Sep 24 10:58 AM
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.
2015 Sep 24 11:25 AM
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.
2015 Sep 24 11:14 AM
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
2015 Sep 24 12:08 PM
2015 Sep 24 1:15 PM
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
2015 Sep 24 11:25 AM
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.
2015 Sep 24 12:09 PM
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
2015 Sep 24 12:26 PM
2015 Sep 24 12:12 PM
Hi Virdi,
Go to se15
Left hand side click on Fields .
Go to table fields you will come to know.
Thanks
Nishant
2015 Sep 24 12:23 PM
That's the same thing what where-list will show.
thanks Nishant
2015 Sep 24 12:27 PM
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
2015 Sep 24 12:37 PM
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.
2015 Sep 24 12:47 PM
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
2015 Sep 24 1:02 PM