How to find the table which a pk belongs to ?

[ansellsilvans]

I know a pk and I want to know which table it belongs to .

[Former Member · Accepted solution]

You can also run the flexible search query

 select * from {composedtype as ct} where {ct:pk} = 8796114387026

to get more information.

[ansellsilvans · Accepted solution]

Thanks Ethan.. This is what i expected

[Former Member]

Go to hAC > Platform > PK Analyzer and enter your PK and you'll get the type code.

[Former Member]

What if the typecode listed is ComposedType?

[Former Member]

Hi Ethan

atomic types means user name has string as type:Simple Type composed type means username has language which is another type :

You may try this . HMC > System>types> add attribute PK from drop down> enter your pk in Box> search try this