Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SO created is Open or Close Sales Order

naren112
Explorer
0 Kudos
154

<b>Hi

I hav ot write a report for SD , In this for sales order I hav to check that - Is this Sales order is Open or Close order ,

Select-optoins are SALES ORDER , DATE , PLANT , St location .

if it is a close sales order , Then this report should pass a message to The MM consultant abt the stock ...

Regards ,

Narender .</b>

4 REPLIES 4

Former Member
0 Kudos
73

enter the Sales order number in table VBUK in vbeln and check the field GBSTK ne C

VBUK-GBSTK ne C => sales order is open 

A  , B status represent partillay closed  
VBUK-GBSTK eq C => sales order is closed

check this .

regards,

vijay

Former Member
0 Kudos
73

Hi,

Check transaction code VA05. This transaction is nothing but a report to display all types of sales orders. You can copy the entire logic from this report.

Hope this helps.

Cheers

VJ

Former Member
0 Kudos
73

Hi,

You can check VBUK-GBSTK.

Ashven

Former Member
0 Kudos
73

Hi,

Just to add, a sales order is open till such time all the line items are delivered completely with respect to the quantity ordered. This you can find in the VBUK ( Header status ) where the GBSTK field value is " C ".

Even if the goods are shipped or not, it does not influence the sales order completeness. Its only a delivery that happened or not influences the sales order status. Also you can take help from VA05 t.code which shows all the open sales orders by checking the " Open sales orders " button.

Hope it helps. Pl reward if useful.

Thanks & Regards

Sadhu Kishore