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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Sales orders with out delivery

Go to solution
Former Member

‎10-16-2007 6:21 AM

0 Kudos

Hello,

Does any one have code for sales orders with out delivery?

Thanks.

1 ACCEPTED SOLUTION

Go to solution
jj
Active Contributor

‎10-16-2007 6:33 AM

0 Kudos

Check VBUK table to get sales order nos

where VBUK-LFSTK = 'A' ( The delivery status is 'A' if delivery is not created for this sales order.)

and VBUK-VBTYP = 'C' (Order)

and VBUK-VBOBJ = 'A'.

3 REPLIES 3

Go to solution
Former Member

‎10-16-2007 6:22 AM

0 Kudos

Hi,

What do you mean by the code for Sales Order without delivery.

A Sales Order can definitely exist without being delivered.

Cud u please explain ur requirement so that we can help u out.

Thanks and regards,

Himanshu

Go to solution
jj
Active Contributor

‎10-16-2007 6:33 AM

0 Kudos

Check VBUK table to get sales order nos

where VBUK-LFSTK = 'A' ( The delivery status is 'A' if delivery is not created for this sales order.)

and VBUK-VBTYP = 'C' (Order)

and VBUK-VBOBJ = 'A'.

Go to solution
Former Member

‎10-16-2007 6:36 AM

0 Kudos

Hi

Get the Sales order data from VBAK and VBAP tables into ITAB1.

For all entries of this table

fetch the data from LIKP and LIPS into ITAB2

where LIPS-VGBEL = ITAB1-VBELn and LIPS-VGPOS = ITAB1-POSNR.

Now delete the orders data (which are delivered) ITAB2 from ITAb1 table.

Left out Orders in ITAB1 are the orders without deliveries.

Regards

Anji