Link VBKD & LIKP tables

[former_member335605]

Hi Friends,

I am getting VBELN from LIKP table and want contract number which i think is BSTKD from VBKD table.But i am can not find any link between the two tables.Plz provide me explanation or tell me any other field from LLIKP,LIPS tables which i can use as contract numbers.

[h_senden2 · Accepted solution]

find the related sales order via VBFA (link between sales order and delivery) and then get the VBKD data for the found sales order.

regards,

Hans

Please reward all helpful answers !!!!!

[Former Member]

You can get the contracts related to a delivery (I am assuming that you are looking for sales contracts not purchasing ones) using function module RV_FLOW. Pass your delivery number to the parameter COMWA-VBELN.

[Former Member]

Hi,

1. VBKD-VBELN = VBAP-VBELN and

VBKD-POSNRBAP-POSNR.-----> FROM HERE

2.LIPS-VGBEL = VBAP-VBELN A and

LIPS-VGPOS = VBAP-POSNR.-->Fom Here

3.LIPS-VBELN = LIKP-VBELN.

Don't forget to reward if useful...

[former_member632991]

Hi,

First fetch the sales order no for that delivery from VBFA table

or get it from LIPS table VGBEl and VGPOS fields,

Use these sales order no for getting data from VBKD table.

Hope it helps.

Regards,

Sonika