on 08-28-2008 12:17 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.