topic Re: KDAUF is empty??? in Application Development and Automation Discussions

KDAUF is empty???

Former Member — Wed, 21 Feb 2007 11:41:37 GMT

Hi everybody,

I am having a problem and I don't know how to solve it. I need to get data from the table VBKD but I only have LTAK-VBELN so I go to the LIPS with that key and I try to get the KDAUF to acces to the VBKD to get the BSTKD but the KDAUF is empty and I don't know how to access to the VBKD table with the data I have.

Does anybody know the solution??

Thanks

Re: KDAUF is empty???

Former Member — Wed, 21 Feb 2007 11:44:58 GMT

Can't you use LTAK-VBELN = VBKD-VBELN?

Regards,

Ravi

Re: KDAUF is empty???

Former Member — Wed, 21 Feb 2007 11:45:09 GMT

Why LIPS i think u can use the same key to get details from VBKD

santhosh

Message was edited by:

Kaluvala Santhosh

Re: KDAUF is empty???

Former Member — Wed, 21 Feb 2007 11:49:20 GMT

Hi ,

You can link VBKD and LIPS tabled though keys -

VBKD-VBELN = LIPS-VBELN

VBKD-POSNR = LIPS-POSNR

Re: KDAUF is empty???

anilnal — Wed, 21 Feb 2007 11:54:49 GMT

Hi,

LTAK contains the delivery doc number, so you need to fetch the sales order number for the delivery and then pick the data you need from VBKD.

With VBELN in LTAK, goto VBFA and fetch VBELV, giving VBELN as the sales doc number VBELN in LTAK and VBTYP_N as J.

This would give you the sales order number and you can pick the data you need from VBKD

Hope this helps,

Anil.

Message was edited by:

Anil