topic Function module for Open Sales Orders. in Application Development and Automation Discussions

Function module for Open Sales Orders.

Former Member — Wed, 01 Feb 2006 06:44:17 GMT

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.

Re: Function module for Open Sales Orders.

Former Member — Wed, 01 Feb 2006 06:58:37 GMT

hi,

check the table VBUK for the sales order header status.

VBUP for item status

regards

vijay

Message was edited by: Vijay Babu Dudla

Re: Function module for Open Sales Orders.

Former Member — Wed, 01 Feb 2006 07:17:38 GMT

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

Re: Function module for Open Sales Orders.

Former Member — Wed, 01 Feb 2006 07:56:41 GMT

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