topic Re: Open Order in Application Development and Automation Discussions

Open Order

Former Member — Mon, 24 Jul 2006 14:38:03 GMT

all

No one is able to answer me for Open oreder.

i want to get the open order by using table VBUK & VBFA .

how can i do it.Plz give me some hint or Code.(Is Any

other way possible way by using other tables)

Which fields i haev to relate and How??

I will always be thankful for Best possible answer

Thanks

Saurabh Tiwari

Former Member — Mon, 24 Jul 2006 14:42:56 GMT

all with the field ( vbup_{gbsta <> 'C' and vbup}absta <>'C')

For sales order ! Use table VBAK (header,) VBAP - positions.

So take VBAP and joinwith vbup on vbeln and posnr.

Chose anly with statuses described above.

BR, JAcek

Message was edited by: Jacek Slowikowski

Former Member — Mon, 24 Jul 2006 14:43:01 GMT

Hello,

In the table VBRP check the refrence document VGBEL

Select single * from VBRP where VGBEL = SALES ORDER.

If sy-subrc ne 0.

open sales order.

endif.

Hope this will solve ur problem.

Reward if helps.

Vasanth