table mapping problem

[Former Member]

Hi.

i have tables knb1,kna1,knc1,vbpa,vbrk,knvv,knkk from which i want to have fields.

i wish to have kunnr,pernr and parvw from vbpa

and fkdat from vbrk and

kunnr bukrs,gjahr from knc1.

rest i am able to connect.

but not getting the key combination between knc1,vbpa and vbrk.

kindly

[Former Member]

thanks for the answer

but there is no component in vbrk like vgbel.

plz help.

[GauthamV]

use this combination.

vbpa-kunnr = knc1-kunnr.

vbrk-vgbel = lips-vbeln
lips-vgbel = vbak-vbeln.
vbak-vbeln = vbpa-vbeln.

Code Formatted by: Alvaro Tejada Galindo on Jan 8, 2009 3:21 PM

[Former Member]

thanks for the answer

but there is no component in vbrk like vgbel.

plz help.

[GauthamV]

sorry,it is in VBRP.i think you dont have any problem joining vbrk,vbrp.