dilevery plant for a particular Invoice

[Former Member]

Hi Experts,

I need to display the dilevery plant for my smartform (zlb_bil_invoice),How can I get the dilevery plant for the Invoice please help me out with the tables,fileds .

Thanks in Advance

[former_member196280 · Accepted solution]

Try this it will solve your problem

SELECT SINGLE * FROM vbrp WHERE vbeln EQ vbdkr-vbeln

AND posnr = '00010'.

SELECT SINGLE * FROM vbkd WHERE vbeln = vbrp-aubel.

vbkd-empst " delivery plant

Close the thread if your question is answered.

Regards,

SaiRam

[Former Member · Accepted solution]

Thanks for your reply but it seems to a item level table but i need the delivery plant for a particular invoice