Table linkage

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks Anjji ,

please tell me how get invoice no with respect to sales order no.

[Former Member]

Hi Rahul ,

Invoice --> LIKP-VBELN

VBAK >VBAP>LIPS-->LIKP

If its usefull reward points.

Thanks & Regards .

Arun.

[Former Member]

hiii frnds , i thk i will get from VBFA , i will Po No and Invoice No.

thanks for help..