on 04-07-2006 8:36 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Welcome to SDN..
check the table LIPS for delivery details.
For sales order details check VBAK,VBAP,VBUP,VBFA etc..
Cheers,
Abdul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.