topic Re: link between table in Application Development and Automation Discussions

link between table

Former Member — Wed, 08 Oct 2008 08:35:46 GMT

Hi,

I need RBKP and RSEG related tables.

Re: link between table

Mohamed_Mukhtar — Wed, 08 Oct 2008 08:39:50 GMT

hi,

RBKP-BELNR  = RSEG-BELNR
RBKP-GJAHR  = RSEG-GJAHR

Regards

Re: link between table

Former Member — Wed, 08 Oct 2008 08:43:41 GMT

Hi Shivam,

RBKP - Invoice Header

RSEG- Invoice Item

They are header and item tables,

RBKP-BELNR -> RSEG-BELNR

RBKP-GJAHR-> RSEG-GJAHR

Re: link between table

Former Member — Wed, 08 Oct 2008 08:44:13 GMT

hi..

Use TCODE - SQVI

1: Create a quick view.

2: give a title and select the DATA SOURCE as TABLE JOIN

enter.

3: Press Insert tble ICON and give ur desired table name1(in our case - RBKP )..enter.

4: Again repeat step 3 and enter table name2 - RSEG.

Here u can find the links between them.

U can use tcode to know all transparent Table links.

regards,

Padma

Re: link between table

Former Member — Wed, 08 Oct 2008 08:53:40 GMT

Hi,

Relationship between those 2 tables is

RBKP-BELNR -> RSEG-BELNR

RBKP-GJAHR-> RSEG-GJAHR

Re: link between table

Former Member — Wed, 08 Oct 2008 08:55:18 GMT

I am unable to understand ur requirement,

Do you need relation for RSEG and RBKP

or you need relation of these two tables with other tables.

1. Relation b/n RSEG abd RBKP is given already.

2. Go to the SE11 and give the table name and from there you can see all the related check tables through Entry help/Check

These two tables are related to many major tables like, Mara, Lfa1, Ekko,.......

check out SE11 for your required relations like this...

U can establidh the link for DB view using ebeln ebelp for EKPO and RSEG.

RSEG-EBELN = EKPO-EBELN.

RSEG-EBELP = EKPO-EBELP.

and between RSEG and EBKP using fields GJAHR and BELNR.

RSEG-GJAHR = EBKP-GJAHR.

RSEG-BELNR = EBKP-BELNR.

Re: link between table

Former Member — Wed, 08 Oct 2008 08:59:01 GMT

Thanks but I want another tables related RBKP AND RSEG.

Re: link between table

Former Member — Wed, 08 Oct 2008 08:59:38 GMT

Thanks but I want another tables related RBKP AND RSEG.

Re: link between table

Former Member — Wed, 08 Oct 2008 09:04:04 GMT

hi shivam..

try what dileep kumar has said earlier..!!

Goto se11 with ur table name.

click the entry help/check TAB

and see the CHECK TABLES.

Regards,

Padma

Re: link between table

Former Member — Wed, 08 Oct 2008 09:07:01 GMT

Hi Shivam,

Goto the tables RBKP and RSEG in SE11.

Press CtrlShiftF11 (or) Utilities -> Graphics

Then you can see all the tables related to that table. In List and also graphically

Try this

Cheers,

Kothand

Re: link between table

Former Member — Wed, 08 Oct 2008 09:11:18 GMT

Hi,

Goto se11 , put table name RBKP press display button

Press the Graphic button (Ctrl + Shift + F11 )

You will get the list of related tables. Choose from the list and execute. You will see a graphical view of the relationship of the tables that are related to RBKP.

Repeat the same for RSEG.

regards,

Advait

Re: link between table

Former Member — Wed, 08 Oct 2008 09:22:01 GMT

As I expected Your requirement is different from your post. And now you can try with se11 in entry help/ check or from the graphics.

or atleast mention which table do you expect to be related from these tables.

Regards.

Dileep .C