Defaulting value on a DFF Segment using sql

Here are the steps to default a value on a DFF segment:

1) Go to DFF definition screen and open the segment which you want to add/update:

2) Click on Open button, then you see following screen:

3)  For default type select “SQL Statement” and in the default value give your sql:       

4) If you want to reference other fields in the flex you can do by using :$FLEX$.segment1

Example:

Select  col1   From sk_temp xt

Where 1=1 And  :$FLEX$.segment1 = xt.col2

Use :$FLEX$.valueset name if segement1 is based on a value set