topic Re: SAP Query create repot ~ in Application Development and Automation Discussions

SAP Query create repot ~

Former Member — Thu, 28 Feb 2008 01:27:26 GMT

hi expert,

i want to create basic list SAP reports by using the SAP Query tool for user . could yo telll me the tcode about the query tool .

could anyone give me some sample to create a query, or materials about this .

the field i want is

BKPF-BUDAT

BSEG-KUNNR

KNA1-NAME1

BLART

BSEG-WRBTR

any suggestion will be appreciate

thanks in advance

Re: SAP Query create repot ~

Former Member — Thu, 28 Feb 2008 01:32:12 GMT

Hi,

Use transaction SQ01 to create queries.

And just search forum or help.sap.com you can find lots of material on query creation.

Regards,

Atish

Re: SAP Query create repot ~

Former Member — Thu, 28 Feb 2008 02:45:06 GMT

You have to proceed as below: 1. Create User Group using transaction SQ03. 2. Create Infoset and assign User Group. Transaction SQ02. Here you specify required tables, relation. Field Group to identify the fields to be accessed as Input/Output in the query. 3. Create Query. Transaction SQ01 and assign the Infoset for relationship. Build of the selection and output parameters.

Re: SAP Query create repot ~

Former Member — Thu, 28 Feb 2008 02:56:20 GMT

Hi,

Tcodes are

SQ03 --> to create group

SQ02--> To create Info type

SQ01 --> To create Query.

But one problem here is

you can not join "Cluster table" & Pool table

Reward if usefull