table shows link between delivery no and purchase order no

[anupam_srivastava2]

Hi All

For particular delivery no, I want to know the purchase order no. which table stores this info.

cheers

AJ

[Former Member]

Hi Anup,

Try like this..

in LIPS ......get VGBEL and pass this to the EBELN Of EKKO table to get the relation b/w del and Purchasing.

Regards,

Padmasri.

[anupam_srivastava2]

able to sort it out

[Former Member]

Hi Anup,

If you know the billing number(VBRK-VBELN) you can get the PO number from VBRK-BSTNK_VF.

Even if you know delivery number pass it to VBFA table, get the salesorder number and pass it to VBAK and get the po number(VBAK-BSTNK)

Revert back if you have any doubts.

Regards

Karthik D

[former_member181995]

>

> Hi Anup,
> 
> If you know the billing number(VBRK-VBELN) you can get the PO number from VBRK-BSTNK_VF.
> 
> Even if you know delivery number pass it to VBFA table, get the salesorder number and pass it to VBAK and get the po number(VBAK-BSTNK)
> 
> Revert back if you have any doubts.
> 
> Regards
> Karthik D

And If SO is not derived from purchace order than?

[Former Member]

Hi amit,

That is what i forgot to mention, what i have told only suits for SO Derived from PO.

Regards

Karthik D

[GauthamV]

hi,

check EKBE table.

[anupam_srivastava2]

I want to know the realtion betwn customer purchase order no and Delivery No.

delivery no - likp-vbeln

customer purchase order no - vbkd-bstkd

in short i want to know the customer purchse order no for particular deliery no.

I have to write the code for that.

AJ

[former_member181995]

I would suggest you to ask your functional person may be he will be able to solve your doubts with good example ,as i did in my earlier SAP life.