05-17-2008 12:42 PM
Hi
can any one provide me some documents related to SAP Query & Infoset SQ01.to my ID
Regards
NTH
taj_jim@yahoo.com
05-17-2008 12:52 PM
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
05-17-2008 12:52 PM
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