topic Table linkage in Application Development and Automation Discussions

Table linkage

Former Member — Wed, 21 Nov 2007 11:13:35 GMT

Hi gurus!

plz help me out, i want

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 — Wed, 21 Nov 2007 11:18:58 GMT

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 — Wed, 21 Nov 2007 11:45:14 GMT

Thanks Anjji ,

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

Former Member — Wed, 21 Nov 2007 11:58:13 GMT

Hi Rahul ,

Invoice --> LIKP-VBELN

VBAK ~~>VBAP~~>LIPS-->LIKP

If its usefull reward points.

Thanks & Regards .

Arun.

Former Member — Wed, 21 Nov 2007 12:03:12 GMT

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

thanks for help..