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
Showing results for 
Search instead for 
Did you mean: 

SAP Query-SQ01

Former Member
0 Kudos

Hi

can any one provide me some documents related to SAP Query & Infoset SQ01.to my ID

Regards

NTH

taj_jim@yahoo.com

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi check this..

SQVI and SQ02/SQ01 are far more powerful than SE16 as they allow you to do table joins. SQ02 also allows you to create computed fields.

/people/community.user/blog/2008/02/08/sap-query-a-reporting-tool-for-functional-consultants-part-1

/people/community.user/blog/2008/02/11/sap-query-a-reporting-tool-for-functional-consultantspart-2

http://allaboutsap.blogspot.com/2007/09/sap-query-step-by-step.html

http://supplychain.ittoolbox.com/groups/groups.asp?v=sap-r3-log-mm&i=783523

SQ01 - Generate query

SQ02 - Creation of infoset and generattion of same

SQ03 - Creation user group and assigning infoset to same.

When you want to create infoset, dont use structure. Select data base table which will inturn display all data base table available and you can select the one required. You can also join two or more tables if rquired for display of fields as per requirement.

regards,

venkat

1 REPLY 1

Former Member
0 Kudos

hi check this..

SQVI and SQ02/SQ01 are far more powerful than SE16 as they allow you to do table joins. SQ02 also allows you to create computed fields.

/people/community.user/blog/2008/02/08/sap-query-a-reporting-tool-for-functional-consultants-part-1

/people/community.user/blog/2008/02/11/sap-query-a-reporting-tool-for-functional-consultantspart-2

http://allaboutsap.blogspot.com/2007/09/sap-query-step-by-step.html

http://supplychain.ittoolbox.com/groups/groups.asp?v=sap-r3-log-mm&i=783523

SQ01 - Generate query

SQ02 - Creation of infoset and generattion of same

SQ03 - Creation user group and assigning infoset to same.

When you want to create infoset, dont use structure. Select data base table which will inturn display all data base table available and you can select the one required. You can also join two or more tables if rquired for display of fields as per requirement.

regards,

venkat