Extract database fields

The database fields in the system event table and the linked data tables, from which values are to be extracted, are specified in the fieldtoread XML elements. For each fieldtoread XML element, a line of the form

<attribute type="Type">Value</attribute>

is written to the output file.

Type is made up of the table name, the data field name, and an optional text field name.
Value is the value extracted from the corresponding data field. All values are written in text form.

Optionally, instead of the direct data field value, the value of the referenced table (textref XML element) can be extracted. The optional langfieldname specification extracts the language-specific text of the data field.

Supplementary information is extracted from the data tables using primary key relations.

XML element

XML attribute

Description

fieldtoread

name

Name of the table column containing the data field to be extracted

textref

tablename

Table name of the referenced data table

 

reffieldname

Name of foreign key

 

textfieldname

Name of the table column containing the data field to be extracted

 

langfieldname
(optional)

Name of the table column containing the language-specific data field to be extracted

fkpart

readfrom
(optional)

Direction of the substring forming the foreign key
Valid values: left, right
Default value: left

 

startposition

Position from which the substring is formed

 

length
(optional)

Length of substring
Default value: Start or end of the string (readfrom XML attribute)

Before data is actually extracted, a check is run as to whether the configured tables and data fields exist and whether the specified system user has appropriate access authorization.

Example

The extracted field values are written to the output file as attributes of a system event.

Unlocalized table fields:

...
<attribute type="VBAP-WERKS">SB</attribute>
...

Localized table fields:

...
<attribute type="VBAP-WERKS-NAME">Saarbrücken</attribute>
...