2008 Aug 01 12:52 PM
Hi All,
Please tell me the table and field name for the delivery status - sales order
Its Urgent .
Thanks in advance.
2008 Aug 01 1:03 PM
Hi.....
Table- VTDST Status of deliveries within transportation planning
Field- STATE Status of a delivery in transportation planning
Table- VTDSTC Condition of Deliveries for Freight Planning by Fwdng Agent
Field- STATE Condition of Delivery in Freight Planning by Forwarding Agnt
Table- VBUK Sales Document: Header Status and Administrative Data
Field- LFSTK Delivery status
Table- VBUP Sales Document: Item Status
Field- LFSTA Delivery status
Table- VSVBUK_CN Sales Document: Header Status and Administrative Data
Field- LFSTK Delivery status
Table- VSVBUP_CN Sales Document: Item Status
Field- LFSTA Delivery status
Table- ZFFXJV FX Difference Adjustment JV posting
Field- LFSTK Delivery status
Table- NMATO IS-H: Material requisition by nurse station
Field- LFSTA IS-H: Delivery Status of Material Requisition Item
Table- NMATP IS-H: Material planned for case
Field- LFSTA IS-H: Delivery Status of Material Requisition Item
Table- S541 Backlog reports structure
Field- LFSTA Delivery status
Table- S542 Backlog Reports Structure
Field- LFSTA Delivery status
Thanks,
Naveen Inuganti.
2008 Aug 01 2:25 PM
Hi,
You can get the sales order delivery status from VBUK table by providing sales order number.
VBUK-LFSTK
Regards
Saravana Kumar P
2008 Aug 02 8:41 AM
For Header status Go to Table VBUK, For Item status Go to VBUP.