How to find open orders with amount and open deliveries?

[former_member303858]

Hi All,

I want to find out the open orders with open amount and open deliveries for a particular customer.

We need this for credit check purpose.

Kindly guide us for this.

Regards,

Satish.

[Former Member]

Hi

Try in VA05N for all open sales orders as said for deliveries VL06G

regards

[Former Member]

Hi,

To find out open order:

data: c_bef_pgi(1) TYPE c VALUE 'A',
RANGES: rg_wbstk FOR vbuk-wbstk."range for wbstk
  rg_wbstk-sign = 'I'.
  rg_wbstk-option = 'EQ'.

  rg_wbstk-low = 'C'.
  APPEND rg_wbstk.

  rg_wbstk-low = 'A'.
  APPEND rg_wbstk.


1.first put query on vbak table
2.Put query on vbuk table as

      SELECT vbeln bestk lfstk gbstk FROM vbuk
              INTO TABLE it_vbuk_open
              FOR ALL ENTRIES IN it_vbak
              WHERE vbeln = it_vbak-vbeln AND
                    bestk IN rg_wbstk AND
                    lfstk = c_bef_pgi.

so this wil give u open orders.

3. Then according to vbuk, get the details from vbap.


To find open delivery

1. First put query on vbak table
2. Put query on vbfa as
  SELECT vbelv posnv vbeln posnn vbtyp_n vbtyp_v FROM vbfa
             INTO TABLE it_vbfa
             FOR ALL ENTRIES IN it_vbak
             WHERE vbelv = it_vbak-vbeln AND
                   vbtyp_n = 'J' AND
                   vbtyp_v = 'C'.
3.Then from VBfa,get the details from LIkp
4.Then put entry on vbuk as
*entries from vbuk
      SELECT vbeln wbstk fkstk gbstk FROM vbuk
             INTO TABLE it_vbuk_del
             FOR ALL ENTRIES IN it_likp
             WHERE vbeln = it_likp-vbeln AND
                   wbstk IN rg_wbstk AND
                   fkstk = c_bef_pgi.

Thanks & Regards,

Anagha Deshmukh

[Lakshmipathi]

Go to VA05 where you have the option to choose "Open Orders". Similarly, execute VL06G for open deliveries.

thanks

G. Lakshmipathi

[former_member303858]

Hi All,

Thanks for the reply.

I checked VA05 but it gives open order with total order value.

By open orders I mean the orders in which the qty in total in not PGIed. For example order has 10 qty and 5 are PGIed, the order will still be called open order as 5 qty is still open i.e not PGIed.

I need to find out such open orders and value of qty yet to be PGIed.

Regards,

Satish.

[Former Member]

Hi

Check in VL06G

regards

[Former Member]

HI,

GO to FD32 give customer name and CCA and goto menu bar select Environment->sales and distribution dos->open orders and open delivaries and invoices.

Regards,

kishore.