Link tables

[Former Member]

Hi

My selection screen has vkorg,prdha(prodct group),bukrs,bsart(Purchase order types).

i need to display output

vbap-prodh(product group) vbak-kunnr,vbak-audat,vbak-edatu.....these all from sales ...

mara-prdh(product group),ekko-ekorg,ekko-aedat..

How can i link those.

Thanks in adance

[Former Member]

Hi krk,

can u give elaborate ur question ???

as of now u can link VBAP and MARA using the matnr field...

Regards..

BALAJI

[Former Member]

Hi

<b>Link the EKPO and EKKN tables with EBELN and EBELP fields

and take the VBELN field from EKKN which is sales order

and link EKKN and VBAP with the VBELN and POSNR fields</b>

With MATNR you can link MARA and VBAP tables

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

hi krk,

try with vbap table,

it has fields matnr and vbeln with therse two fields u can maintain ralation between mara and vabk,

go to vbap table and have a look on check tables of vbap then u can get the clear idea.

regards,

seshu.

[Former Member]

Hi

My detailed requirement

Based on that selection screen as i mentioned i need to display the output

vbap-prodh,vbak-kunnr,vbak-bstnk,vbak-edatu,

mara-prdha,ekko-ekorg,ekko-aedat,vbak-bstnk,eket-eindt etc..

Thanks