Purchase order Number and Outbound Delivery

[Former Member]

Hello All,

I want write a select query which will show all outbound deliveries of a Purchase order. How shoudl I relate them? I mean what database tables can I use?

Regards

Puru

[Former Member]

Hi,

This can be done with table EKBE wherein for PO it has the PO history category. L denotes the delivery note. With this you can filter and findout for a specific order type what are the delivery notes created.

Hope this helps.

Thanks

Krishna.

[Former Member]

Pramod,

VBFA will not work since it is the document flow table. There is no tie between the SubCon PO and the Outbound delivery in that table.

[Former Member]

Hi,

You can use following database tables.

VBAK- Sales header for PO number

LIKP- Delivery header for outbound delivery number.

VBFA-To link sales and delivery in document flow.

Reward if useful.

Thanks,

Pramod