Copying a Query
The chapter starts with a simple case, describing the copying process of Queries. A new Query is created on the same InfoProvider. More complex cases are explained in the next chapter Application Scenarios.
First of all, the Type “Query” (first checkbox), as well as a specific Query on the left sub-screen of an SAP system, needs to be selected. As soon as a Query has been picked it will appear together with its corresponding InfoProvider below the left table.
The chapter starts with a simple case, describing the copying process of Queries. A new Query is created on the same InfoProvider. More complex cases are explained in Chapter Application Scenarios.
First of all, the Type “Query” (first checkbox), as well as a specific Query on the left sub-screen of an SAP system, needs to be selected. As soon as a Query has been picked it will appear together with its corresponding InfoProvider below the left table.
The Tool can be started by pressing the “Next” button. A check is made to assure that no other Query with the same technical name exists in the target system. In this case, the name has to be changed.
The next step includes choosing an SAP BW-System (Field “SAP System”), one or more InfoProvider-Types (Checkboxes “Type”) and a Target-InfoProvider on the right sub-screen. The chosen InfoProvider is shown below the right table. Tap “Next” to confirm the selection.
Now technical names of Reporting Elements and the included Objects can be changed manually. The “Execute consistency checks” button initiates the validation of the “new” Query. For example, it is important that technical names are correct and necessary Objects are part of the target system.
In a new window, the technical names of elements from the Source-Query (“Tech. Name (Target)”) and the Target-Query “(Tech. Name (Source)”) will be displayed.
Element | Display in Tool | possible Renaming | Mapping | New set up when copying |
Query | yes | mandatory | ----------------- | yes |
Global Structure | yes | mandatory, if Mapping of underlying InfoObjects has been changed | automatized | yes, if underlying InfoObject has been changed |
Key Figure | yes | no | automatized or manually | no |
Characteristics | yes | no | automatized or manually | no |
Variable | yes | mandatory, if Mapping of underlying InfoObjects has been changed | automatized | yes, if underlying InfoObject has been changed |
Calculated Key Figure | yes | mandatory, if Mapping of underlying InfoObjects has been changed | automatized | yes, if underlying InfoObject has been changed |
Restricted Key Figure | yes | mandatory, if Mapping of underlying InfoObjects has been changed | automatized | yes, if underlying InfoObject has been changed |
Local Structure | no | no | automatized | yes |
Element of local Structure | no | no | automatized | yes |
Condition | no | no | automatized | yes |
Exception | no | no | automatized | yes |
Cell definition | no | no | automatized | yes |
Selection | no | no | automatized | yes |
Formula | no | no | automatized | yes |
Using the “Mass Edit” function, Reporting Elements of different types in one Query can be renamed simultaneously.
The “Apply target values” button starts the final process of generating a new Query. A dialog window appears with the information that all replacements have been successful and the Elements can now be created. With “Start creation” the Query can be created. Afterward, a pop-up shows the Query’s Returncode.
In general, the Docu Performer writes all Reporting Elements after copying to the package $TMP. In some cases, this is not possible. This could be related to the settings (RSA1 > Transport Connection, Menu Edit > Transport) in your SAP system. If it is not possible to write the entities to the package you get the message below. That means copying was possible but writing to package not.
Changing an InfoObject to Field manually does NOT adjust the respective Base Object for Variables. That means you also have to manually adjust Base Objects from Variables.
© 2023 bluetelligence GmbH. All rights reserved.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy