Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Key Field

Former Member
0 Likes
1,213

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

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

6 REPLIES 6
Read only

Former Member
0 Likes
992

hi,

there is no common key-field between

VBRP and KNA1

whereas kunnr is the common key field between KNA1 and VBRK

regards,

anirban

Read only

GauthamV
Active Contributor
0 Likes
992

hi,

u can link VBAK-kunnr and KNA1-kunnr.

Then link VBAK and VBRK.

Read only

bpawanchand
Active Contributor
0 Likes
992

HI

VBRP-VBELN to KNA1-EKONT

or

VBRK-KNKLI to KNA1-KUNNR

Regards

Pavan

Read only

Former Member
0 Likes
992

Hi Srinath,

Refer this link between two tables.

VBRK-KUNRG = KNA1- KUNNR

VBRK-KUNAG = KNA1- KUNNR

Hope it is helps.

Regards,

T.Durai murugan.

Read only

Former Member
0 Likes
992

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

Read only

Former Member
0 Likes
992

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