topic Re: Link Between Tables in Application Development and Automation Discussions

Link Between Tables

Former Member — Fri, 28 Dec 2007 10:08:24 GMT

Hi my friends,

I am looking for a link between

V_EQUI and KNA1-KTOKD

V_EQUI and KNA1-KNA1

V_EQUI and ADRC-REGION

V_EQUI and ITONB-INBDT

V_EQUI and MARA-PRDHA

I am usually very good at finding relations, but for some reason today I can not think!

Reward for all helpful answer

Re: Link Between Tables

rajesh_akarte2 — Fri, 28 Dec 2007 10:28:38 GMT

hi Dipesh ,

I am not getting ur question bcoz u have metion like this,In this u have mentioned kna1-ktokd which field and v_equi is a table

V_EQUI and KNA1-KTOKD

V_EQUI and KNA1-KNA1

V_EQUI and ADRC-REGION

V_EQUI and ITONB-INBDT

V_EQUI and MARA-PRDHA

Is it like this?

V_EQUI and KNA1

V_EQUI and ADRC

V_EQUI and ITONB

V_EQUI and MARA

If it is like this then the relationship is like this:

1) V_EQUI-KUND1 KNA1-KUNNR

2) V_EQUI-ADRNR ADRC-ADDRNUMBER

3) V_EQUI-matnr MARA-MATNR

The table name ITONB doesn't exists in dictionary.

Reward the points if helpful.

Regards,

Rajesh Akarte

Re: Link Between Tables

Former Member — Fri, 28 Dec 2007 10:30:33 GMT

Hi that is exactly what i want,

sorry i mis-spelt ITOB. do you have the link for that. MANY THANKS,

Re: Link Between Tables

rajesh_akarte2 — Fri, 28 Dec 2007 10:40:09 GMT

there are lots of common fields in ITOB and V_EQUI but u can take any field as per ur requirements.

U can compare both the table so u will find.

Regards,

Rajesh Akarte

Re: Link Between Tables

Former Member — Fri, 28 Dec 2007 10:41:45 GMT

seriously i am not with it today!!!!!

but anyway 20 points are yours

Re: Link Between Tables

Former Member — Fri, 28 Dec 2007 11:06:38 GMT

link's

v_equi-kund1 = kna1-kunnr

v_equi-adrnr = adrc-addrnumber

v_equi-kmatn = mara-matnr

their is no table with name itonb

regards,

pavan

Reward if useful