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

sap abap

hi all

i m providing all the condition given to me i had done the task till the selection of data in to all internal tables now i had to join the table but i dont want to make the use of inner join so how can i do that and i completely cant understand whts the last line in bold means .

Select company code (BUKRS), plant (WERKS), Location (STORT), Order number (AUFNR), Object Number (OBJNR) from AUFK. Select material (PLNBEZ), Routing number of operations in the order (AUFPL), Number of reservation/dependent requirements (RSNUM), Task List Type (PLNTY), Key for Task List Group (PLNNR), BOM category (STLTY), Bill of material (STLNR) from table AFKO. Select Status (STAT) from table JEST. Use inner join between tables AUFK and AFKO on field AUFNR. Use inner join between tables AUFK and JEST on field OBJNR.

The status in table JEST is compared with the status taken from table TJ02T. Only orders with goods movement posted status are taken.

thanks

himanshu sharma

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 06:19 AM

    Hi Himanshu,

    Its not advisible to use the inner join. So tell me the table names so that I can help you out with the joining between them.

    In case its possible <b>try joining them on The key fields</b> and within the functional reaches.

    Reward Points if useful.

    Thanks,

    Tej..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Himanshu, 😊

      The field objnr is a key field in table JEST. So go ahead to join this with AUFK as the field is available again.

      For all entries in AUFK fetch the details from JEST.

      This should solve your query.

      Reward Points.

      Thanks,

      Tej..

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 06:16 AM

    plz answer this thread soon .

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 06:25 AM

    Hi again Himanshu,

    The two tables AUFK and AUFNR can be joined with the key AUFNR.

    SELECT AUFNR AUART AUTYP REFNR ERNAM

    FROM AUFK INTO IT_AUFK

    WHERE (the select criterion).

    SELECT AUFNR GLTRP GSTRP FTRMS GLTRS GSTRS GSTRI

    from AFKO INTO IT_AFKO

    <b>FOR ALL ENTRIES IN IT_AUFK</b>

    WHERE <b>AUFNR = IT_AUFK-AUFNR</b>.

    This should solve your query.

    Reward Points.

    Thanks,

    Tej..

    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.