topic Table releation in Application Development and Automation Discussions

Table releation

Former Member — Tue, 14 Apr 2009 04:31:36 GMT

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 — Tue, 14 Apr 2009 04:52:23 GMT

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 — Tue, 14 Apr 2009 04:55:34 GMT

Check out with KUNNR field in both tables

Former Member — Tue, 14 Apr 2009 05:00:12 GMT

Hello Venky,

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

Hope this helps,

Sathya

Former Member — Tue, 14 Apr 2009 05:06:45 GMT

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 — Tue, 14 Apr 2009 05:22:35 GMT

This message was moderated.

Former Member — Tue, 14 Apr 2009 05:49:54 GMT

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