Skip to main content

Iteration and ingestion in Query Chain

In a Query Chain, we can iterate over a set of values and ingest the data. The iteration process takes place looping in between a set of key values. Here in this example, we considered SAP VBAK (Sales Document: Header Data) table and VBELN (Sales and Distribution Document Number) column as one of the primary keys.   

Steps involved:

  1. Create a Query using static values
  2. Create a variable using an output Query
  3. Add the created variable in a Query
  4. Run the Query Chain using an output Query

 

Create a Query using static values:

  • Click the QUERY STUDIO module.
  • Hover on Query Builder snippet and click on Query.
2023-01-03_11-44-37.png
  • This action navigates to the Query page.
2023-01-03_11-46-17.png
  • Let’s select RD Datastore from the Profile drop-down list.
  • Add the required values and click on the Save.
2023-01-03_11-47-20.png
  • An Additional saving options pop-up window is displayed.
  • Under the Query Name text field, let’s add VBAK using 3 values.
  • Select the desired folder path and click on Save.
2023-01-03_11-49-54.png
  • A toaster message VBAK using 3 variables saved successfully! is displayed.
2023-01-03_11-58-14.png

 

Create a variable using an output Query:

  • Hover and click on Variable Explorer.
2023-01-03_11-59-14.png
  • This action navigates to the Variable Explorer
  • Click on Variable Builder.
2023-01-03_12-01-50.png
  • This action navigates to Variable Builder
  • Add the Variable Name, and Description text fields and select the Variable Type drop-down list.
2023-01-03_12-03-17.png
  • Select Output from query for Input options.
  • Select VBAK using 3 values for the Select Query.
  • Click Test Variable button.

Note: Here, the Selected Query is updated accordingly.

2023-01-03_12-05-49.png
  • A Results for USR_VBAK Variable with 3 values pop-up window is displayed that shows the variables list.
  • Close this window.
2023-01-03_12-07-28.png
  • Click on Save.
2023-01-03_12-08-08.png
  • A toaster message ‘VBAK Variable with 3 values’ Variable Created Successfully is displayed.
2023-01-03_12-09-04.png

 

Add the created variable in a Query:

  • Click the QUERY STUDIO module.
  • Hover on Query Builder snippet and click on Query.
2023-01-03_11-44-37.png
  • This action navigates the user to the Query page.
2023-01-03_11-46-17.png
  • Select SAP ECC Livewire from the Profile drop-down list.
  • Click the Navigator button.
2023-01-03_12-12-03.png
  • Search for VBAK table and click on it.
2023-01-03_12-13-02.png
  • This action loads the table.
  • Click the Local Filter icon.
2023-01-03_12-15-18.png
  • A Local Filter Expression for VBAK pop-up window is displayed.
  • Drag the Available Fields option and select VBELN(Sales and Distribution Document Number) column from the drop-down list.
2023-01-03_12-18-40.png
  • Drag the Available Operators and select Like from the drop-down list.
  • Click the Variable icon.
2023-01-03_12-19-29.png
  • A Variables pop-up window is displayed.

Note: By default, Predefined variables tab is selected.

2023-01-03_12-20-18.png
  • Select the User defined variables tab and select the variable USR_VBAK Variable with 3 values which loads the metadata slide screen.
  • Click on Test Result.
2023-01-03_12-21-58.png
  • The list of values is loaded in the Result text field.
  • Click Ok to load the variable.
2023-01-03_12-22-42.png
  • The expression VBELN LIKE ‘~ ~USR_VBAK Variable with 3 values # #’ is updated accordingly.
  • Click on Save to save the filters.
2023-01-03_12-23-27.png
  • The Local Filter icon is turned green which indicates the filter condition is added successfully.
  • Click on Save.
2023-01-03_12-39-29.png
  • An Additional saving options pop-up window is displayed.
  • Add SAP VBAK Variable Query under the Query text field.
  • Click on Save.
2023-01-03_12-42-59.png
  • A toaster message SAP VBAK Variable Query saved successfully! is displayed.
2023-01-03_12-43-35.png

 

Run the Query Chain using an output Query:

  • Click the QUERY STUDIO module.
  • Hover on the Query Builder snippet from the left pane options.
  • Click the Query Chain option.
2023-01-11_18-41-36.png
  • From the Data Source tab, drag and drop  Queries icon and double-tap on it.
2023-01-11_18-43-08.png
  • A Read data from Query pop-up window is displayed.
  • Let’s search with SAP VBAK Variable Query to populate the results.
2023-01-11_18-44-22.png
  • Select and checkbox SAP VBAK Variable Query to view its metadata as a slide screen.
  • Click on Select button to save the Queries widget.
2023-01-11_18-44-43.png
  • Click the Output tab.
2023-01-11_18-45-25.png
  • Let’s drag and drop an RD Output icon and double tap on it.
2023-01-11_18-45-56.png
  • An RD Output pop-up window is displayed.
  • Click on Select button.
2023-01-11_18-46-29.png
  • This action saves the RD Output widget.
  • Click on the Iterative Ingestion icon.
2023-01-11_18-47-33.png
  • An Iterative Ingestion pop-up window is displayed.
  • Let’s switch on Iterative Ingestion toggle button and select USR_VBAK Variable with 3 values from the Available Variables.
  • Click on Save button to save the Iterative Ingestion settings.
2023-01-11_18-48-02.png
  • Click on Execute Now button.
2023-01-11_18-49-06.png
  • This action executes the Query Chain.
  • Here, we can notice, the Iterative Ingestion icon turned green which indicates the settings are applied successfully.
  • Here the Query Chain is passed.

Note: Here the iteration and ingestion process take place in the background.

2023-01-11_18-59-16.png

 

 

Was this article helpful?