topic Re: MARA and KONP join in Application Development and Automation Discussions

MARA and KONP join

Former Member — Mon, 20 Apr 2009 14:44:48 GMT

Hi !

I need the KBETR from KONP table and at the same time the material description (i.e.MATNR) .

I have checked in VK13 tcode and found that MATNR is from KOMG table .

But I have a view which extracts data from MARA . How can I add this to this view as there is no joining condition between MARA and KONP ?

Re: MARA and KONP join

Former Member — Mon, 20 Apr 2009 14:56:13 GMT

Can you check the link of below

KONP-BOMAT = MARA-MATNR and then

MARA-MATNR = MAKT-MARA.

hope it helps you.

Thanks!

Re: MARA and KONP join

Former Member — Mon, 20 Apr 2009 15:25:40 GMT

No it does not work..

Re: MARA and KONP join

Former Member — Wed, 25 May 2011 13:47:50 GMT

Try to join tables KONP-KNUMH with KOTE001-KNUMH. From KOTE001 table you can get material number MATNR.

If you need description of material, you should link KOTE001-MATNR with MAKT-MATNR and you will receive field MAKT-MAKTX with description of material.

Re: MARA and KONP join

Former Member — Tue, 20 Dec 2011 19:07:12 GMT

I found the link between KONP and MARA using A004 table.

MARA-MATNR = A004-MATNR

KONP-KNUMH = A004-KNUMH

Re: MARA and KONP join

Former Member — Wed, 21 Dec 2011 06:45:11 GMT

The condition type determines which table you should use to link MARA with KONP.

So this could be A001 or A0002 or A... or B... Any of these condition tables should hold both materialnumber as condtionnumber.

So: what is the condition type you're after?