Open Sales Order

[Former Member]

I need to develop a planning report where open sales orders are required. Kindly let me know how to calculate open sales order from which table to match exactly transaction VA05 total.

Thanks

[Former Member]

Hi

U need to check the status of the sales document (table VBUK, VBUP)

Max

[Former Member]

There are lot of status. Kindly let me know which status i need to check to match VA05 status.

Thanks

[Former Member]

Hi

U can use the index table VAKPA to upload the sales order for a certain customer and after you should check the value of the status fields LFGSK: it doesn't has to be C.

Max

[Former Member]

Hi,

You have to take selection from VBUK-LFSTK "Delivery status.

It should not be 'C' "Completely processed .

so in where cond you put VBUK-LFSTK NE 'C'.

But in case of credit memo request you will not get any delivery . In that case this carries blank value . "Not relevant

.So if you want to differentiate means you have to restict by order type

VBAK-AUART should be 'OR' i.e Sales document type

Thanks

Sivaparvathi

Please reward points if helpful.

[Former Member]

I worked with your logic but it did not match with va05

Thanks

[Former Member]

Hi

This is the logic (include LV05TFOF):

      IF LVBUK-LFGSK = ' '.
        CHECK VBCOM-VBOFF = ' ' OR
               LVBUK-GBSTK = 'A' OR LVBUK-GBSTK = 'B'.
        LVBMTV-STATUS = LVBUK-GBSTK.
        FELDNAME = 'GBSTK'.
      ELSE.
        IF LVBUK-LFGSK = 'C'.
          CHECK VBCOM-VBOFF = ' ' OR
                 LVBUK-GBSTK = 'A' OR LVBUK-GBSTK = 'B'.
          LVBMTV-STATUS = LVBUK-GBSTK.
          FELDNAME = 'GBSTK'.
        ELSE.
          CHECK VBCOM-VBOFF = ' ' OR
                 LVBUK-LFGSK = 'A' OR LVBUK-LFGSK = 'B'.
          LVBMTV-STATUS = LVBUK-LFGSK.
          FELDNAME = 'LFGSK'.
        ENDIF.
      ENDIF.

Max

[Former Member]

all are structures and not able to understand. Kindly provide me table fields

Thanks

[Former Member]

It is not exactly matching the VA05 Order Qty.

Thanks

[Former Member]

Kindly check Code Gallery for Pending sale order (open) details report submitted by me.

https://www.sdn.sap.com/irj/sdn/wiki

hope it helps

anya

[Former Member]

resolved