SO created is Open or Close Sales Order

[naren112]

<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>

[Former Member]

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]

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]

Hi,

You can check VBUK-GBSTK.

Ashven

[Former Member]

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