Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Open Sales Order

Former Member
0 Kudos
450

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

10 REPLIES 10

Former Member
0 Kudos
179

Hi

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

Max

0 Kudos
179

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

Thanks

0 Kudos
179

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
0 Kudos
179

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.

0 Kudos
179

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

Thanks

0 Kudos
179

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

0 Kudos
179

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

Thanks

0 Kudos
179

It is not exactly matching the VA05 Order Qty.

Thanks

Former Member
0 Kudos
179

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

0 Kudos
179

resolved