Finding tables with specific primary key

[Former Member]

Dear all:

Is there any way to identify tables, that have a certain attribute as a primary key? To be more precise, I would like to have a list of tables with VORNR as primary key. Thanks in advance.

Regards,

Jan

[Former Member]

Dear all:

Is there any way to identify tables, that have a certain attribute as a primary key? To be more precise, I would like to have a list of tables with VORNR as primary key. Thanks in advance.

Regards,

Jan

[Former Member]

The easiest way would be to have a look at table that has this field as the primary key, then look at the various DD0* tables to see which one would help.

It aint rocket science.

[Former Member]

SE11 -> Data Type -> Where Used List (Select Table Fields only) - Ok -> Click Limit Hits in Toolbar -> Expand Selection -> Select Only Unique Key Fields

[matt]

Yay. I've learned something today!

[ThomasZloch]

I'd prefer the Repository Info System (SE80, SE84, SE90) -> ABAP Dictionary -> Fields -> Table Fields, there one can set the "only unique key fields" box before the search is started.

Thomas

[Former Member]

Thanks Martin and Elzkie for your immediate reply!

[Shubham_Srivastava1]

Hello

There are multiple tables where you will find operational numbers field VORNR.

In purchase orders also this field is available.

The function module for finding which are the primary keys in table is BDL_DDIF_TABL_GET.

Some tables are PLPO , AFVC , MEACCT1000.

Above thread will be useful for you.

Can you please share exact requirements.

Shubham