Add virtual field (CMS012)
This procedure defines virtual fields.
In output management, if the information required in the XML output is not contained in a database table, the last option for adding fields is to use virtual fields. A virtual field is defined per printer file and XML section.
After creating the virtual fields, the fields can be selected in an element from (CMS009).
Virtual fields are also used in these programs:
- 'Information Browser Category. Open' (CMS010)
- 'Ad hoc Report Group. Open' (AHS100)
These types of virtual fields can be defined:
- Calculated fields
- Description from CSYTAB
- Name from CSYTAB
- Currency conversion
- Logical formula
- Date conversion
- Merge data
- Substring
- Translate Business Message Data
- Field from other section
In ad hoc reporting, additional type of virtual field are defined as Translate Business Message Data.
- Start (CMS006), select XML structure and use option 11='XML Structure. Open Section' to start (CMS007).
- Select structure and use option 11='XML Structure. Open Section Elements' in (CMS007) to start (CMS009).
- Click 'Virtual fields' to start 'Virtual Fields. Connect' (CMS012).