T.Code FB03 & SQ01

[Former Member]

Hi Seniors,

Can anybody tellme what is the use of FB03 & SQ01 with detailed information please.

If i didnt mistake SQ01 is being used by ABAP Consultant not FICO Consultant please give me some more detail information pertaining SQ01.

Awaiting for your reply & points will be assigned.

Thanks & Regards,

KUMAR.B

[Former Member · Accepted solution]

hello,

FB03:- As u have idea that it is used for knowing information regarding document.such as posting date,document date,document type.

SQ01:- it is used for generating query.u can joint 2 or more tables and get the report.For using SQ01 usehould know about SQ02& SQ03.

SQ01:- used for authorization to access the query.

SQ02:- it is the important one by which u create the infoset.

SQ03:-Used for creating query.

First U create infoset by SQ02, very important thing is tht from menu bar set 'Environment Work Area' as Standard query Type.Then u join the tables.

the go to SQ03 & the SQ01.

Hope this answer will be helpful.

Regards,

Neha

[Former Member]

Dear Kumar,

There is no such comparison as both have nothing in common .

FB03 is used to display the documents which are posted in the system and stored in different tables for examples BKPF in which header information is stored and similrly BSEG,PAYR And BSEC etc.

the intial selection criteria is for viewing that particular documnet is Document Number ,company code and fiscal year.

if you are sure about the documnet no then go to the next selection criteria where many parameters are present and you give selection criteria.

SQ01 is 'maintaing query' screen.which is used both functional (though it is technical it is functional friendly) and technical people.

the main use of this is even without coding we can generate some customised reports but the restriction is it cant pull the huge data from the tables (incase if we are pulling it form data base tables as the can be pulled from different sourses ) .

before maintaing a query infosets and usergroups should be created .

still if you want further clarification just drop your mail id

best regards ,

Sunil

[Former Member]

Dear Kumar,

FB03 is for viewing a financial accounting document, whereas SQ01 is for creating a Query.

FB03 is purely FI, but SQ01 is used by functional and ABAP consultants. In SQ01, you can use infosets ( group of table or tables) and create queries out of it.

Regards

Venkatesh