Skip to Content
author's profile photo Former Member
Former Member

Relation between VTTK table and VBUK

Hi ,

What is relation between VTTK and VBUK ,

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

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Aug 28, 2008 at 10:33 AM

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

    http://help.sap.com/saphelp_sm32/helpdata/en/b7/26dde8b1f311d295f40000e82de14a/frameset.htm

    Hope this would help you.

    Good luck

    Narin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2008 at 10:39 AM

    check tables

    VTTP-DELIVERY NO = VBUK-DELIVERNO

    VTTK-Shipment Number = VTTP-Shipment Number

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2008 at 09:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2008 at 10:22 AM

    Hi Joe,

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

    Regards,

    Swapna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 09:59 AM

    Thanks All

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.