topic Link tables in Application Development and Automation Discussions

Link tables

Former Member — Mon, 11 Jun 2007 05:14:10 GMT

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 — Mon, 11 Jun 2007 05:30:52 GMT

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 — Mon, 11 Jun 2007 05:34:03 GMT

<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 — Mon, 11 Jun 2007 05:35:47 GMT

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 — Mon, 11 Jun 2007 05:50:32 GMT

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