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

Table linkage

Hi gurus!

plz help me out, i want

Sales order no | po No | GR no | invo no | amount | MIRO no | amount |

so i want links from

1.vbak to ekko or [ vbeln to ebeln ]

2.vbeln to GR NO .

3. vbeln to inv no.

4. vbeln to miro no.

From EKBE - PURCHASE HISTORY - > i get Gr no and Miro No depending on value of VGABE.

From EKKN - i get link between EBELN and VBELN.

is it right or i have to refer other tables.

Regards,

Rahul D

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 11:18 AM

    Hi

    Yes, take the link between VBELn and EBELN from EKKN

    so you got the EBELN and EBELP for the VBELN from EKKN

    now pass this EBELN and EBLP to MSEG and take the MIRO/GR number

    and pass to EKBE and take the BELNR number

    if needed also pass to RSEG and take the BELNR

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 11:58 AM

    Hi Rahul ,

    Invoice --> LIKP-VBELN

    VBAK >VBAP >LIPS-->LIKP

    If its usefull reward points.

    Thanks & Regards .

    Arun.

    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.