Skip to Content
author's profile photo Former Member
Former Member

eina

Hi,i wnt infnr,matnr,lifnr,urzdt from eina and urzdt is with reference to plant.

i am retrieving matnr,plant from mara, marc using inner join into t_mara.

refering this t_mara, within this fields matnr can be refered to eina-matnr and werks for eine which is having plant.

need query

urgent pls help

regards,

kb

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 03:07 PM

    Ask the same question twice for someone to write the code for you.

    GOOD LUCK!!!!!!!!!!!!!!

    But I am sure some fool will do it.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 03:07 PM

    Use EINA and EINE (which contains plant)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 08:14 AM

    HI

    Check this INNER JOIN on EINA and EINE

    IF NOT ITAB[] IS INITIAL.

    SELECT ainfnr alifnr a~matnr

    bekgrp bekorg bpeinh bbprme

    INTO TABLE g_t_purinfo1

    FROM eina AS a

    INNER JOIN

    eine AS b

    ON ainfnr = binfnr

    FOR ALL ENTRIES IN g_t_editpos1

    WHERE a~infnr = ITAB-infnr

    AND b~ekgrp IN so_ekgrp

    AND b~ekorg IN so_ekorg

    AND a~lifnr IN so_lifnr

    AND a~matnr IN so_matnr.

    ENDIF.

    Hope this Helps.

    Thanks Praveen

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 10:13 PM

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.