Open Order

[Former Member]

Hi

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]

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

Message was edited by: Jacek Slowikowski

[Former Member]

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