Finding open sales order line items

[Former Member]

Hello,

First time poster and new to SAP so here goes:

I am trying to find a better method for finding our open sales order line items.

So far I am joining VBAK-VBUP-VBAP in that order and my scan logic is for sales document type (vbak-auart) of ZOR and ZDEW with an overall status (vbup-gbsta) of A or B.

This logic use to work but now all it does is timeout after 60 minutes.

VBAK has 6,766,828 total records in it

VBUP has 16,431,117 total records in it

VBAP has 12.9 million total records

Thanks,

Randy

[Former Member · Accepted solution]

Hi Randy,

Also, i would suggest you to build up a query from SQVI with table join option. This will be very much helpful.

Thanks & Regards,

C.L. Narasimhan

[Former Member]

HI Randy,

Use VA05 and modify the variant to fetch the values. Variants can be modified to provide the requested screen lay out.

Let me know in case you any doubts on this. I will send a detailed mail.

Thanks & regards,

C.L. Narasimhan

[Former Member]

Standard report T.Code: VA05 can be checked, if useful for your purpose. It has option of Open Orders available.

Regards,

Rajesh Banka

[Former Member]

All,

Thanks for the input and I have been testing out some of them.

Still no luck - I need a lot of line item details for this task:

63 total data elements

1 from VBUP

9 from VBAK

53 from VBAP

As a side note - I just ran my program for ZIRN orders with A/B status ran in 52 minutes.

Message was edited by:

Randy Burton

[Former Member]

All,

Thanks for the help.

What I have done is run the same program one time for ZDEWs and once for ZORs.

Strange thing is I can run them at the same time it it works fine - try to run it for zdew and zors in the same program - it times out.

Oh well.

Thanks again

[Former Member]

Hi Randy,

For your requirement VBAK&VBUPtables are enough.

Firstly you can read the table VBAK where AUART = 'ZOR' or 'ZDEW'.

After this you will get all the sales orders with the order types ZOR or ZDEW.

For these sales orders you can read VBUP tables.

In this table there is a field <i><b>delivery status</b></i>.

If this filed value is <i><b>C</b></i> then that line item delivery is completed.

if it is not equal to <i><b>C</b></i> then those line items are open sales order line

items.

Thanks,

shyla

[Former Member]

Try Transaction Code VL10C.

This should display a list of all open line item, which can be processed from here in background, if required.

Regards,

Rajesh Banka

[Former Member]

Hi Randy;

Try VBFA table, this would give you the link bet the SO and the subsequent deliveries.

Regards,

Mani.

[Former Member]

Mani,

Not sure I follow how I can use VBFA to find what line items are open?

Thanks

[Former Member]

Hi Randy;

Try the table VBEP, this would give you the Ordered qty and the Deliverd qty for a Sales order.

Regards,

Mani