Table link

[Former Member]

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.

[Former Member]

It appears

MDKP-MATNR = MDTB-BAUGR (material)

MDKP-PLWRK = MDTB-WRK02 (plant)

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

[Former Member]

Hi,

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

I'll hope that this idea could help you.

Best Regards

Ivan

[anubhab]

Hi Vinod,

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

Regards,

Anubhab

[Jelena_Perfiljeva]

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.