Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

MARA and KONP join

Former Member

‎04-20-2009 3:44 PM

0 Kudos

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 ?

5 REPLIES 5

Former Member

‎04-20-2009 3:56 PM

0 Kudos

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
In response to Former Member

‎04-20-2009 4:25 PM

0 Kudos

No it does not work..

Former Member
In response to Former Member

‎05-25-2011 2:47 PM

0 Kudos

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

‎12-20-2011 7:07 PM

0 Kudos

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

MARA-MATNR = A004-MATNR

KONP-KNUMH = A004-KNUMH

Former Member

‎12-21-2011 6:45 AM

0 Kudos

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?