Table releation

[Former Member]

HI,

I need to give Releation for KNA1-name1 to VBAK....

Actually i need to Print the Customer name

Thanks in Advance

Regards

raj.

Edited by: venky raj on Apr 14, 2009 6:35 AM

[Former Member]

HI,

I need to give Releation for KNA1-name1 to VBAK....

Actually i need to Print the Customer name

Thanks in Advance

Regards

raj.

Edited by: venky raj on Apr 14, 2009 6:35 AM

[Former Member]

Hi,

Are you checking relationship between the KNA1 & VBAK for getting the customer name.. then you can get it by thos way..

VBAK-KUNNR = KNA1-KUNNR.

Is this you are looking for ?

[former_member585060]

Check out with KUNNR field in both tables

[Former Member]

Hi,

Try with the following join.

KNA1-KUNNR = VBAK-KNKLI

Take the VBAK-KNKLI value and enter the value in KNA1-KUNNR . You will get the kna1-name1...

Edited by: sekhar rao on Apr 14, 2009 7:21 AM

Thank you,

Sekhar.

Edited by: sekhar rao on Apr 14, 2009 7:21 AM

[Former Member]

Hello Venky,

You can pass the KUNNR of VBAK table to KNA1 to get the customer name.

Hope this helps,

Sathya

[Former Member]

This message was moderated.

[Former Member]

hi ,

you wrote this..

> I need to give Releation for KNA1-name1 to VBAK....

>

there is no relation between the KNA1 and VBAK on the basis on NAME1 field.

but the relation on these table is on field KUNNR.

hope this helps

Regards

Ritesh J