VBAP, VBAK and KNA1

[Former Member]

Hey SD experts,

I would like to link those three SAP tables :

VBAP, VBAK and KNA1 in order to create a query.

VBAP is the principal table, VBAK and KNA1 are additional ones.

What intermediate table should I use to make it possible ?

Thank you,

Bahia.

[Former Member · Accepted solution]

Hi

You can connect

VBAP to VBAK through VBELN (Sales docu no.)

VBAK to KNA1 through KUNNR(Customer no.)

hope it will help.

[Former Member · Accepted solution]

Yes but while creating an infoset,

you have to link the additional table (KNA1) to the principal one (VBAP).

This seems to be impossible.

Edited by: Bahia M. on Feb 6, 2009 3:14 PM

[Former Member · Accepted solution]

I'll explain to you in details:

I'm trying to create an infoset.

I choose "direct read of table" : VBAP

Than, I add VBAK : VBAP-VBELN = VBAK-VBELN

Than, KNA1: KNA1-KUNNR = VBAK-KUNNR

When I try to generate the infoset, I get this warning message:

Access error in code for table KNA1, KNA1 has sequence number 01

Fields from VBAK are not assigned to a field group

Fields from KNA1 are not assigned to a field group

Thank you

[Former Member · Accepted solution]

Got the problem solved.

It's all about the access sequence.

Thank you all.

[Lakshmipathi]

Dear Bhahia

You have to Table Join in SQVI in the sequence of KNA1 --> VBAK --> VBAP to generate a query

thanks

G. Lakshmipathi

[jignesh_mehta3]

Daer Friend,

You can link VBAP & VBAK with VBELN

You can link VBAK & KNA1 with KNKLI / KUNNR.

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member]

Dear,

Go to SE11

enter table name you will get the discriptions of that table and data also

thanks,

Rahul