How to use SQ02 - SAP Query: Maintain InfoSet

SAP Transaction Code - Details

• Transaction Code: SQ02

  Description: SAP Query: Maintain InfoSet

  Release: S/4HANA and ECC 6

  Menu Path:

  • Accounting > Financial Supply Chain Management > Treasury and Risk Management > Transaction Manager > Information System > Tools > SAP Query > Maintain InfoSets
  • Accounting > Financial Supply Chain Management > Treasury and Risk Management > Credit Risk Analyzer > Tools > SAP Query > InfoSets
  • Accounting > Bank Applications > Loans Management > Information System > Tools > SAP Query > Maintain InfoSets
  • Tools > ABAP Workbench > Utilities > SAP Query > InfoSets

• • Program: SAPMS38O

    Screen: 50

    Authorization Object:

  • Development Package: SQUE

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: SQ02 - SAP Query: Maintain InfoSet

  
  Overview: 
  SQ02 is a transaction code used in SAP to maintain InfoSets. An InfoSet is a logical view of the database tables that are used to store data in SAP. It is used to create queries that can be used to access and analyze data stored in the database. 
  
  Functionality: 
  The SQ02 transaction code allows users to create, modify, and delete InfoSets. It also allows users to assign authorization groups to InfoSets, which determines who can access the data stored in the InfoSet. Additionally, it allows users to assign user groups to InfoSets, which determines who can use the query created from the InfoSet. 
  
  Step-by-step How to Use: 
  1. Enter the SQ02 transaction code into the command field and press enter. 
  2. Select an existing InfoSet or create a new one by clicking on the “Create” button. 
  3. Enter a name for the InfoSet and click “Save”. 
  4. Select the tables that you want to include in the InfoSet by clicking on the “Include” button. 
  5. Assign authorization groups and user groups to the InfoSet by clicking on the “Assign” button. 
  6. Click “Save” when you are finished making changes to the InfoSet. 
  7. Click “Activate” to activate the InfoSet and make it available for use in queries. 
  
  Other Recommendations: 
  It is recommended that users test their queries before using them in production environments, as incorrect queries can cause unexpected results or errors in production systems. Additionally, it is recommended that users regularly review their InfoSets and update them as needed to ensure that they are up-to-date with any changes made to the underlying database tables.