Skip to main content

Iteration and ingestion in FDR (Functional Data Reconciliation)

In an FDR scenario, 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 FDR using an output Query

 

1. Create a Query using static values:

  • Click the QUERY STUDIO
  • 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

 

2. 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

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

 

3. Add the created variable in a Query:

  • Click the QUERY STUDIO
  • 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 
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.
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

 

4. Run the FDR using an output Query:

  • Click the SCENARIO STUDIO
  • Hover on the Scenario Builder snippet from the left pane options.
  • Click theFunctional Data Recon.
2023-01-03_12-48-00.png
  • From the Data Source tab, let’s drag and drop Queries.
  • Double tap on the Read data from <Query> 
2023-01-03_12-50-57.png
  • A Read data from Query pop-up window is displayed.
2023-01-03_12-51-47.png
  • Let’s checkbox SAP VBAK Variable Query to display the Metadata for SAP VBAK Variable Query.
  • Click the Select button to save the Query widget.
2023-01-03_12-52-25.png
  • Drag and drop SAP Table icon onto the FDR page.
  • Double tap on Read data from Table.
2023-01-03_12-53-38.png
  • A Read data from Table pop-up window is displayed.
  • Select Connection Name as SAP ECC Livewire from the drop-down list.
  • Click the Navigator.
2023-01-03_12-54-39.png
  • A Navigator slide screen is displayed.
  • Search for VBAK and click on it.
2023-01-03_12-55-40.png
  • The VBAK table is loaded.
  • Click the Select button to save the SAP Table widget.
2023-01-03_12-56-10.png
  • Click the Reconciliation tab.
2023-01-03_12-57-10.png
  • Drag and drop the Map source & target fields icon onto the FDR session page.
  • Double tap the Map source & target fields widgets.
2023-01-03_12-58-02.png
  • A Map source & target fields pop-up window is displayed.
2023-01-03_12-58-51.png
  • Select the required keys and click on Save.
2023-01-03_13-02-39.png
  • A Confirm action pop-up window is displayed.
  • Click the Verified button to save the Map source & target fields widget.
2023-01-03_13-03-27.png
  • Click on horizontal ellipses icon.
2023-01-03_13-04-24.png
  • Click on Iterative Ingestion icon.
2023-01-03_13-05-10.png
  • An Iterative Ingestion pop-up window is displayed.
2023-01-03_13-11-11.png
  • Enable Source Iterative Ingestion toggle to display the Available Variables.
  • Select USR_VBAK VARIABLE with 3 values.
  • Click on Save to save the iterative ingestion.
2023-01-03_13-12-05.png
  • Click the Execute Now icon to run the FDR scenario.
2023-01-03_13-12-39.png
  • Here the FDR is failed and it loads exceptions.

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

2023-01-03_16-41-05.png

 

 

 

Was this article helpful?