Function module for Open Sales Orders.

[Former Member]

Can u any one tell me is there any standard function module to

retrieve OPEN-SALES orders. I tried to debug VA05 but not of use...

Thanks in advance,

Sanjay.

[Former Member]

hi,

check the table VBUK for the sales order header status.

VBUP for item status

regards

vijay

Message was edited by: Vijay Babu Dudla

[Former Member]

hi

you can get open sales orders from vbuk and vbup

SELECT

A~VBELN

A~GBSTK

B~GBSTA FROM VBUK AS A

INNER JOIN VBUP AS B

ON A_{VBELN = B}VBELN INTO TABLE T_OPENS

FOR ALL ENTRIES IN T_VBELN WHERE A~VBELN = T_VBELN-VBELN

AND A~GBSTK IN ('A','B')

AND B~GBSTA IN ('A','B').

in t_vebeln table is haveing sales orders by user selection you can get it like this

regards,

varma

[Former Member]

Thank you all for the response. Actually i am aware of this join logic. I was looking for a function module which gives me complete details including the delivery information.

And I found it...

SD_SALES_ORDER_STATUS_WWW

Thank you Sujith for FM details.

- Sanjay