SAP BODS Creating Embedded Dataflow - SAP BODS

What is SAP BODS Creating Embedded Dataflow?

You can choice an object in the obtainable data flow. There are two ways in which embedded Data Flow can be formed.

Option 1

Right click on the object and choice to create it Embedded Data flow.

make_embedded_dataflow

Option 2

Drag the whole and certify data flow from object library into an open data flow in the work space. Then, open the data flow that has been formed. Choice the object you want to use as the input and output port and click make port for that entity.

click_make_port

Data Services increase that object as assembly point for embedded data flow.

Variables and Parameters

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

The key structures are −

  • Data type of a variable can be a number, integer, decimal, date or a text string like 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 vision variables and parameters, follow the steps given below −

Go to Tools → Variables.

variables_and_parameters

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

definitions_and_calls

The Definitions tab permits you to construct 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.

Job
Local variables
Global variables
A script or conditional in the job
Any object in the job
Work flow
Local variables
Parameters
This work flow or passed down to other work flows or data flows using a parameter.
Parent objects to pass local variables. Work flows may also return variables or parameters to parent objects.
Data flow Parameters A WHERE clause, column mapping, or a function in the dataflow. Data flow. Data flows cannot return output values.

In the call tab, you can see the name of the parameter well-defined for all substances 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 click → Insert

variable_insert

It will generate a new parameter $NewVariable0.

Step 3 − Enter the name of the new variable. Choice the data type from the list.

select_datatype

Once it is clear, close the window. In a related way, you can describe the parameters for data flow and work flow.

dataflow_and_workflow

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BODS Topics