MARA and KONP join

[Former Member]

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 ?

[Former Member]

Hi

Can you check the link of below

KONP-BOMAT = MARA-MATNR and then

MARA-MATNR = MAKT-MARA.

hope it helps you.

Thanks!

[Former Member]

No it does not work..

[Former Member]

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.

[Former Member]

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

MARA-MATNR = A004-MATNR

KONP-KNUMH = A004-KNUMH

[Former Member]

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?