Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Tables relationship

Former Member
0 Likes
665

Hi ,

I want to know the relationship of these two tables(common fields).

Based on that we can fetch.

VBPA:Sales Document: Partner

LTAP:Transfer order item.

May i know common fields please.

Thanks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
605

Hi

open the table LTAP or VBPA and press the Graphic butoon(Ctrl + Shift + F11).

it will show you the relation between all the tables

Hope it helps you...

Let me know if u have any more doubt...

Reward points if useful......

Suresh.......

Hi ,

I want to know the relationship of these two tables(common fields).

Based on that we can fetch.

VBPA:Sales Document: Partner

LTAP:Transfer order item.

May i know common fields please.

Thanks

3 REPLIES 3
Read only

Former Member
0 Likes
606

Hi

open the table LTAP or VBPA and press the Graphic butoon(Ctrl + Shift + F11).

it will show you the relation between all the tables

Hope it helps you...

Let me know if u have any more doubt...

Reward points if useful......

Suresh.......

Read only

Former Member
0 Likes
605

hi

go 2 se11 and open the table and press cntrl + shift + f11 or press graphics button next 2 table contents

reward if helpful.

regards,

kiran kumar k

Read only

Former Member
0 Likes
605

Hi Ali,

<b>LTAP</b> is the <b>Item table</b> for Transfer Order.

It is not directly linked with Sales Table VBPA.

Go to the <b>HEDAER</b> table of Transfer Order <b>LTAK</b>

You will find sales Document Number VBELN field in it.

pass that to VBPA table.

<b>LTAK-VBELN = VBPA-VBELN</b>

first check the data in LTAK whether values are there or not in LTAK, then use in VBPA table.

Reward Points for useful answers

Regards,

ANJI