topic Re: Table link in Application Development and Automation Discussions

Table link

Former Member — Wed, 28 May 2014 18:12:12 GMT

Hello Experts ,

Can any one tell me the exact link between these two tables MDKP and MDTB. I want to fetch the values of two fields DELNR and DELPS, please help me in this.

Thanks,

Vinod.

Re: Table link

Former Member — Thu, 29 May 2014 06:00:56 GMT

It appears

MDKP-MATNR = MDTB-BAUGR (material)

MDKP-PLWRK = MDTB-WRK02 (plant)

MDKP-DTNUM = MDTB-DTNUM (key field).

Re: Table link

Former Member — Thu, 29 May 2014 06:23:20 GMT

Hi,

You could see logical database DBM (you can use transaction SE36).

I'll hope that this idea could help you.

Best Regards

Ivan

Re: Table link

anubhab — Thu, 29 May 2014 06:52:11 GMT

Hi Vinod,

If you want, you can check SQVI tcode also. Please check the following link for your reference:

Regards,

Anubhab

Re: Table link

Jelena_Perfiljeva — Mon, 02 Jun 2014 21:16:16 GMT


Anubhab Chirui wrote:

Hi Vinod,
     If you want, you can check SQVI tcode also. Please check the following link for your reference:
How to find relation between two tables?

Regards,
Anubhab

It's not a good option actually as automatic suggestion is frequently off, especialy in the cases when relationship is not obvious. That's the reason why the mentioned blog has such low rating.