Primary keys for IT

[Former Member]

Do HR infotypes contains Primary key relation ship?

How does it perform Normalization.

Vamsi.

[uwe_schieferstein]

Hello Vamsi

All HR infotypes are stored in different DB tables yet they have common key component: structure <b>PAKEY</b> <i>(Key for HR Master Data)</i>

For example, if you look at table PA0000 (HR Master Record: Infotype 0000 (Actions)) you will see the common key component.

If you lookup the domain for field <b>PERNR</b> you will see that infotype table <b>PA0003</b> is defined as <i>value table</i>. I think this is the only foreign-key relation between the different infotypes.

Regards

Uwe

[Former Member]

HR infotypes are present in DB tables.

These tables have a common key component relevant to each other. The structure PAKEY represents the common key for the database tables.