Automate

 View Only
Back to discussions
Expand all | Collapse all

Tip of the Week - Creating a Query from a Transaction Recording

  • 1.  Tip of the Week - Creating a Query from a Transaction Recording

    Employee
    Posted 06-29-2025 20:36
    Edited by Sigrid Kok 07-02-2025 11:42

    Create a Query from a Transaction Recording

    If you are not familiar with the tables you need to use, and you are familiar with transactions in SAP, you can find the tables by recording an SAP transaction.

    Fields that are in structures, instead of tables, will not be included in the recording.

    After you choose the fields, you narrow the data set that you want to download by specifying criteria.

    Choose the creation method and log on to SAP

    1. Click the File tab, and then click New.
    2. Click Query.
    3. Under Choose a Creation Method, click Create from Recording.


    1. On the Studio logon screen, do one of the following:
      • Click the SAP system box and then click the SAP system you want to log onto.Click Advanced SAP Logon. In the SAP Logon box, choose your SAP system, and then type your client number, user name, and password.

    To save your credentials for future sessions, check the Save as auto logon credentials box and type a name for the credentials in the Auto logon name box. The next time you log on to SAP from Studio, you will see your Auto logon name in the SAP system box and your other credentials. All you have to do is click the logon button.

    1. Click OK.

    Select the tables and fields

    1. In the Transaction Code box, type the T-code you want to record.
    2. In the Recording Description box, type a description for the recording. The description must be unique.
    3. In the Data type box, choose the type of result file you want to use for the downloaded data:
      • Excel worksheet
      • Access database file
      • Text file
    4. Click Start Recording


    The SAP GUI opens.

    1. Record the transaction. Be sure to enter data for all the fields that you want to include in your query.If you do not want to commit the data to SAP, exit out of SAP GUI instead of clicking Save.

    After you complete the recording, Query opens on the Workspace tab.

    1. Under Data Dictionary, click the arrow next to Recorded Transaction Codes (RC), and then click the arrow next to your recording.
    2. Drag a table to the workspace, or double-click it.


    The fields that you changed during the recording are already selected.

    Note:

    Some of the tables might contain only fields such as check boxes. Click the table, click Inspect Table, and confirm that the table contains fields that you want. If it does not, click the red x in the upper right corner of the table to remove it from the query.

    1. Check the Output box for each additional field that you want to download data from SAP.
    2. Check the Criteria box for each field you want to use to define the data set that you are downloading.


    Define the operands for the Criteria


    For example, if you want to tell Query to return material data based on a range of material numbers, check the Criteria box for the MARA.MATNR field.

    To check your Query for accuracy select Preview Run

     

    Once complete, Map the query, in this instance I used the AutoMap function

    Remember, you can create not only a query, but a roundtrip data change scenario, that you will Query data from SAP and then create a transaction to load changes into SAP.

    Once complete, Go to the run tab and finish the run…

     



    ------------------------------
    Bill Wiseman
    Senior Solutions Engineer
    *Precisely Software Inc.
    Cumming FL
    ------------------------------