topic Re: table and field name for the delivery status - sales order in Application Development and Automation Discussions

table and field name for the delivery status - sales order

Former Member — Fri, 01 Aug 2008 11:52:26 GMT

Hi All,

Please tell me the table and field name for the delivery status - sales order

Its Urgent .

Thanks in advance.

naveen_inuganti2 — Fri, 01 Aug 2008 12:03:59 GMT

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.

Former Member — Fri, 01 Aug 2008 13:25:05 GMT

Hi,

You can get the sales order delivery status from VBUK table by providing sales order number.

VBUK-LFSTK

Regards

Saravana Kumar P

Former Member — Sat, 02 Aug 2008 07:41:08 GMT

For Header status Go to Table VBUK, For Item status Go to VBUP.