topic Re: Relation between VTTK table and VBUK in Application Development and Automation Discussions

Relation between VTTK table and VBUK

Former Member — Thu, 28 Aug 2008 10:28:36 GMT

Hi ,

What is relation between VTTK and VBUK ,

I need to get only one record as i move from VTTK to VBUK .

Thanks

narin_nandivada3 — Thu, 28 Aug 2008 10:33:04 GMT

Hi Jeo,

Goto Tcode SQVI and place these two table names... its quick viewer you can check the joins between two

tables and as well as can create a join too..

Check this help for Qucikviewer..

Hope this would help you.

Good luck

Narin

Former Member — Thu, 28 Aug 2008 10:39:05 GMT

check tables

VTTP-DELIVERY NO = VBUK-DELIVERNO

VTTK-Shipment Number = VTTP-Shipment Number

Pramanan — Mon, 01 Sep 2008 09:21:33 GMT

Hi,

It is possible.If you proceed with the following way you can avoid duplicates.

Tables Involved are

VTTK (shipment Header) - Source table

VTTP (Shipment item)

LIKP (sales Delivery header)

VBUK (Header status) - Destination table

Relation among the tables and way to access the either TKNUM or VBELN.

TKNUM is the realtion between VTTK and VTTP and it is one to many relation.

VBELN is the relation between VTTP and LIKP , it is many to one relation.

VBELN is again the relation between LIKP and VBUK, it is one two one relation.

If you proceed from table VTTK to VBUK you can get a single VBELN and its corresponding records.

If you proceed from table VBUK to VTTK you can get a single TKNUM and its corresponding records.

Hope this may help you

Former Member — Mon, 01 Sep 2008 10:22:07 GMT

Hi Joe,

I can find one common field in tables VTTK and VBUK that is VBTYP. VTTK-VBTYP = VBUK-VBTYP. Try this.

Regards,

Swapna.

Former Member — Tue, 23 Sep 2008 09:59:59 GMT

Thanks All