cancel
Showing results for 
Search instead for 
Did you mean: 

Sap Quick viewer or quiry (SQVI)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

gomatheeswaran_palaniappa
Active Contributor
0 Kudos

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