cancel
Showing results for 
Search instead for 
Did you mean: 

Sales order quantity and dleivery quantity report

Former Member
0 Kudos

Hi Gurus

can any body provide me light on this

According to the my user requirements he wants to have a report like

1.customer

2.material

3.price

4.sales order

5.delivery quantity

Is there any standard Sap report is avilable for this . i had checked in VA05 but delivery quantity is not coming

Regards

satish

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

U have to create query by using transaction SQVI.

In Quick View Screen--Data Source--Select Table Join

Go to insert Table

Insert Table and enter following Tables one by one.

1. LIPS

2. VBAP

3. VBAK

4.VBAK

Select Input And Output as per ur reqmt

1. LIPS-LFIMG

2. VBAP-Matnr

3. VBAK-NETWR

4.VBAK-KUNNR

Exexute it and u will get desired result

Regards

Amit Gupta

Former Member
0 Kudos

Hi,

2 solutions :

- Read OSS note 37871 : add new fields in VA05 to display open quantity. It's easy to deduct the delivery quantity or to modify the example code.

- Create abap query by adding code to read delivery quantity in ref to sales order / item (with VBFA or LIPS).

Regards,

Lionel

Lakshmipathi
Active Contributor
0 Kudos

Dear satish

There is no standard report available to generate the required datas. However, you can table join in SQVI the following tables:-

- VBAP for Sale Order reference, Item, Order quantity, Net Value

- LIPS for Delivery reference, item, quantity delivered

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Satish,

As of my knowledge we dont have a standard report like that,

but we can create a view with the help of the ABAPer or we can create a query in SQ01.

But for this kind of requirements its always advisible to create a query .

Regards,

Vvieks

Former Member
0 Kudos

Hi,

for all the standard report you can see SAP1 T-code.

For this requirement you have to make query. use SQVI for it.

Thanks,

Raja