topic Re: Key Field in Application Development and Automation Discussions

Key Field

Former Member — Tue, 12 Aug 2008 06:34:45 GMT

Hi,

Can any one tell me the key field or with which field i can map the tables VBRP or VBRK with KNA1.

Waiting for ur reply...

Regards

Srinath

Re: Key Field

Former Member — Tue, 12 Aug 2008 06:35:19 GMT

hi,

there is no common key-field between

VBRP and KNA1

whereas kunnr is the common key field between KNA1 and VBRK

regards,

anirban

Re: Key Field

GauthamV — Tue, 12 Aug 2008 06:38:36 GMT

hi,

u can link VBAK-kunnr and KNA1-kunnr.

Then link VBAK and VBRK.

Re: Key Field

bpawanchand — Tue, 12 Aug 2008 06:41:18 GMT

VBRP-VBELN to KNA1-EKONT

VBRK-KNKLI to KNA1-KUNNR

Regards

Pavan

Re: Key Field

Former Member — Tue, 12 Aug 2008 06:42:22 GMT

Hi Srinath,

Refer this link between two tables.

VBRK-KUNRG = KNA1- KUNNR

VBRK-KUNAG = KNA1- KUNNR

Hope it is helps.

Regards,

T.Durai murugan.

Re: Key Field

Former Member — Tue, 12 Aug 2008 06:44:04 GMT

Hi,

VBRK can be linked with KNA1 using a field KUNRG or KUNAG.

VBRK-KUNAG <----> KNA1-KUNNR

Again for VBRP, first link it with VBRK using VBELN and then link VBRK-KUNAG with KNA1-KUNNR.

Regards,

Prem

Edited by: Prem Karthick on Aug 12, 2008 8:45 AM

Re: Key Field

Former Member — Tue, 12 Aug 2008 06:48:32 GMT

Hi,

It will depend on which field you want to link as there are different Customer id present in VBRK

VBRK-KUNAG for sold to party. (you can link it to KNA1-KUNNR)

VBRK-KUNRG for Payer (you can link it to KNA1-KUNNR)

Regards,

Mohaiyuddin