Some fields of SD Tables

[Former Member]

Hi friends,

Can anybody help in specifying me in which SD table I will get the fields Sales Document Number, Planned Delivery Date & Actual Delivery Date.

Thanx in advance

Nishant

[Former Member · Accepted solution]

Hi Nishu,

Your question is a bit vague... Sales Document number can be anything from sales order number (table VBAK), delivery number (table LIKP) to billing number (table VBRK).

Planned delivery date is field FKDAT in table LIKP.

Regards,

John.

[Former Member]

hi nishu,

check this link

http://www.sapgenie.com/abap/tables_sd.htm

hope this helps.

regards,

vidya

[Former Member]

You can use the table VBAK for the SD Document number(VBELN) and the planned delivery date(VDATU). Go to table VBFA and use the SD Doc No in the field VBELV(Preceding sales and distribution document) to get the Delivery Doc No. Once you get the delivery doc no, go to the delivery header table(LIKP) and there you can get the actual delivery date(LFDAT).

Points please!

[abdul_hakim]

Hi,

Welcome to SDN..

check the table LIPS for delivery details.

For sales order details check VBAK,VBAP,VBUP,VBFA etc..

Cheers,

Abdul