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

How to link VBRK to customer data?

Hi,

I'd like to link the VBRK table to customer data. I see there is a KUNAG field for the customer (10 chars). Which table can it link to to retreive customer data.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jan 31, 2008 at 02:04 PM

    hi Marko,

    customer data you'll find in table KN*

    KNA1 - general data

    KNB1 - company code data

    KNVV - sales are data

    etc.

    KNA1-KUNNR will be the customer number you need

    hope this helps

    ec

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 03:11 PM

    You may also need KNVP which is the Partner table.

    In SD, you have got the Ship to, Sold to, Payer and Biller.

    Add a comment
    10|10000 characters needed characters exceeded

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

    Thanks for answers.

    KNA1 indeed provides the information I need.

    Now I wonder why can't I delete a table I entered in the join condition. When I make a mistake and add a wrong table I have to create I whole new query with all the customizing. Is the SQVI transaction/tool really deprived of a more sophisticated way of managing tables or is there something else I don't understand?

    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.