How to link VBRK to customer data?

[Former Member]

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.

[JozsefSzikszai · Accepted solution]

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

[Former Member]

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?

[JozsefSzikszai]

you have to right click on the name of the table (on the box), and choose Table object delete (or something like that)

[Former Member]

That's when the application issues the message:

"Tables of the join can no longer be deleted..." !

[Former Member]

You may also need KNVP which is the Partner table.

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