SAP Query create repot ~

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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