Physical Tables Structure for HR OM Tables

[Former Member]

Hi ,

I am having one query.We have Organization Object(O),

Position (S) and Job (c).

These all go in Logical Tables.For Ex. T527X for OU.

I want to get the Physical table structure where these Tables and objects are stored and want to know about their Relationship, Mean Physical Relationship Table .

Anyone if found the Physical Database structure with Diagram having Relationship Table ,please Post ?

Regards,

Kamal

[Former Member · Accepted solution]

Hi

you can find in Se38 RHSTRU00, Se11> HRP1000,1001

Reagrds,

SriC

[Former Member · Accepted solution]

Hi Srinivasa,

HRP 1001 is a virtual Table.

i.e. OU table is T527X , Position Table is T528 B.

So these tables will be in Oracle Database inside SAP having one table name ?

Can u please confirm which Table shows the Relationship on T527X and T528B.

And one thing also, is Oracle inside SAP is Having same Table names as given above(ie T527X) ?

[Former Member · Accepted solution]

HRP1001 is Database table

T527X SAP table

Table names won't be same strucutre will be same in the case Transparent tables.

In case of cluster and pooled structure also won't be same

Best Regards

[rao_nakkella2 · Accepted solution]

SAP HR has the capability to store any objects and any other relevant integration items on both OM side as well as PA side. This was done to provide the capability to implement OM and PA separately if necessary (even though it is rarely done that way). The tables that you were referring to HRP1000 is the table on the OM side where as T527X is on the PA side.

When integration is turned on, the tables are kept in sync automatically. If you are turning on the integration for the first time, then the reports RHINTE** are used to populate the corresponding tables on the other side. Ex: RHINTE10 will copy the org unit data from HRP1000 to T527X.

Here are the tables for the other objects on the PA side.

Job T513, T513S

Position T528B, T528T

Org.unit T527X .

The tables in most cases are defined as transparent (not pooled or cluster), so there is a physical table in the database so the structure matches.

Regards,

Rao.

[Former Member · Accepted solution]

Hi Nakkella ,

Can u please provide me the Diagramatic Architecture of SAP Table So i can understand the relationship b/w Different Tables.

Thanks

Kamindia

[sikindar_a]

check the tcode OOVK

[Former Member]

You can check hrp table in se11.