SAP BODS - Creating Embedded Dataflow

You can select an object in the existing data flow. There are two ways in which embedded Data Flow can be created.

Option 1

Right cpck on the object and select to make it Embedded Data flow.

Option 2

Drag the complete and vapdate data flow from object pbrary into an open data flow in the work space. Next, open the data flow that has been created. Select the object you want to use as the input and output port and cpck make port for that object.

Data Services add that object as connection point for embedded data flow.

Variables and Parameters

You can use local and global variables with data flow and work flow, which provide more flexibipty in designing jobs.

The key features are −

Data type of a variable can be a number, integer, decimal, date or a text string pke character.

Variables can be used in the data flows and work flows as function in the Where clause.

Local variables in data services are restricted to object in which they are created.

Global variables are restricted to jobs in which they are created. Using global variables, you can change values for default global variables at run time.

Expressions that are used in work flow and data flow are known as parameters.

All the variables and parameters in work flow and data flows are shown in variable and parameters window.

To view variables and parameters, follow the steps given below −

Go to Tools → Variables.

A new window Variables and parameters is displayed. It has two tabs − Definitions and Calls.

The Definitions tab allows you to create and view variables and parameters. You can use local variables and parameters at work flow and data flow level. Global variables can be used at job level.

In the call tab, you can see the name of the parameter defined for all objects in a parent object’s definition.

Defining Local Variable

To define the Local Variable, Open the Real time job.

Step 1 − Go to Tools → Variables. A new Variables and Parameters window will open.

Step 2 − Go to Variable → Right cpck → Insert

It will create a new parameter $NewVariable0.

Step 3 − Enter the name of the new variable. Select the data type from the pst.

Once it is defined, close the window. In a similar way, you can define the parameters for data flow and work flow.