topic Tables relationship in Application Development and Automation Discussions

Tables relationship

Former Member — Fri, 13 Apr 2007 06:39:44 GMT

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

Former Member — Fri, 13 Apr 2007 06:43:39 GMT

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.......

Former Member — Fri, 13 Apr 2007 06:44:20 GMT

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

Former Member — Fri, 13 Apr 2007 07:02:14 GMT

Hi Ali,

LTAP is the Item table for Transfer Order.

It is not directly linked with Sales Table VBPA.

Go to the HEDAER table of Transfer Order LTAK

You will find sales Document Number VBELN field in it.

pass that to VBPA table.

LTAK-VBELN = VBPA-VBELN

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