Skip to Content
author's profile photo Former Member
Former Member

T.Code FB03 & SQ01

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2008 at 11:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2008 at 10:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2008 at 11:07 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.