topic Re: Finding tables with specific primary key in Application Development and Automation Discussions

Finding tables with specific primary key

Former Member — Thu, 12 May 2016 08:19:36 GMT

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

Re: Finding tables with specific primary key

Former Member — Thu, 12 May 2016 08:24:45 GMT

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.

Re: Finding tables with specific primary key

Former Member — Thu, 12 May 2016 08:30:34 GMT

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

Re: Finding tables with specific primary key

Former Member — Thu, 12 May 2016 08:34:04 GMT

Thanks Martin and Elzkie for your immediate reply!

Re: Finding tables with specific primary key

Shubham_Srivastava1 — Thu, 12 May 2016 08:35:01 GMT

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

Re: Finding tables with specific primary key

matt — Thu, 12 May 2016 10:25:10 GMT

Yay. I've learned something today!

Re: Finding tables with specific primary key

ThomasZloch — Thu, 12 May 2016 11:01:23 GMT

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