Skip to main content

User Defined Fields

Creating User Defined fields

User Defined Fields contains key and value pairs.These values can be used in:​

  1. Standard query filter conditions

  2. Advanced query filters

  3. Transform functions

  4. SAP username/password fields

The most important use of UDF is that we can pass on special parameters to command line export. For example, let's say we define a job such that anytime a database table has a new record, we need export.exe to run. The primary key of the newly inserted record can now be passed to export. In the standard query, you can use this parameter to filter the right record.

When package is transferred to another system, they are redefined.

Adding User Defined Fields​

  1. Under Tools, Configuration select User Defined Fields...

  2. Provide Key and Value pair

Using User Defined Fields in package​

  1. The syntax for using UDFs in standard relational/advanced query is
<< %key%>>. You can also use a longer form << Expand(‘%key%’)>>.

  1. The syntax in transform function is using the Expand function. Expand(“%key%")

  2. For SAP username/password, it is simply %key%.