on 07-19-2011 1:11 PM
Hi,
We have sales report requirement and i am trying achive this through SQVI.
Please explain logic of customizing report through quiry. Ie, Table join, logical database and sap quiry infoset.
And requitrement is as mentioned below.
Sales order No.
customer
PO nO.
PO. date
line item
material
plant
required delivery date
total order qty
Qty delivered
open order qty
open order value
Best regards,
ramesh
Hi,
You will need to add tables VBAK, VBAP, LIKP & LIPS. The query builder will connect the tables itself.
Also there is a lot of material available about query building on this forum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please send the quiry builder material for the below mentioned e-mail ID.
System is not allowed mail id so below id belongs to Gmail
Text Removed
Best Regards,
ramesh
Edited by: Lakshmipathi on Jul 26, 2011 2:25 PM Please dont deviate the forum rules by asking to share any SAP information to personal mail
Hi,
Pl find relevant tables and follow the below approach:-
[SAP help on SQVI|http://help.sap.com/erp2005_ehp_05/helpdata/EN/d1/44f2b5c7f411d296080000e82de14a/frameset.htm]
Regards,
P Gomatheeswaran
Edited by: Gomatheeswaran Palaniappan on Jul 19, 2011 5:58 PM
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 | |
7 | |
6 | |
3 | |
3 | |
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.